This doesn't work. If you add the following to the list of inserts and try you'll see why:

insert into #t1 select 'travolta', 'carlos'

insert into #t1 select 'sainz', 'john'

or pass a NULL for the employee parameter and do:

WHERE region = @region and (employee = @employee or @employee is null)

I don't see the pont in these two in the query above since they will both always evaluate to 0

CASE WHEN DATENAME(dw, @StartDate) != 'Sunday' and DATENAME(dw,...

Have a look at these:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency_members.aspx

http://msdn.microsoft.com/en-us/library/t9x04ed2.aspx

No problem. I thought the CodeProject article, 'Localization of SSRS Reports' , looked promising. Let us know the direction you go and any further useful resources you find along the...

This might help:

http://www.letmegooglethatforyou.com?q=localizing+SSRS+reports

If you mean the TargetServerURL property in Visual Studios project properties dialog then its:

http://servername/ReportServer

Take a look at this, it may help:

http://www.codeproject.com/KB/database/PassingArraysIntoSPs.aspx

Amit Lohia (2/4/2009)

Here is the logic but if you want me to write the...

Any possibility you could expand on this?

A slight correction :). Having looked at this further it seems that the INFORMATION_SCHEMA.ROUTINES view does not split the procedure definition over more than 1 row it in fact only...

This still suffers from the same problem, in that the ROUTINE_DEFINITION column is only 4000 characters long. Any stored proc longer than 4000 characters in length is split over two...

Unfortunately this doesn't quite work, see the explanation in the following article:

http://www.sqlservercentral.com/articles/Stored+Procedure/62975/

See the link below for a good example of doing an 'UNPIVOT' with SQL 2000

http://wardyit.com/blog/blog/archive/2006/05/16/105.aspx

And why? 🙂