I know XML in SQL Server 2008 has been greatly enhanced, but the question is me and a lot of people I know are still working on SQL Server 2000....

Good question! I was shocked to see the four rows when I tried the query!

Leaving aside the issue of the COLLATION, I opted for the one row answer, because the...

It's a cheat question not worth the time one put on it.

Next time you could misspell a word, maybe a column name, and you'll get a even better query.

Don't waste...

Damn it! You're right. Too fast coding...

I get your desired output just adding GROUP BY woi_product (changes bolded):

SELECT woi_product, /*woi_ordref,*/ Max(wos_startdate) as wos_stardate

FROM @woitem JOIN @xTOOLS

ON woi_product...

It's easy, just two unary operators before 7:

select 6+2+(-(+7)) --> select 6+2+(-7) --> select 6+2-7

I'm surprised but is true:

Select Cast( '+' as int ) --> 0

Select Cast( '-' as int ) --> 0

I 'd suggest you to try two approaches:

1.- As someone else states, use a VBScript task to write the conditional code. In this case, you can set two green work-flow...

Yet I can't see why the assignation concatenates the strings in one case and does not in the other. Somewhere I read the concatenation behavior is not assured, or is...

Don't be ironic, Bru. Do help him or not, and if you don't let another do it. Your comment is an unnecessary narcissism.

lmu92 (1/5/2010)

---

dbuendiab (1/5/2010)

---

I think you have already several good answers, or at last the kind I would have suggested before this one. Despite of this, and only as a alternative...

I think you have already several good answers, or at last the kind I would have suggested before this one. Despite of this, and only as a alternative to consider,...

The web server uses some SQL credentials to connect to the SQL Server. So, if you have such a hardwired user for your SQL connection, that one will be repeatedly...