Just watch out for this weird bug:

http://www.sqlservercentral.com/Forums/Topic1653333-392-1.aspx#bm1653437

Chiming in so I see sample data when it is posted because I'd like to take a crack at it too. Inventory problems can be lots of fun, particularly...

Interesting but it is not guaranteed to return alternate rows if there are gaps in BusinessEntityID.

Could this be a case of the Halloween problem?

Read: The Halloween Problem – Part 2 by Paul White (there are 4 parts linked in at the bottom).

Look for an "Eager...

pharmkittie (1/29/2015)

---

I have some code that I need to run every quarter. I have many that are similar to this one so I wanted to input two parameters rather...

Then you should probably...

Maybe something like this?

SELECT *

FROM vm

WHERE vm.visit_date >= DATEADD(month, DATEDIFF(month, 0, DATEADD(month, -1, CURRENT_TIMESTAMP)), 0) AND

vm.visit_date < CURRENT_TIMESTAMP-1;

CURRENT_TIMESTAMP and GETDATE() are the T-SQL functions to get...

Personally I wouldn't go with a home-grown solution for this "packing intervals" problem.

Instead I'd seek out the literature and find that SQL MVP Itzik Ben-Gan has proposed a very fast...

Such an odd requirement could only come as homework. What Gail has suggested will work.

Here is another way that gets you the matching words (MW) column only.

create table #test_table...

Maybe something like this (using Jeff Moden's community string splitter DelimitedSplit8K)?

DECLARE @ListOfTables VARCHAR(8000) = 'Table1,Table2'

,@SQL NVARCHAR(MAX);

SELECT @sql=s

FROM

(

SELECT ';SELECT Err=CASE (SELECT COUNT(*)...

What happens when you have more than 6 policies in any of the categories?

Why not make c1 an identity column?

Otherwise you can use a Tally table. Search on "tally table" and you'll find plenty of ways to do that.

David Burrows (1/28/2015)

---

If the table only contains the 50 rows you inserted or you want to reset all the ID values

ALTER TABLE DROP COLUMN ID

GO

ALTER TABLE ADD ID...

Brandie Tarvin (1/27/2015)

---

WayneS (1/27/2015)

---

Congrats Brandie....

Stephanie Giovannini (1/27/2015)

---

This sounds like a parameter sniffing issue, as it's differently behaved in SSMS and fixed by recompiling. There are two ways to easily get around parameter sniffing (perhaps...