Please post the FROM clauses, it sounds like the old version of:

FROM dbo.TestTable survey

JOIN dbo.[Sheet1$] xl

...

Pull the comma off the end of this line:

[STATE] = xl.[STATE],

Should be:

[STATE] = xl.[STATE]

WayneS (9/1/2010)

---

this article[/url] for all the rules in using this form of the update...

True, but neither does the mm one, just gotta deal with that stupid 'in...

Hm, that tally table looks interesting, and I'll explore it more shortly, I'm not immediately familiar with it. The crossjoin computations seems like it takes a lot more passes...

Nasty. Alright, quick fix. First, back the table...

Um, Sim? You've got badly related flat file data there... no wonder it doesn't work. Um, wow, where to start here.

First, google up normalization. Secondly you need...

Not entirely sure about a scripted method, but a brutish force way to deal with it is to just add the windows groups as if they were windows users, give...

In general you'd usually create a function that would break your comma delimited string down into a table for usage. For a local SQL Server Central example: http://www.sqlservercentral.com/scripts/Miscellaneous/31913/

From there,...

Sim, is the data actually stored in the way you listed the entry in the first code snippet above, where only one row carries the name and the next x...

Fair enough, and good links, thanks. You make a good point. So, to wit:

create table #tmp

(RepeatIDINT,

BeginDateDATETIME,

RecurEveryNumMonthsINT

)

INSERT INTO #tmp VALUES ( 1, '4/5/2001',3)

INSERT INTO #tmp VALUES ( 2, '8/25/2005',6)

INSERT...

This recent article:

Linking To Previous Row

If you're in 2k5 or greater, this is an elegant solution to your self referencing issues.

[edit] Sorry, wrong section for that solution. [/edit]

Rats, I'd hoped someone was going to come back with a way to do it by days that didn't end up tripping on the leap year for multiple year scenarios....

I did find my own answer, but I'd love to find a more elegent solution.

The code:

dateadd( mm,

( datediff( mm, BeginDate, getdate()) - CASE WHEN datepart(dd, BeginDate) > datepart(dd,getdate()) then...