IIF is going to eval BOTH parts (the THEN and the ELSE) even if it returns just one.

Try this instead:

= Round(

...

You have to remember SQL Behavior as to mathematical operations: it will try to retain the data type it started with. So in your case - you're taking an...

It's not a communication protocol. It's more like a grammar (it defines what elements should be within various types of communication).

Protocol: set of rules established among groups.

think of it...

Grant Fritchey (1/14/2008)

---

I knew of the OUTPUT clause, but I'd only really thought of it for stuff like auditing. This is really useful. So, if you had a multi-row insert,...

That's a BIG question. You might need to hit the books.

Health Level 7

HL7 is a protocol establishing data/record formats for passing medical information back and forth. It's been...

I was referring to "Professional insurance" and what is often referred to as Errors and Omissions insurance. Professional is the one covering the server you might knock over; E...

The Alarms themselves should be their own entity (a.k.a table) with their own unique identifier. Would make this issue MUCH simpler.... That way you would have no issues...

Since you're in 2005 - you can avoid all of the scope_identity nonsense by using the OUTPUT predicate from within the INSERT statement.

It looks something like

declare @nextid as integer

declare @tbl...

Try something like:

select 'Table_a' as tablename, sum(total)as Total_of_All_Tables

from table_a

union

select 'Table_b' as tablename,sum(total)as Total_of_All_Tables

from table_b

union

select 'Table_c' as tablename,sum(total)as Total_of_All_Tables

from table_c

union

select 'Table_d' as tablename,sum(total)as Total_of_All_Tables

from table_d

Youre XML is being mistaken for HTML formatting - of the site is "truncating" it.

Before posting it - drop the XML into notepad, and run a find/replace to...

It also depends on how you want your results. You might care to UNION the summary statements together and do some more aggregation on it....

I was the other side of the testing with Jeff - so I'd largely agree with his assessment. I might throw in a few other categories (like - doing...

Well - technically it IS a triangular join, but it's one against the summary. So - you summarize first, then triangular join against it (essentially unrolling the summary).

That being...

I wonder who user #666,666 will be....hehe. We'll have to nickname them "nostradamus".

We'll have to define "not expensive", because E & O insurance for a developer or DBA isn't cheap, especially when you're touching someone's production systems (even if not directly). ...