Instead of detaching and moving files I would recommend creating a backup and then restoring that backup on your other server.

I don't speak Oracle. This a sql server site so everything around here is...

Can you post what you tried?

YIKES!!! 129...

Oops I didn't see Alan's fine post when I posted my last response. It seems very similar to mine. The main difference is the one I posted will return 2...

nutty (11/20/2013)

---

Hi

Apologies for not following the format. I will keep this in mind next time.

My desired output is

Parent_Count | Child_count

2 ...

shravan.gavva (11/20/2013)

---

create table table1

(

data_value varchar (50),

sql_data_type varchar (50)

)

insert into table1(data_value,sql_data_type)

values ('11/02/2013', 'DATE')

insert into table1(data_value,sql_data_type)

values ('', 'DATE')

insert into table1(data_value,sql_data_type)

values (11.3, 'decimal')

insert into table1(data_value,sql_data_type)

values ('not assigned', 'DATE')

insert into table1(data_value,sql_data_type)

values (null, 'varchar')

insert into...

Then you are going to have a long uphill battle validating all your datatypes. This is truly a nightmare.

Are you planning on...

Hi and welcome to the forums. Since you are pretty new around here you have probably not seen the best practices article about how to post questions. You can find...

shravan.gavva (11/20/2013)

---

Hi,

I have two columns in the same table

One is data_value (varchar) and the other is sql_data_type (varchar). Data_value holds info like dates, decimals, etc..

sql_data_type holds info about what type...

ritika rishi (11/20/2013)

---

I faced a problem while detaching and deleting a new database.. I had to close all other processes and tasks(e.g- had to close netbeans) before deleting it..

Is there...

OK this is my last attempt...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1515817-391-1.aspx

I agree with Lynn about showing us what you want.

There is absolutely no need to resort to looping for this type of thing. We can help you find a solution...

Teee (11/20/2013)

---

Hi,

Thanks for your response, I've managed to come up with a solution to split the dates:

-- Get comparison dates

Create Table #TempComparison(dteDateComparison varchar(36), bitProcessed bit)

IF (@dteDateComparison <> '')

Insert Into...

Jeff Moden (11/19/2013)

---

BWAAA-HAAAA!!!! Save yourself continuous anguish...