Hey, but at least we learned something, right?

Oh, wait...

Nice question.

Along the same lines of "no rows returned, do nothing", I have a feeling that it may be a case of "400 rows returned, assign 400 values to the...

😀

OK, that's my fault again. You did mention that one and I didn't add it to the test data...

You're right, and looking at it closer the code is actually putting 6.10 as a more recent version than 6.3 (10 > 3 in the way the logic is done)

This...

Hi Mark,

So it works in 2000 I've had to do away with CTEs so this looks a little convoluted. This looks to work on your test set?

It's a starting...

Hi ladies and gents, sorry about digging up an oldie...

sheepoo (2/23/2006)

---

Here are my two cents:

We spent the last 4 months looking for a Business Analyst who would come with a...

Excellent question, stewartc, thank you!

I wish you had set this question a long time ago, this could have saved some people some work... How did this slip under my...

Hi,

What you are referring to there (PL/SQL) is Oracle and not SQL Server, which is probably why you're having issues finding anything relating to that. Try looking for T-SQL,...

bwieland (10/22/2009)

---

Jacob and others,

I may be a neophyte, but I am curious as to what you and others believe the Azure environment will provide over an existing IIS and web...

Couldn't you just use a flat file source in the data flow task, and use a script task in the control flow before the data flow task to set the...

Ah, beat me to it...

some test data to corroborate:

--create test tables

create table #iseries_file (edinumber char(20),variousotherstuff varchar(200))

create table #contract (con_edipolnum char(20),con_status int)

--populate test data

insert into #iseries_file

select '123456','vt 54...

Thanks Hugo, another gold nugget of SQL "under the hood".

Just thought I would add my thanks, and also tag this discussion as I dare say it will be...

cengland0 (10/14/2009)

---

I would agree except the question did not say, Why doesn't this produce the expected result of 56? It was not a troubleshooting question but a question about...

Very good question in my book.

All too often you get guys spending hours debugging code and scratching heads when all along it was just someone chuffed up a datatype previously.

The...

Steve Vassallo (10/1/2009)

---

I would have to think the question if faulty in some way when close to 85% of the people answering it are getting it wrong.. IN my time...