Hi Andy,

What to do in case you've more than 1 parameter and you've to use all of the parameters for dynamic search.

like,

select *

from employees

where (@p1 is null or...

There is no such thing called, FOR EACH ROW, in SQL server. So, if you want to execute trigger in case more then one rows are inserted into a table,...

Never mind, I found the solution:

;with c AS

(

select * from @employee

)

select *

from c

where not exists

(

select id from @temp

except

select Employeeid from c

)

Thanks for your replies Ninja, but my situation is little bit different.

sample data:

declare @employee table (EmployeeId int, EmpName varchar(32))

insert into @employee values (1, 'test1')

insert into @employee values (2, 'test2')

insert...

SQL 2005 Beta works using Framework 2.0 Beta version which is different from Framework 2.0 release version.

you might be able to achieve this result using PIVOT feature in SQL 2K5. Have a look in BOL. Ofcourse, column names should be unique.

I would say use new features of SQL 2005 i.e. ROW_NUMBER(), RANK() with OVER(). With The approach mentioned in the article, you are not sure if you've updated the right...

I've a bit of idea on this. Insert textbox from Toolbox on the form. Right click on the textbox and select Expression. There you can select variables (heaps of variables...

If it is Analysis Services 2005 then you can create time dimension using Buisness Intelligence studio 2005. Just right click on dimensions and add new dimension. then follow the prompts,...

If you are just looking for a last date of previous month you can also try this:

select getdate() - datepart(d,getdate())