The moment that you can't trust a restore from Dev to Prod, the data is no longer production data. However, you might want to review the restores from to Dev...

I'm sorry, but that doesn't help. I need the column definition, apparently you're using a char column, but that's just a guess. Read the articles linked in my signature to...

Something like this?

SELECT CONVERT(date,CONVERT(char(6),'160627'),12)

Avoid storing dates as numbers or strings. Use date/time data types which will allow better performance and capabilities.

Please post DDL and the values that give NULL as a result.

If you don't have periods and the lengths of your strings are not over 128 chars per section, this can be an option.

SELECT PARSENAME(REPLACE('INV CRT IS15000467 1', ' ', '.'),...

Go to the properties window for your columns. Go to the Number tab and select Time in Category as well as your preferred format.

You can also use the format function:

=Format(...

Not a big improvement, but might help.

SELECT STUFF( REPLACE( '/' + CONVERT(CHAR(10), @xx, 101 ), '/0', '/' ), 1, 1, '')

MadAdmin (6/24/2016)

---

surely the cte is faster, but they do...

TomThomson (6/24/2016)

---

Ed Wagner (6/22/2016)

---

jasona.work (6/22/2016)

---

TomThomson (6/22/2016)

---

jasona.work (6/22/2016)

---

/me leans back, marveling at what happens when you toss a crystal into a supersaturated solution...

Sounds like the next couple weeks / months are...

Did you remove the WHERE clause from the dynamic code?

EDIT: misinterpreted

The error message tells you the problem. You didn't uncomment the TOP clause.

Be sure to understand this and ask any questions that you might have.

DECLARE @serviceid int = 66;

DECLARE @sql nvarchar(max);

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

cteTally(n) AS(

...

Eirikur Eiriksson (6/24/2016)

---

jasona.work (6/24/2016)

---

ChrisM@Work (6/24/2016)

---

Eirikur Eiriksson (6/24/2016)

---

Luis Cazares (6/24/2016)

---

I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of...

Sean Lange (6/24/2016)

---

Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

create view [dbo].[getNewID] as select newid() as new_id;

Really? A view to get a guid???

But wait...it gets even...