huston.dunlap | SQLServerCentral

huston.dunlap

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 28 total)

Topics

Posts

Last post
Trying to iteratively use PATINDEX commands to comb through a large amount of text

11 replies

11 years, 3 months ago

By: Jeff Moden
Having trouble understanding the DateDiff command across year boundaries

3 replies

14 years, 5 months ago

By: Jeff Moden
Is it possible to update two tables at the same time?

2 replies

14 years, 6 months ago

By: tony.turner
A good way to do an update statement in 1000 row chunks

7 replies

14 years, 6 months ago

By: Jeff Moden
FOR XML PATH command is altering data, trying to determine the cause.

8 replies

14 years, 6 months ago

By: huston.dunlap
Update Statements and Understanding Locks

2 replies

14 years, 6 months ago

By: Grant Fritchey
Optimization: DE-Delimiting a Semi Colon Delimited List

8 replies

14 years, 6 months ago

By: Paul White
Using Functions in a Select Statement - A good set based method?

1 replies

14 years, 6 months ago

By: WayneS
Optimization: Turning a series of entries into columns

12 replies

14 years, 6 months ago

By: huston.dunlap
Problems making a temp table with Dynamic SQL (but not regular tables)

2 replies

14 years, 8 months ago

By: huston.dunlap
Ordering on every row...excep the first row

7 replies

14 years, 8 months ago

By: Paul White
Determining if a substring is a number...with variable substring lengths

6 replies

14 years, 8 months ago

By: Carl Federl
Performance difference between Inner Join and Intersect commands

2 replies

14 years, 9 months ago

By: Johan Bijnens
How to compare two strings with different encodings?

3 replies

14 years, 11 months ago

By: Mauve
BULK INSERT COMMAND: Using both a variable and a '\n' row terminator

8 replies

14 years, 11 months ago

By: purushotham.k9

Viewing 15 topics - 1 through 15 (of 28 total)