CirquedeSQLeil (1/12/2010)

is250sp (1/12/2010)

WayneS (1/12/2010)

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)

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...

Good feedback Jeff.

Probably not random enough, but I changed the 5 initial rows (abc xxxxx, etc.) to be:

1st row: abc 1,

2nd row: zyx 100,

3rd row: def 10000,

4th row: ghi 1000000,

5th...

Okay, after playing around with this for a bit, I came up with a solution that does just a single scan.

Part 1: build the test environment. This builds a test...