RE: FN-FORUM: T-SQL Question

date posted 9th March 2006 00:27

That's exactly what I did Andy! :) It was just one of those 'oh no that's
gonna take bloody ages!' moments lol!

Don't know where the data came from though probably just copied off a
webpage somewhere it was a nightmare. Had to do about 5-6 searches in the
end for all the unusual characters like " and all the rest word uses to
replace characters... Done tho phew!

Stephen.

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Andy
Macnaughton-Jones
Sent: 08 March 2006 20:07
To: FN-FORUM / [EMAIL REMOVED]
Subject: RE: FN-FORUM: T-SQL Question


I think you can tell the console to run a script - you can take that
stored procedure, strip off the create stored procedure part and it'll
just run as a one off script.

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
Stephen Tierney
Sent: Wednesday, March 08, 2006 7:30 PM
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: T-SQL Question


The main problem was I've only got console access to the db and I really
didn't want to mess around exporting importing. Plus I can use these
queries in other developments or other situations later on!:)

Cheers all for some really great advice! I've sorted in now! :)

Stephen.

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Dom
Latter
Sent: 08 March 2006 16:37
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re: FN-FORUM: T-SQL Question



http://vyaskn.tripod.com/sql_server_search_and_replace.htm


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html


--
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html