Anyone else... any scripts..?

Thanks.

Smith

Thanks a lot for your quick response.

But is there any plain sql scripts as I mentioned...pls..

Thanks again

Thanks.

Problem is we can't create function or any other objects in...

Joy Smith San (7/28/2011)

---

try the below code...

create table sampleData (appID int, appVersion varchar(100))

------

insert into sampleData

SELECT 1, '10.1.55.3366'

UNION

SELECT 1, '10.1.99.64'

UNION

SELECT 1, '10.1.1.1'

UNION

SELECT 1, '10.1.3.9'

UNION

SELECT 1, '9999.9999.9999.9999'

UNION

SELECT 1, '9.0.124.0'

-----------------------------

SELECT appID

,...

try the below code...

create table sampleData (appID int, appVersion varchar(100))

------

insert into sampleData

SELECT 1, '10.1.55.3366'

UNION

SELECT 1, '10.1.99.64'

UNION

SELECT 1, '10.1.1.1'

UNION

SELECT 1, '10.1.3.9'

UNION

SELECT 1, '9999.9999.9999.9999'

UNION

SELECT 1, '9.0.124.0'

-----------------------------

SELECT appID

, REVERSE(appVersion) as appVersion

,...

Hello....

One issue.. It dint work for the following values...

9.0.124.0

10.0.22.87

Any idea..?

Thanks.

This is wonderful.... It might work for me definitely...

Will try and get back...

Thanks to all ......

Thanks for your quick response.

It wont work for me.

There can be 'n' number of versions, 'n' number of applications and millions of rows. Also the version can be in any...

Thanks a lot.

Thanks Perry.

Will this work for SQL 2000 as well.? If not whats the equivalent.?

Thanks again.

Thank you all. Learned something new and important..

Thanks again.

Just one more doubt... Will it be safe if I...

Thanks Gila.

Am pretty much clear now.

So ultimately it takes long time while restarting because of "open transactions or committed transactions not written to disk"... Am I right.?

Thanks to all.

Restoring or recovering? Two very different things. I'd expect to see recovering after a server restart, I would not expect to see...