I know what you're talking about, and I feel with you. I had to work with a similar system for some time, before we managed to convince the managers that...

It may also depend on where do you live... but I don't think that their objection is correct. Never heard about this in Czech Republic... In my opinion, working as...

No. You are not converting NUMERIC into INT. You are converting VARCHAR into INT, and that's why it does not work. Integer data don't include any decimal separators, if you convert...

We posted almost in the same moment

Anyway, my query will return 0, not NULL - no matter whether any questions were answered or...

I hope it will be easier than that - although I may have misunderstood something... Try this:

SELECT A.InspectionUID, COUNT(*) as cnt_required, COUNT(A.QuestionTreeUID) as cnt_req_answered

FROM tbl_NSP_QuestionTree Q

LEFT OUTER JOIN tbl_NSP_Answer...

That's right, Tim.

LEFT JOIN with a check for NULL, as Aaron posted, is the preferred way of finding out records that have no connected records in another table.

JOINs are optimized in...

Sergiy is helping you, but you don't listen...

Even if you have no chance to alter anything in the database which contains the data (which it seems you can't... but maybe...

Hi,

we are using FIFO in our system, so I can corroborate Sal's observation - since first goods received were of lower value, current stock with FIFO must be higher than with...

It works for me, so it will probably be something in your data structure.

What is the length and datatype of the column you want to parse?

declare @name varchar...

I had the same problem, but after a while I found the difference

RTRIM(LEFT([column],PATINDEX('%[0-9]%',[column])-1)) AS [name]

RTRIM(LEFT([column],PATINDEX('% [0-9]%',[column])-1)) AS [name]

Do you see the difference...

Hi,

you write:

"But consider that i get the field name (i.e. AprAmtD dynamically in the variable @strAmtD)"

Does that mean @strAmtD contains BOTH the column name and the value?

If so, then you...

Hello,

it seems you have some serious problems...

How can you work with something if you don't know what's the structure?

How can you define "whereclause" if you don't know what columns are...

Yes Trystan,

if I didn't make any mistake in the code (I didn't have time to create tables and sample data to test it), the query with derived table I posted yesterday...

Because "WHERE something IN (SELECT ...)" is generally a bad idea because of performance and I prefer to avoid it. I would prefer a solution with a derived table, if...

Sorry for cluttering this thread with posts, but (if we stick to a solution with IN clause), this would be simpler and it does precisely the same as SQL in...