Perry Whittle (11/30/2012)

---

This

selectobject_name(object_id) AS TableName

from sys.columns

where object_name(object_id) like '%table...

If you are using an autonumber you are going to have gaps. This is perfectly normal. Honestly, why does it matter if there are gaps?

Backup and Restore is the fastest and most reliable way to do this imo. I am not sure you can even detach a 2005 db and attach it to a...

Well since what you posted still doesn't really explain what you are working with I turned this into something usable.

Does your table look something like this?

;with cte(FullName) as

(

select 'Augusta, GA'...

Do you mean you more than one City, ST in the column? Is it delimited at...

Or an even simpler way given your original post.

;with cte(FullName) as

(

select 'Atlanta, GA'

)

select LEFT(FullName, charindex(',', FullName) - 1)

from cte

With such a great job posting ddl and sample data I think you deserve a complete answer. I wish more people would make their posts so easy to work with.

declare...

select * from sys.tables

You should probably become more familiar...

:blush: Gosh thanks for the compliment. Sadly as I am getting older my eyes are getting worse and...

I found my snippet that does this.

SELECT DATEADD(s, @EpochValue, '1970-01-01 00:00:00')

To understand the impact you have to know what model db is used for. If you understand that, this question will...

sahmad43 (11/29/2012)

---

I have a table with date in unix timestamp and iam using the following query to get the dates which are older than 10 mins but its giving me...

It won't fix your issue. It was...

bopeavy (11/29/2012)

---

First I'm dealing with a vender product who does not know their own product. With that said i have to try and scramble this type of info no problem....