the trick is you are missing a couple of tables, i bet.

you have to get all possible combinations before you join for the totals.

you have to select from something like...

it's really easy...

to capture the results form a stored procedure, the table must exist, with all the columns defined;

then you can do something like this:

IF NOT EXISTS (SELECT * FROM...

well an identity will easily fix the contention issue, so if you arbitrarily eliminate that possibility, i'm not sure what you can do.

lfcost (7/3/2012)

---

I can't use a calculated field, must...

here's a link to the US Census data that has a list of the miost frequently occuring male firstnames, female first names, and lastnames.

a cross join of all that data...

Tobar take a look at this thread, or search for "sp_UGLYSEARCH" (with quotes)

http://www.sqlservercentral.com/Forums/Topic1221552-1292-1.aspx

that's a proc i wrote to do exactly what you are asking: find specific values in a database,...

I agreen with mohammed moinudheen ;

there is no shortcut for this; knowing how to use the CREATE TABLE command is one of the first steps you need to know ...

definitely you'll need to use the Oracle driver, and not the microsoft driver;

besides there not being a 64 bit version of the MSDAORA driver, there are a few other issues...

the way i've always tackled this situation is to go ahead and have an identity column, and then a persisted calculated column to create teh text-based userid;

For example, Invoices:...

maybe you just need help constructing the WHERe clause?

SELECT

M.SomeData

FROM MyTableInsert M

WHERE @SomeData <> 1

so the above, isntead of returning zero, will return an empty...

you are correct.

a SQL admin has access to all the data, so unless the data is encrypted at the column level, the admins have access to it.

even then, if the...

Excellent contribution Dwain; I added this to my toolbox!

here's my version, but i was assuming you wanted to cop off the last period and whatever was to the right of it:

I left a lot of intermediate calculations to...

ok kewl;

i found a pdf at the microsoft site:

http://www.microsoft.com/en-us/download/details.aspx?id=9483

inside that pdf , way down on page 65, it has a bunch of mapping details, with the datetime stuff starting on...

Oracle TIMESTAMP can be a maximum of datetime to 9 decimal places;

so depending on your needs, you could go with datetime (which is to 3 decimal places) or datetime2 if...