Here is my version:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on...

ChrisM@Work (7/29/2013)

---

No error on this platform:

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit)...

Grenouillaise (7/28/2013)

---

Can't get this working - whinges about ALTER/CREATE statement syntax ?? Help?

IF (SELECT count(name) FROM sys.sysobjects WHERE (type = 'P') and name = 'SPNAME') >...

Jeff Moden (7/26/2013)

---

dwain.c (7/24/2013)

---

Why use a CASE at all?

WITH Rates (rate) AS (

SELECT -100 UNION ALL SELECT NULL UNION ALL SELECT 0

...

Thanks to all for taking a look.

I hesitate to suggest this is a SQL bug, but perhaps the Gods of SQL were asleep at the wheel on that query plan.

Nobody's...

May I ask why you need to add 1 millisecond to each row?

In other words, what is the problem you're facing when all of the bulk insert CreatedDates are the...

Duplicate post. All answers here please: http://www.sqlservercentral.com/Forums/Topic1478385-392-1.aspx

I suggest you look at the following 2 articles and they'll give you the answer you seek:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots,...

Erland Sommarskog (7/26/2013)

---

In XQuery (which is what you should use):

DECLARE @x xml = '<bookstore>

<book>

<title lang="eng">Harry Potter</title>

<price>29.99</price>

</book>

<book>

...

Cadavre - I love the name you gave mine: "COOL MATHS/"

I suspect it might have a bug though where the string ends like -$ (might show 0).

And (as ChrisM pointed out to me) it has nothing to do with NULLs:

WITH Tally (n) AS (

SELECT TOP 1000 ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

...

Perhaps this article will help you: Fuzzy-String Search: Find misspelled information with T-SQL[/url]

My contribution ain't exactly pretty but might work for you:

with tmp as (

select x = 'some text-1'

union select x = 'some text-123'

union...

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

Something like this should list out any of the products that fail your audit.

WITH ValidationTables (n, )

SELECT 1, [Key] FROM A

...

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

Something like this should list out any of the products that fail your audit.

WITH ValidationTables (n, )

SELECT 1, [Key] FROM A

...