Non Defined

I extract date and time  from dateTime filed in TSQL as

 

select

CAST(CONVERT(varchar(8),vm_dm_StudentDet.Dep,112) AS int) DepDate,

Cast(CONVERT(VARCHAR(8),vm_dm_StudentDet.Dep,108) AS time) DepTime,

Cast(CONVERT(VARCHAR(8),vm_dm_StudentDet.Dep,101) as date) dt

from vm_dm_StudentDet

if you test this on current date you use as follow.

select

CAST(CONVERT(varchar(8),GETDATE(),112) AS int) DepDate,

Cast(CONVERT(VARCHAR(8),GETDATE(),108) AS time) DepTime,

Cast(CONVERT(VARCHAR(8),GETDATE(),101) as date) dt

Effort is important, but knowing where to make an effort makes all the difference, read story below:

 

A giant ship engine failed. The ship’s owners tried one expert after another, but none of them could figure but how to fix the engine.

Then they brought in an old man who had been fixing ships since he was a young. He carried a large bag of tools with him, and when he arrived, he immediately went to work. He inspected the engine very carefully, top to bottom.

Two of the ship’s owners were there, watching this man, hoping he would know what to do. After looking things over, the old man reached into his bag and pulled out a small hammer. He gently tapped something. Instantly, the engine lurched into life. He carefully put his hammer away. The engine was fixed!
A week later, the owners received a bill from the old man for ten thousand dollars.
“What?!” the owners exclaimed. “He hardly did anything!”
So they wrote the old man a note saying, “Please send us an itemized bill.”

The man sent a bill that read:
Tapping with a hammer…… . …….. …….. $ 2.00
Knowing where to tap……… …….. ……… $ 9,998.00

Moral of story is . . . . . . . . …. .. .

Effort is important, but knowing where to make an effort makes all the difference

With reference to virtual lab page

MSDN Virtual Lab: BizTalk Server 2010: Examining a BizTalk Application New!
MSDN Virtual Lab: BizTalk Server 2010: Creating a BizTalk Orchestration New!
MSDN Virtual Lab: BizTalk Server 2010: Creating Transactional Business Processes New!
MSDN Virtual Lab: BizTalk Server 2010: Monitoring Business Activity New!
MSDN Virtual Lab: BizTalk Server 2010: Automating Business Processes New!
MSDN Virtual Lab: BizTalk Server 2010: Calling a Web Service from an Orchestration New!
MSDN Virtual Lab: BizTalk Server 2010: Creating a BizTalk Map New!
MSDN Virtual Lab: BizTalk Server 2010: Creating and Configuring BizTalk Schemas New!
MSDN Virtual Lab: BizTalk Server 2010: Creating Pipelines New!
MSDN Virtual Lab: BizTalk Server 2010: Deploying and Managing BizTalk Applications New!
MSDN Virtual Lab: BizTalk Server 2010: Integrating with Adapters New!
MSDN Virtual Lab: BizTalk Server 2010: Routing BizTalk Messages New!

I found following video excellent reference . Sorry for silver light plug-in require for watch this video

While installing biztak 2009 at windows 7 on my personal computer i got following error

Error 5009.Registration of BAM performance counters failed. Return code -1.

, after searching in google, i found following solution

Run the command “lodctr /r ” as administrator. (This rebuilds the performance counter registry.)

pl Sql has function “Extract” this functions works wonders. I used it at many places in my application , i write some samples here

Years

select EXTRACT(YEAR FROM DATE ‘2008-3-17’)YEAR from dual;

Months

select EXTRACT(Month FROM DATE ‘2009-3-17’)Months from dual;

Day

select EXTRACT(day FROM DATE ‘2009-3-17′)Days from dual;

and how i used it my query

select * from tblSales_V where salesId in (select SalesId from OUTLET_SALE_V where outlet_Id =’001198’)
and EXTRACT(YEAR FROM issue_Date) = 2005

chears

PopUp form can be open through two ways from code behind, you can use both way , parameters can be send through Query string as well


protected void Button1_Click(object sender, EventArgs e){
OpenNewWindow(”test.aspx”);
OpenNewWindowUsingResponse("test.aspx");
}

public void OpenNewWindow(string url)
{
ClientScript.RegisterStartupScript(this.GetType(), “newWindow”, String.Format(”<script>window.open(’{0}’);</script>”, url));
}

Public Void OpenNewWindowUsingResponse(string Url)
{
Response.Write("<scr" + "ipt>rn");
Response.Write("open('" + Url + "');rn");
Response.Write("</scr" + "ipt>");

}

Both Works fine