Nice work, well done sir. A few things to note:

First a couple of ticky-tacky things that aren't a huge deal but worth mentioning...

You may want to consider using a...

If you had a calendar table available the you can do it like this (note my code and comments):

USE tempdb

GO

-- Simplified calendar table with only the columns you need

IF OBJECT_ID('dbo.calendar')...

Phil Parkin (3/29/2016)

---

Disagree. This requires an OR.

select a from b where condition1

union (should probably be union...

You would use AND.

SELECT vend_id, prod_id, pro_price

FROM products

WHERE prod_price <=5

AND vend_id IN (1001, 1002);

Can you include some DDL and sample data?

I am not an...

SQL Guy 1 (3/28/2016)

---

I have a complex query with multiple joins and conditions. My test server has only one drive for data. Same for production.

Estimated execution plan inserts...

Jacob Wilkins (3/28/2016)

---

DesNorton (3/28/2016)

---

Thank you Sachin and Jacob. From my initial dev testing, this appears to do the trick. Now we see if the QA team can break...

Great article Andy, well done.

Yep.

Jacob Wilkins (3/25/2016)

---

Your version doesn't have to be that complicated.

It...

Anyone want to take a stab at this. Essentially the OP needs a csv splitter that handles text qualifiers; Eirikur Eiriksson's RFC-4180 compliant splitter from this article: This article[/url] would...

Are you really on SQL Server 2008? If you were using SQL 2012 this article would get you 90% there:

http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/%5B/url%5D

I'm going to play around with a couple ideas and...

This is actually a common business requirement....

Provided that the rank_pos is sequential and there are no gaps you use LEAD like this:

SELECT t.Score, Rank_pos = ISNULL(t.Rank_pos,X.Rank_pos+1)

FROM

(

SELECT score, Rank_pos, xx = LEAD(Score,1,1) OVER...