That being said - if I understand what you're trying to do - use the XML concatenation "trick".

It's faster and more effective than just about anything else out there. ...

Your subquery can't be an update query (which it is with the @var=value statement in it)

A subquery has to actually return results. Again - having that assignment in...

Look at inserting a CONDITIONAL SPLIT task (after the unpivot, but before the final destination). your condition will need to determine which rows don't have nulls ......

This would also...

Art - this is different from what we tried to tackle in December?

I'm talking about this thread:

http://www.sqlservercentral.com/Forums/Topic431378-338-2.aspx

Just curious. If you can get a full list of the...

Agreed - the developer edition isn't limited, but the issue is licensing. Technically developer edition "is licensed only for development, test, and demo use" (quoting from its licensing...

Now we're cooking with grease. I'll buy that one for a dollar (to quote RoboCop)....

LDB file in Access = LOCK file not log file. That where it would track page locks on various things. it goes away when no one is using...

..which is fine as the beginning of a definition, but not nearly complete (at least not for the technical definition). A recursive function is one that calls ITSELF to...

hmm...This might be fun without seeing what you're looking at...

A few comments:

- the accountID should be in your final output because it was in the original output. You...

TheSQLGuru (2/8/2008)

---

1) For the TSQL limitations remember that there are a bunch of MVPs pushing Microsoft to fully implement the ANSI standards that will allow set-based solutions to this and...

Jim Russell (2/8/2008)

---

I guess I am no...

Karl -

Like previously mentioned - I haven't had the "pleasure" of dealing with Access 2007. that being said - in 2003, there was a way to DOWNGRADE...

I'd think that if a machine like this is independently tested by an independent testing facility, and that its track record is accurately recorded (again - by professional agencies which...

Keep in mind that the reason it "fails" is that there's ultimately nothing to back up in Simple mode. since the transaction log automatically truncates as soon as the...

do it from a query window. It will continue executing.

syntax would look like

alter table mytable

alter column bob2 nvarchar(500) --or whatever size, etc. you wish