search this site for "reporting service" and you'll find enough to start with

my 2ct (not knowing the exact buisiness rrule)

select  case when day(getdate()) > 14 then

   DATEADD(d, -1, DATEADD(m, 1 + DATEDIFF(m, 0, getdate()), 0))

else

  convert(datetime,cast(year(getdate()) as char(4)) + '-' + cast(month(dateadd(m,1,getdate())) as char(2))...

"server=localhot;uid=sa;pwd=;database=Northwind" 

I guess you want to connect local.

Try server=.

or server=localhoSt

btw : even on dev/test server it is not wize to have sa-password...

- first check out who or what is blocking and consuming.

( maybe http://www.sqlservercentral.com/scripts/contributions/111.asp can help)

- Is it just a job or was it a maintenance plan you've deleted ?

First : start you sp with set nocount on (unless you realy need the rows info)

Why aren't you using a transaction ?

- view-triggers only fire when the view is being used !

- you could place triggers on the underlying objects

Never mind  !

I found out that I had to merge the cells over the needed span.

just my 2ct

we always have a clustered index (even if on a identity or current-datetime column if no other suggested by the development team...

If I'm correct ...

if you want to be sure it is being run wit isolation level x, you can set the isolation level (at the beginning) in your sp...

U2U will provide you a good basic knowlage.

One first has to lean to crawl, walk and then start running.

Flexcom-azlan (azlan.be) also does a good job.

Compare prices and jump onto promotions....

also in that case you can use profiler to generate the script so you can capture all sql to a file.

Start profiler, create a trace and then save it as...

duplicate posts ......

Thanks for...

Can you do a repro ?

if yes, use Query Analyser to debug the proc  and set brakepoints to these positions so you can check the content of all varriables and...

just my 2ct :

- having NULLs for replacement - values ?

- or using case-expressions without an ELSE pitfall ?

like andrewkane17 specified, shrinkfile or shrinkdatabase will solve your problem.

You can also perform an alter database set AUTO_SHRINK on, but that is not...