Do you need to exclude the column names from the import? Meaning - does the pipe delimited file have column names?

If so - then add the FIRSTROW=2 option into...

I think it would be huge amount of help to see them take on the whole issue of "remembered sets", and logically ordered sets (yes - there IS such a...

For what it's worth - you might just care to compare it to the day 52 weeks ago

dateadd(week,-52,getdate()) Should be the same day of the week...

It's about weighing the benefits versus the cost, in two separate areas (compound keys vs single-column keys, and natural vs surrogate keys). It's all a matter of how that...

TheSQLGuru (2/1/2008)

---

Itzik and some other MVPs have been pushing hard for improvements such as the one I listed to Transact SQL. This is one of several they are pursuing....

I must be having a slow day - but I keep getting lost in your logic. It just doesn't seem to leave any way "out" of the recursive function...

wow - nothing quite like being 5-7 years behind the times....As in - people in 2001 knew VFP was on borrowed time.

As to the limitations - even the last version...

Sorry - I saw the title "recursive UDF within a CTE" and got a very strong urge to leave the building before the server melts down...That's a "brave" combination there....

To...

I'm think of setting the output parameter to be nullable.... that way you won't have to supply anything to it on the way IN to the stored proc.

As to...

Does Itzik's syntax work on 2005? Because I can't get to stop whining about the word ROWS (and since it can't seem to get past it -don't have a clue...

The "Anchor" components tend to ensure that the @variables don't start trying to persist, or update too soon or late.

The form I usually use is

...

@variable=field=updatecalculation,

@dummyvar=@variable,

...

The purpose of the @dummyvar...

Brandie Tarvin (2/1/2008)

---

They don't put that warning on service packs and the fact that they put it on hot fixes tells me that they don't trust the hot fix code...

I'd ask you then this - how often do you see it being used in that 30 minutes? you were talking about referencing it a bunch of times in...

..I wonder what happens when the partitioning function is based on the "left-edge" of the Clustered index? It's an interesting example.

It's definitely a caveat to throw onto the technique....

Secondary thought - use an INSTEAD OF trigger, and leverage the OUTPUT TO clause of the insert.

So - your trigger would look something like:

INSERT T1

...