Yup, no need for a cursor nor a temp table.  However this is one rare case when the cursors and temp tables beat the set based (in case of triangular...

Ben, run all 3 versions of your code and see for yourself.  Even at 10 000 rows, the convert will most likely be constantly slower.  At millions it's not even...

Check out those tables, then all you'd need to do is pivot the data :

Select * from master.dbo.SysUsers

Select * from master.dbo.SysLogins

SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))

IIRC, there's a slightly faster version to make this conversion (like 5% faster), but I can't recall what it is.  Anyhow if you are not...

You got me interested, what were those questions?

I'm not sure I'm following here.  Care to expand a little on your idea?

It's not that you must.  I think you came on one of the rare exceptions.

Something like this should do it.

ORDER BY FullName, s.[Phone], s.[HomePhone], a.[PersonalEmail], s.[tyUserID], s.[Email], ShippingAddress, u.ttUserID ASC

I can't wait to see what other dbas have to say about this one.  I'm sure there must be a way for you to make this change without stopping the...

There seriously can't be that many hits a second to continuously block that object.  Are you sure that there isn't a dead lock already in place???

DECLARE @sql AS VARCHAR(8000)

SET @sql = 'SELECT ''' + @TableName + ''' As TableName, COUNT(*) AS Total FROM dbo.' + @TableName

INSERT INTO dbo.Stats (TableName, Total)

EXEC (@SQL)

[Edited]

How about disabling the trigger first (alter table tblname disable trigger trname).

Then dropping/modifying it.

Check out the datadiff function.  Then decide how you want to present the data and go from there.

Month and year table are usefull to do a left join so that months and years without data can still be displayed.  The category table doesn't make much sens to...

That's why 2 heads are better than 1 .

Happy posting.