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.

I'd like to see the create script for this DB .  Permissions included lol.

Thanks for sharing this.

Care to send this in the scripts section of the site?  That way It'll be more accessible to the users who might need this info.

You need one table for the gaz and one for the electricity.

The basic format will look like this :

clientID, ReadDate, Quantity, CostPerUnit (can be in another table with cost,...