Congratulations Jason and Jack!

And thank you for all the time and knowledge you share with us.

I'm sure that using sequences would be easier if 2 separate counters are needed. Sequences can handle multiple row inserts and should be easier to maintain.

My advice would be to use an identity column along with a char column and create a computed column with both. It will result in easier maintenance. If the C...

Read the following article to know what is needed for performance problems:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Your view uses functions on your joins. Remove them as they're not useful at all as demonstrated in the...

Why are you truncating the log file? You're only affecting performance. You should define an appropriate size to fulfill your needs and prevent autogrowth with normal operations.

Are you looking for something like this?

CASE WHEN Sum(poitem.qty_ordered) = Sum(poitem.qty_received) AND Sum(poitem.qty_voucher) = Sum(poitem.qty_received)

THEN 0 ELSE 1 END

Are you aware...

You might be experiencing a problem described by Jeff Moden in the following article:

http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

I'm not sure how you tried to do the update with XML PATH, but it might not...

Note that this question was posted over a year and a half ago. 😉

I corrected your link to make it clickable.

Most people won't download RAR files. Please post the code using IFCode tags [ code="sql"][/code] or at least text files. We would also need DDL and sample data. Please, read...

Why do...

You need to be sure what's really needed and what's not.

At my job, we have full control on a production db (on several but that's not the point). One day,...

BWFC (9/30/2014)

---

Four thousand plus points....

Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. ...

Can you tell me how to connect to SQL Server? Where do I find SSMS? What should I put in password? How did...

If you know the structure of the files and have the tables created, you could use BULK INSERT to import the files.

OCTom (9/30/2014)

---

I hope you're not a Houdini; otherwise, everything you've done is just illusion. 🙂

I had a colleague whom we named Houdini. He seemed to be busy but never accomplished...