yes you can, but first you would have to have set up database mail on your server.

in SSMS,expand the "Management Folder" and find Database Mail. you have to know the...

you add indexes to enhance performance based on the queries that hit the server;

for example, if a table is often searched by the column LastName, an index on that column...

doh! Gianluca hit it! 16 seconds if i don't present the results in SSMS. i feel better now.

Gianluca Sartori (5/11/2010)

---

I get:

19 seconds for the first run

16 seconds for the second...

Jeff Moden (5/11/2010)

---

1.6 million random 8 character codes that no one can guess and they're guaranteed to be unique within the set... takes about 25 seconds on my 8 year...

man i love details! with your explanation, it looks so easy now!

I think i have what you want; run this select and confirm whether or not this is finding what...

pseudo code (TableA TableB etc) sux. i don't think it can describe a real resolution for you. moving concepts from pseudo code to your real issue is stopping you from...

the logic is the same...it's just the test condition that changes:

don't think you wan t not exists...you want to confirm that there is at least one row on TableC...

it's actually easy..you can use multiple AND/OR statements with an IF:

IF NOT EXISTS(SELECT 1 FROM TABLEA WHERE ID=1)

AND NOT EXISTS(SELECT 1...

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...