Simple but Nice one ..

is Microsoft dropping support for BIDS ?

Hi

Create Table myTable(ID Varchar(20), ServiceDate DateTime,GUID Varchar(20), Description Varchar(100))

--Composite Key - ID and GUID

INSERT INTO myTable VALUES('ABC','01/02/2011','GUID1','TEST1')

INSERT INTO myTable VALUES ('ABC','01/03/2011','GUID2','TEST2')

INSERT INTO myTable VALUES('DEF','01/04/2011','GUID3','TEST3')

INSERT INTO myTable VALUES('GHI','01/05/2011','GUID4','TEST4')

INSERT INTO myTable...

Hi

Another way is to create a ssis /DTS package and call 8 execute sql task parallely and provide the parameter accordingly and run

if you change the data type of d1 to decimal then answer will be change.

Excellent Question.

Now i am looking Query optimization and all the objects shown in execuation plan.Do you have any idea where i can find some good thoughts to go in...

You can not use any special character as a first later of procedure name except _ .

I think this part is not correct

INSERT INTO @student

VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99)

it will throw error.

Good question but i think it will not come under Header Truncate in Transaction

I think this question will come under UNION and UNION ALL diff.

Perfect explanation and example .

🙂

By this way you are not able to hide this report by user Because when user log he will be able to see all the reports name(menu) and when...

HI

Hust try these steps

1) Double click on data source

2) select credentials and then fill the required user info

like windows authonication or other way...

like others i found the same error in

set @i += 1 this line of code.

after doing like this

set @i= @i + 1 it will ...

its all about the database setting of ANSI_NULLS

Set ANSI_NULLS off / on

But by default database settings for ANSI_NULLS is ON so you will get nothing...

correct answer will be 1) Currentdate+2

bcz if you see the question first 2 lines are commented.