This is good information. Is there a Microsoft webpage that states these end of support dates?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

Thanks for the link. I will look into ActiveCipher. Right now, I have developed a SQL Server SP solution using CryptoAPI via CAPICOM. Seems to work fine,...

I've got SP3 installed, now. Can't remember if this has been a problem, since I did the install. I hope this fixes the problem. Only time will...

Here is a way to do this with a create and update statement against a temp table.

-- Create table to hold original values

declare @T table

(

col1 varchar(10),

col2 varchar(10),

col3 varchar(10)

)

-- populate

insert into...

quote:

---

It's certainly possible in TSQL, you just need to loop through the table replacing the duplicate values.

In the following example the values...

I wrote this prior to reading you entire post. I'm sure my table structure does not match yours. But possible some pivot table query like this might work for...

You might consider comparing the COLLATION_NAME on the MAIN DB with the COLLATION_NAME on the TEMP DB table for the column that is having the conversion problem. This way...

Here is the test I ran, where I thought it COALESCE might be slightly faster. Not the most scientific test, since I only used elapsed time. By the...

You might try something like this:

set nocount on

create table Ttest (masterid int, GeoState char(2), GeoCity char(40))

insert into Ttest values (67,'CA', 'Los Angeles')

insert into Ttest values (67,'CA', 'San Diego')

insert into Ttest...

You will need to pad that int with 0. I have a couple of examples on how to pad with zeroes here:

http://www.geocities.com/sqlserverexamples/#string4

Gregory Larsen, DBA

If you looking for SQL Server...

Here is the same basic example, but this one removes the last trailing comma.

set nocount on

create table x(a char(1), B CHAR(1))

INSERT INTO X values('a','z')

insert into x values('b','y')

insert into x values('c','x')

declare...

Another method is to can call xp_cmdshell from within your sql code to execute a OSQL command that runs each script.

[/quote]

Gregory Larsen, DBA

If you looking for SQL Server Examples...

Since you have 900 Thousand records that would be a lot of memory thrashing to process a cursor based query. Should be faster if you can write a set...

Since you have 900 Thousand records that would be a lot of memory thrashing to process a cursor based query. Should be faster if you can write a set...

Here is an example of a proc returning a cursor in case you don't have one:

Create proc x

@rs cursor varying output

as

set @rs = cursor for select name from sysobjects

open...