Good Example John

You can use Linked server concept or a SSIS package to transfer your records from one server to other.

Good question, i learned some thing out of it.

it's all depends on ANSI_NULLS OFF/ON

Good Question Tom:-)

the above Query works with short names of the month

Declare @month as varchar(10)

set @Month = 'Dec'

select Month(@month + ' 1 2010')

did you re compiled the sp

Can you tell us what exactly you want to do with the case statement

in the first case statement you already said as 'Then 1' and wrote insert statements.

Please check the...

Hi

Try this One

Format(Cdate(Fields!dt.Value),”dd-MM-yyyy”)

Please look at the URL:

http://www.sqlservercentral.com/articles/Administration/2582/

Please Check the below Query might be useful as i don't know how you are storing the shift time in the table.

declare @start1 varchar(10)

set @start1 = '06:00'

declare @End1 varchar(10)

set @End1...

Which version of the sql you are using 2005/2008

Hi All,

I have similar kind of requirement where i need to change the amount into the USD,but in my case the amount will be in different currency format say for...

For this Error please go the variable section and change the DataType to Object.

Hi,

Can we pass all the columns to the procedure as a table parameter or as an XML?

which one will be better for performance?

string or XML or a table?