I tried using the 'OR' but then i get results in my column that shouldn't belong long. Such as hair color i'd get values of male also thrown in there....

Thank you all for your responses. With your suggestions i was able to determine that my data was milleseconds since a specific date and from there it was easy to...

Thank you for your reply. As i looked at my data and what your SQL was doing, it doesn't appear that my numbers are stripped out time stamps. In one...

Hi

I was wondering if you knew the answer how to do the reverse. Going from bigint to datetime?

Thanks!

I only need the temp table for the life of the procedure. I was thinking of maybe combining your two ideas, maybe creating a View with the data that i...

Thanks for the help. I'm getting a syntax error i believe by my GROUP BY. The message is:

Msg 102, Level 15, State 1, Line 23

Incorrect syntax near ')'.

Other than the...

I would like to find out more how to pivot because that seems more efficient than trying to manually manipulate the data. Do you always need to know what how...

oh duh, i should know that. Thanks for the help. I've been reading some of your other posts. You give out some good advice 😉

Thanks for the help. I think that's probably the course of action I'm going to have to take.