Hi Brendan,

The reason it fails is that the puTOP_SECTIONID is treated as a single value of "8,10,2,4" and not individual values of 8, 10, 2, 4.

The IN clause is...

Hi,

If you need to backup tempdb then backup the model database as it is used as a template for creating the tempdb database when the server is started.  The only...

Hi venkat,

Have a look at the function READTEXT in the SQL help it will explain how to retrieve the image data.

Its basically a three part operation. 

Regards

Richard...

Hi Lars,

Thats because the table name has to be actual name and not variable.  The way around this is to use dynamic sql.  There is a performance hit, not much,...

Hi,

You can only use INSTEAD OF triggers on views with the WITH CHECK OPTION set.  Personally I would create the trigger on the table.  That way all entries points to...

Hi David,

After re-reading your query I suddenly realised you where trying to calculate the number of orders for the month

Sorry for the bum answer...

Hi,

Try this. 

select convert(char(7),OrderDate,120), CustomerID, count(*) from dbo.Orders

group by OrderDate, CustomerID

order by OrderDate

compute sum(count(*)) by OrderDate

I think it will generate what you want.

You do not need to specify the convert...