can you please give small example how to write dynamic query ...Thanks

GilaMonster....Thanks for your reply ..!:-)

Okay Thank you very much for your reply..I have small question here..its different from previous question

Scenario : Below query is searching for Member_Id

Ex: Select c1,c2 from t1 where Member_ID=@MemberID

When...

HI , I don't know what is the use of Included columns or Creating index on multiple columns..if we create 2 separate indexes obliviously we will see 99% performance improvement...but...

First Apologies for delay in response:

Firstly Thanks to

GilaMonster,Jeff Moden,Eirikur Eiriksson,CELKO,Ed Wagner,MMartin1,MadAdmin for your valuable time

--Jeff I'm here 🙂

Yes, if we use 2 unions it will scan the table...

That's Correct..but still you can use IIF to solve problem

=IIF(Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "ext" , "Phone List",

IIF(Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "cell" , "Cell Phone...

Okay..thanks..! as of know i don't want to include holidays just last 5 business days and next 5 business days is enough..

Hi Sean, Thanks for your reply...Is there any way we can do same using Sql Query without using calender tables?..Thanks

Thank you everyone for your valuable reply.i have created indexes and its working fine.Thanks

Hi Mate I know that i'm doing wrong..but thing is like if i get some idea how to do it i can finish as early as possible. Well i...

Thank your reply..if you can some tips that really helpful to me..thanks anyway for your reply.

I can understand but i have got very less time..It would be really helpful if you can give some hints or tips..which makes the work done faster.Thank You.!!

Jack, I have done it..thanks for your reply..!! i have recently added new post, Please help me out thanks

Please help me out and Please find attached image..thanks

The objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance of...

Forum post..!! i can't copy and past it here..thanks