Sean Lange (6/23/2015)

---

yb751 (6/23/2015)

---

GilaMonster (6/23/2015)

---

I'll probably be looking to get new kittens/cats later this year. My Siamese died late May, completely unexpected, out of the blue. One day she was...

GilaMonster (6/23/2015)

---

I'll probably be looking to get new kittens/cats later this year. My Siamese died late May, completely unexpected, out of the blue. One day she was fine, next day...

Can you provide an example of what 'last_occurrence_date' looks like before you try converting it?

Assuming the format is valid...

DECLARE @badDate INT = 20150623

SELECT

CONVERT(DATETIME,CONVERT(CHAR(8), @badDate)) AS GoodDate

I'm assuming you commented out...

If you haven't checked already I would suggest you look through your SQL Error Logs. Specifically during recovery or backups. It may provide some clues into some of...

That part of the PIVOT is only expecting an Aggregate Function.

If you look up CASE: https://msdn.microsoft.com/en-us/library/ms181765.aspx

CASE can be used in any statement or clause that allows a valid expression. For...

From MSDN:

Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single...

You can easily extract the strings with something like this, provided all of the data follows the same format.

Cheers,

DECLARE @postal_latlong NVARCHAR(50) = '66000/66100 42.696595 2.899370'

SELECT

@postal_latlong AS Original,

SUBSTRING(@postal_latlong,0,CHARINDEX('/', @postal_latlong)) AS...

I'm afraid you will need to be more specific. What 'String' are you trying to compare? Do you need help modifying your statement?

Select Reson_id from reason_data where reason='ryete...

LOL...well for what it's worth here is the final edit to my solution (for 2012) which has the output...

Did you post in the wrong forum? I assumed you were using SQL...

Ok, well try my updated solution. The one problem I can see though is doesn't account for multiples problems relating to the same child. In your example you...

Actually I didn't notice you have added a row number as I had started working on the problem from your first post. Give me a bit and I should...

Ahhh thanks for the data, that's much better.

I've come up with a solution but I'm not sure if it's necessarily the best. Also keep in mind this is based...

Jeff Moden (6/17/2015)

---

Your turn, please. Why do you need the data in...

I believe this was introduced in SQL 2012 feature but I thought it was interesting.

However, as it is somewhat related I thought I'd mention it. I recently discovered this...