Lynn!!!

Lynn Pettis (4/5/2009)

---

I didn't call you a noob. You are new to this forum, and many of us have seen these types of questions many times. There has,...

Hey everyone,

Thanks for all the comments! My initial post was a reflection of my first reaction, and I agree that maybe 'short' is a better word than 'rude'. ...

Hey Jeff,

I'm with you on the 'why use an empty string or spaces as criteria' thing; although I guess there is some wild and wacky legacy code out there. ...

Hey Vinay,

Typically you would write a procedure to implement the sliding window, and it would 'slide the window' on both tables inside a transaction.

Sorry for the quick reply but I...

New Zealand!

Have fun this afternoon.

Paul

Hey Flo!

Talking of time zones, it's 10:36pm Sunday night here 😉

So it's more "good night than good morning".

The pedant comment made me laugh!

I had no idea there were time zones...

Well you are free to...

If the rule is unwritten then how was the OP supposed to be aware of it?

Why not just state the unwritten rule to the OP?

Why say the OP is unqualified...

Hey all,

Unless I am missing something fundamental, the timezone offset from GMT of the local server is given by:

SELECT DATEDIFF(HOUR, GetUTCdate(), GetDate());

and the time in the timezone with GMT time...

One INSERT, UPDATE or DELETE statement (assuming no triggers) can INSERT to two tables if an OUTPUT clause into a table variable is used 😀 😀 😀

Boolean_z,

Set ANSI_PADDING ON and your life will improve measurably 😉

Books Online

---

In a future version of SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option...

Why would your being rude to someone you have never met...

INSERT INTO Discussion SELECT $0.02 WHERE account_name = SUSER_SNAME(): 😀

Bob Hovious (4/3/2009)

---

The procedure was written to allow nulls to be passed for the @codeID parameter. Oddly, it makes...

Some cool stuff so far...can't wait for someone to wirte an XML/XQuery version just for giggles!

:rolleyes:

Good answer flo - it does exactly what the OP asked for, and efficiently too, with one minor comment: The UNIONs should be UNION ALLs (constant scan instead of merge...