Like Michael said, the only time I use an additional int PK is in times when I'd need to store a multi column PK in another table as a FK...

To jump on the Non SSN PK bandwagon....

While I don't have the specific reference, (I think the Privacy Act of 1974 had some provisions for it) but it's my understanding...

You'll need to provide quite a bit more than what you've done so far for us to even be able to guess...

How big is your database, what type, OLTP or...

It sounds like you are creating a join table to break up a many to many join. the best example of this I can think of would be from...

Additionally, many anti virus programs have started blocking numerous ports by default, one of which is 25 (smtp mail port). Check and make sure that you can get to...

sounds like you don't have the mail services setup correctly, either that or it's pointed at an SMTP server that is currently down and/or unreachable.

-Luke.

yeah, it's lovely when MS doesn't even follow it's own rules when it comes to reserved words. I currently work with a db where some brain trust added the...

Thanks Jeff, I know you explained the logic to add the Sum bit for the total line, but I didn't have time to identify which one of your articles it...

Are you looking for something like this?

--create test table

CREATE TABLE #test (

id INT,

amount MONEY)

--insert sample data

INSERT INTO [#test]

SELECT 1,10.00

UNION ALL

SELECT 1,20.00

UNION ALL

SELECT 2,10.00

SELECT ID, SUM(Amount) AS Amount

FROM [#test]

GROUP BY...

have you tried it as st.[group] ?

group is a keyword so you probably need to enclose it in brackets.

Right back atcha.

Yup that's the gist of it, basically they are doing a right outer join to a derived table/view of the 2nd two tables. I typically find it's easier and...

I hate to state the obvious here, but since you say you get the same number of results even without the joins, it would seem that when you imported your...

That's absolutely true however given the situation and more importantly the sample data, the only real solution is run the script hoping to catch most of the names followed by...

If you'd like something that's set based and will most likely perform a bit better than looking at each individual character give the following a shot... Like the above...