ColdCoffee (8/31/2010)

---

WayneS (8/31/2010)

---

This query should help you see the differences:

SELECT SYSDATETIME() AS SYSDATETIME

,SYSDATETIMEOFFSET() AS SYSDATETIMEOFFSET

,SYSUTCDATETIME() AS SYSUTCDATETIME

,CURRENT_TIMESTAMP...

Erik,

Thanks for the feedback.

IF (SELECT COUNT(*) FROM inserted WHERE my_column = 'XX') = 1

You could have > 1 row in the inserted table. It might be better to change this...

Does this get the information that you're looking for?

SELECT 'IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = ' + QuoteName(dp.name, char(39)) +

...

This query should help you see the differences:

SELECT SYSDATETIME() AS SYSDATETIME

,SYSDATETIMEOFFSET() AS SYSDATETIMEOFFSET

,SYSUTCDATETIME() AS SYSUTCDATETIME

,CURRENT_TIMESTAMP AS [CURRENT_TIMESTAMP]

...

Well, you might want to look at the GetUTCDate and SysDateTimeOffset functions.

On this thread, isn't that a given?

Actually, I have email notification set...

It's pretty much impossible to have one field...

I agree completely with...

I've downloaded a free copy of Oracle before (kind of like SQL Express). This is the link to their downloads.

Edit: and this is the link to the 10g free version.

If I understand this correctly, under one condition you want an integer, and under another condition you want a string? This can't be done. However, you can convert the integer...

ANY article by Jeff will definitely provide INSIGHT into things that you have never considered.

If your "loop" is a cursor, you might want to also look at the "15 ways...

Uncle Moki (8/31/2010)Maybe I should rephrase my question given the new info - Any idea why the type-conversion problem in the omitted CTE Section throws an error message when my...

Lutz already showed you how to do this over here. Especially relevant is the ROLLUP clause of the SELECT statement.

SQLWannabe (8/31/2010)

---

No, not yet. We've been focusing on other things. However, I will probably get back to it this week. I'm going to try dropping all the indexed views then...

1. Yes, group by does use indexes, if present.

2. It sounds to me more an aspect of having large tables without supporting indexes.

Can you post an execution plan? This...