Great question! That's a neat little trick I need to remember. Never have seen that before and I'm sure it will come in useful.

This is how I would do it, but I may not have understood your data fully.

SELECT Torque.Product, Torque.MetricValue [Torque], BHP.MetricValue [BHP]

FROM TBL_metrics Torque

JOIN TBL_metrics BHP ON Torque.Product = BHP.Product

WHERE Torque.Metric...

Sean Lange (5/6/2016)

tripleAxe (5/6/2016)

I agree. I don't undertand why some peoples get so upset...

I agree. I don't undertand why some peoples get so upset and frustrated by...

Or was it the wrong question?

Thank you George. 🙂

A thousand apologies my friend, but I am not understanding what your problem is.

If you also have a integer value for the date part then you could use the agent_datetime function to convert the int to a datetime in your dataset and then...

If you are doing it in T-SQL you could prefix with a leading 0 and then use the RIGHT function to get the right most 6 characters and then use...

upper case / lower case confusion?

SELECT UNICODE(N'a'); ---returns 97

SELECT UNICODE(N'A'); --returns 65

Stuff it! I got it wrong again!

Well.. that one got me double-checking and triple checking and actually running the code in 3 different versions of SQL server. Maybe...

No stuff! Even did a search just in case my eyes weren't working.

I have used this type of query many times so knew what stuff would be used...

has anyone run DBCC FREEPROCCACHE ?

It's also worth the effort to stop users using the database whilst you are making the changes if you can.

If you do have to restore using the backup...

Is the table a heap or is there a clustered index on it? Same clustered index on your copy table? Is the copy table on the same server?