lmu92 (1/12/2010)

---

I agree with you and my comment didn't question your solution at all...

Since...

---

ORIGINAL QUESTION

---

How do i update a table with prefix number for the existing...

CirquedeSQLeil (1/12/2010)

---

is250sp (1/12/2010)

---

WayneS (1/12/2010)

---

Thanks for letting us know how you decided.

Is there any particular reason for going this method - specially since there is a way further on down that...

Thanks for letting us know how you decided.

Is there any particular reason for going this method - specially since there is a way further on down that is faster, and...

very often...

DECLARE @test varchar(50)

SET @test = '{FFFFFFFF-0000-0000-0000-000000000463}'

PRINT REPLACE(REPLACE(@test, '{', ''), '}', '')

PRINT SubString(@test, 2, len(@test)-2)

First, I took your supplied data and put it into a format that is readily consumable by all of us volunteers here (take a look at the first link in...

Cumberland, VA (west of Richmond VA);

Grew up in Virginia Beach, VA

Currently working in Hampton, VA

@Gus: in Tampa? My Mother-in-law is in Brandon. Guess I'll have to look you up...

UPDATE TableA

SET ColumnA = '2009.' + ColumnA

WHERE ColumnA = '51'

UnionAll (1/12/2010)

---

I am trying to insert 4 rows from #Dev to #QA, out of which 2 rows will fail converting

from varchar to datetime.

What i am trying to acheive is,...

How about some table definitions and sample data in the form of CREATE TABLE and INSERT statements so that we can better see what is going on? Also, what constitutes...

JOIN to the CUSTOMER table ON bo.cust_d LIKE CUSTOMER.cust + '%'

This will match to the customer table where the cust_d starts with the customer cust field.

I'd recommend a two-step approach...

1. split the string into the comma-separated portion into a column in a temp table

2. split the column with the dash-separated columns

You might want to take...

CirquedeSQLeil (1/11/2010)

---

Wayne,

set statistics xml on

Or Click show...

CirquedeSQLeil (1/11/2010)[hrWayne, I found a really slow point in your second script (the million records). The table population stuff. You will probably notice throughout the site that there...