Yes, or WHERE CAST(CLOG.RecvdDate AS date) = '20191120'.  I think casting as date preserves sargability (provided that the column is datetime in the first place).

John

Edit - ignore: posted at the same time as the one above,

• This reply was modified 5 years, 10 months ago by John Mitchell-245523.

If you change the port to a different one from that which it's using currently, then yes, you'll need to restart.  If you plan to keep using the same port,...

Without being able to see your tables, it's difficult to advise.  Have you tried capturing @sqlquery and running it from a query window?

By the way, your stored procedure is horribly...

If you're copying 60GB from one place to another, then it's not going to be quick - and how slow it is will depend on your hardware.  Do you really...

What is not working?  You haven't shown us what you've already tried.  And please explain what you mean by "to set prior to start date"?  In your expected results, each...

You can use the LAG function to get the start date of the next row.  Give it a try, and post back if there's anything in particular you don't understand.

John

Check the value of SET QUOTED_IDENTIFIER for the connection with PowerShell, or just alter your script so that it uses [ ] instead of " " for identifiers.

John

John

SentryOne and Redgate's SQL Monitor are two alternatives to SolarWinds - you may wish to see whether they offer better value.  But if you want to do this stuff, I'm...

It's a CASE expression, not a CASE statement. I wouldn't normally be so pedantic, but here the distinction is important.  An expression evaluates to a value, where as a statement does something,...

This is the only way that I know of doing it.

John

Those tables are going to get inserted, updated and deleted as often as if they were in the publication database, so if it were me I'd use the same caution...

(1) Because every non-aggregated column in your SELECT list appears in your GROUP BY clause

(2) Because the CASE expression doesn't have any effect on the Names, CardType partitions

John

I imagine for this you'd need a third table, a junction table, since a cycle has many parts and each part can be used in many cycles.

John

I think you can put an EXECUTE AS clause in your trigger definition.  Alternatively, use a SQL Audit instead of triggers.

John