Thanks Steve!

sometimes a screenshot is worth a thousand words.

Kinda shows you up front whether it's...

lcarrethers (5/10/2010)

---

This gives my my totals i want but like i said i want the varid field added and some way i will need toget one of one of the...

I carry LinqPad[/url] around on a flash drive for occasions when i sit at a machine without SSMS;

it's portable and has the ability to do object explorer equivilents as well...

ok i think this is doing what you want;

i'm getting the original group as a sub select, and then rejoining it to the original table.

i think there was an error...

between your two posts, the data changed; more columns, other null fields, etc.

here is the second pass; this xemplifies why posting the table and data works so well...it avoids...

since you are new, I'm helping out and providing the work table and the data in a consumable format;

that way anyone can test a query against it and confirm results.

In...

this is a logical mistake; you should never try to keep a counter in a table; the counter should be derived in a view, instead; go with bteraberry's idea and...

that's the old, deprecated syntax to designate outer joins:

--AND R.Code = W.TransactionType is the same as

FROM R INNER JOIN W ON R.CODE = W.TransactionType

--AND R.Code *=...

most mail servers allow relaying only for two conditions: if your IP address is on the same subnet as the mail server, ie the internal IP to your mail...

what does "sychronize" mean to you?

can you just take the backup at ServerA and restore it at ServerB, or does each server have data that their opposite server does not...

Wayne what you are after is stored in the registry, and it depends on which verison of SSMS you are using for the exact key;

the lazy way is to regedit...

i mistook the requirement to be info in @@Version, to see if it was Express/Workgroup/Standard/Enterprise/Developer that had been using the file.

i don't believe this is possible;

i was under the impression that the mdf is a standard file format for each version(2000/05/08)...meaning that all versions of SQL save to the...

i was a little unsure on which to select; his thread title said "Select tbl1.a if exists otherwise tbl2.a",

and i glossed over the implication that whether tbl1 or tbl2 =...

-- COALESCE returns the first non-null value from the list provided; it is a param array, so an large number of arguments can be passed to check for non-nulls.

SELECT COALESCE(tbl1.a,tbl2.a,'no...