Again, the easiest way is to parameterize your queries. You can either parameterize your pass through queries or create a stored proc.

Store proc example:

create procedure Table1_Insert

(

...

Why would you want to do that to your data? How you are going to handle this when there are 3 with the same ID? What about when there are...

Erwin Dockx (12/7/2011)

---

I think it's best to replace all single quotes inside the string to double quotes before inserting the html code, like so:

INSERT dbo.Table1 (Html)

SELECT '<table cellpadding="0" cellspacing="0" border="0"...

By far the easiest and best way to deal with this is to use a stored proc and make this html string a parameter. Otherwise you need to do a...

Can you just use a parameterized query?

Since you are new around here you probably have not yet had time to read best practices on posting questions. The idea is to make it easy for the unpaid...

Then you should normalize this data and store it in the format as you have it displayed. A column should contain a single piece of information and not a whole...

yeah just connect like normal. The 2008 SSMS can connect to 2005 with no problem.

Lowell (12/5/2011)

---

I'm still wondering how to implement this myself...if the Pk is a foreign key in the child table, won't the FK prevent you from changing the key to a...

ted_oconnor (12/5/2011)

---

Thank you for everyone's very quick response. I'm going to go with adding a new column and call it OldCustomerID.

As a side note, it that a Sporting KC...

So the series of updates I posted should work. Just put code similar to that in your new proc. Update the holding table until you have it all cleaned up,...

Just building on your example, and assuming you don't have to do this directly on import.

create table #Vals(SomeValue nvarchar(15))

insert #Vals

select 'ØØØ1Ø99I' union all

select 'ØØØ72976(' union all

select 'ØØØØ1Ø3J' union all

select 'ØØØ82986)'

go

select...

I think the issue you are running into is one of the main reasons that changing key values is a horrible idea. I understand it is something outside of your...

aarionsql (12/5/2011)

---

Thanks Drew, yes I need them in one column and I have too many columns to utilise the CASE statement. Going forward for a non-technical person to maintain it...

I agree to you if transactions distribution is uniform. It really makes sense to store them in UTC. I would go for it & there is no point-of-view difference.

Now...