My office let me bring home an additional monitor when they sent me home to work.  Very helpful!  However, after 9 weeks my home office chair was giving me...

So like I asked before... what would you...

Hi, they are not, I  have one table called master, the others are named like acc_ and some numbers and letters after that. All I am trying to do...

First, if you get into the habit of posting "readily consumable data", you'll stand a much better chance of getting a coded answer and getting it a lot quicker.  Here's...

While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always...

@jeff - for some reason the post you quoted in your previous post isn't showing the quote. Your reply to me is though! When I view in Gmail on...

While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always a consideration...

Sorry, it wasn't directed at you.  It was a post I commented on when it first came out and...

As general issues go does this require ##temp to have global scope?  Also, why make the variables varchar(max)?  I got it to work like this

drop table...

My recommendation is that you, if you're using them, that you forget you ever saw "incremental rCTEs" regardless of the number of rows involved.  Please see the following article for...

Why not just use a SEQUENCE?

That's nothing.

How about 2 multi-million rows tables (one of them is closer to billion) joined by a value extracted from an XML column?

Yes, by XML_col.value('XML path', 'int' )

The job...

@Siten0308,

Did you ever figure out what your backup problem was and how to fix it?

Ok... I have a question, especially seems to be coming up a lot lately.

To what end does someone need this type of information?  What will the information ultimately be...

Please post the code on this site, Ram... the content of pastebin could simply vanish...