jeff.mason (6/21/2010)

---

And in my experience, you'll probably need more than just the log table, if you are doing reports (since logs can be inefficient in joins for reports). You'll...

I can definitely see...

Since both of those are the default terminator values, all you need is:

BULK INSERT dbo.test

FROM 'F:\test.txt'

WITH (

DATAFILETYPE = 'char',

KEEPNULLS,

firstrow =2

);

I'm sorry, I just noticed that you are asking for an UPDATE statement, and I provided a SELECT.

So, how's this:

UPDATE c1

SET client_id = CASE WHEN c1.record_type =...

How does this work for you?

SELECT c1.uniqueid,

c1.company,

c1.firstname,

c1.lastname,

...

Well, considering that Dave wrote that blog... 😉

This method utilized the DelimitedSplit function. You really should read the article mentioned in the remarks, and build your very own permanent tally table - with a properly built table...

Just my luck.....

Wednesday, I updated a test box to SQL 2008. Pretty old (> 9 years)...

Last night, the drive controller failed spectacularly (sparks, smoke, everything), completely corrupting the HDDs connected...

Which is why you should store dates in a datetime column.

try "and convert(datetime, date) between" ...

of course, this will completely prevent the use of any supporting indexes on that field.

ditto! :w00t:

Check out the two cross-tabs and pivots links in my signature block.

Now, this here is a man that isn't afraid to...

I frequently reference your blog for the...

This will show you how to convert a range of dates into year/quarters. I'm also adding in the first and last date/time for each quarter. You should be able to...

Here's another way to do this:

declare @StartDate datetime

-- get the 12/1 date for the previous year

set @StartDate = DateAdd(month, -1, DateAdd(year, DATEDIFF(year, 0, GetDate()), 0))

-- See Jeff Moden's article

--...