I don't think you would suffer performance penalty, but yes, if you want to use a set-based approach, you'd probably have to start in some earlier stage of data processing...

Hello,

my opinion is that if you want to loop through columns, you should leave the code where it is, in VB.

If you want to write SQL code that will do...

CAST as CHAR should help, maybe you're viewing the result in GridView? There it looks like the results don't have the same length, but if you copy the result into...

Ahh.. I begin to see a light.

Weight is weight of 1 piece.

CaseQty is number of pieces in a case, but PalletQty is number of CASES on a pallet.

Full is number...

I'm sorry, but I still don't get it.

Let's look at the first line:

Weight = 7 - that's weight of one piece, right?

CaseQty = 4, PalletQty = 12 - what is...

Hello,

this is quite interesting problem, but I wasn't able to understand the table. Could you please explain in words, what the data in temp_parttable mean?

I mean, if I look at...

Hi Greg,

we did, but it was quite complicated and I think it required use of Visual Basic script to suit our needs (my colleague was working on it, not me)....

Nice one, and you got me with that question. I absolutely forgot about "ch" and went with the popular "0" answer :crazy:

So-called "letter" ch can create some confusion because of...

I have never encountered this problem so far... the first thing I can see different on our servers is that we always have the setting of Use Remote Collation =...

I personally prefer the syntax with LEFT JOIN and NULL check in WHERE, but also the variant with EXISTS (SELECT ... FROM table WHERE <condition>) mentioned in previous post should...

Hi,

you mention problems with third INSERT INTO, but there are only 2 in your code as far as I can see. Since the query seems to be a simplified form...

IMHO the main problem you should try to solve is dates stored as integer. If you can't change the column datatype, maybe you could either add another column, or work...

Hello,

I'm afraid there isn't much we can help with. The column you reference is TEXT datatype, which is not allowed. Trying to convert the value doesn't help, it just isn't...

nialltuohy (5/9/2010)

---

Would you feel that is a more suitable method than my original post? I was hoping it was only a small error which I could fix easy? I...

Bhuvnesh,

you're right, there are no indexes in the posted code.

I created an index only later when I was testing the performance and didn't post the code. Here it is :...