"The loudest critics are always those who have the least education, knowledge, experience, and judgement to do the job themselves."

No, but that's a convenient way to dismiss people giving...

Scott... can you post the code that would return what the OP asked for?  Thanks.

what exactly are you trying to do?

Is it a one time conversion or a view that will be available for querying on the fly going forward?

and do you have...

I agree with the others... you need two tables.  One for the transaction HEADER and one for the transaction DETAIL.

I'll also add that even though some folks may provide a...

Allow me to rephrase Problem #1:  The log backups intermittently fail to RESTORE.

I have a second server we are trying to get setup to be an off-site log shipping...

Lynn,

Thank you for the very kind words.  If someone with your knowledge has claimed that I'm their mentor, then I'm truly humbled.  To be honest, you're as much of a...

Thank you for the kind feedback.  Helluva first post, eh? 😀

Ah... there's apparently a name for the false or simply untrue memories that people have that have become "The Truth" for them.  The first part of the article below is...

Excellent.  I'll get back to it later tonight then.

1. Good Sir, if...

Hmmmph... errors in reporting because of "uncertain data" aren't what's happening.  It's outright sensationalism that's happening.   To the point of your very accurate second sentence in your good article, which...

Heh... let the silliness continue.  I just got an email saying...

KILL 99.9% OF BACTERIA & HARMFUL MICROBES

FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON...

With that, I'll ask you why do you want to limit yourself in such a fashion?  Even books that were written by the combined efforts of multiple authors are usually...

Hello,

I started learning T-SQL 4 years ago and this is the first time I come here so...nice to meet to you 🙂 !

Here is a simple case : header...

Almost done with setting up some substantial test data for this thread but I need some more information.

1. Will the embedded header (the line with ID,name,sal on it) ALWAYS be...