I'm a little over 11 miles (car route)

Saugatuck to Glenbrook, Connecticut USA

takes about half an hour in the mornings (leave 7:40 or 6:30 if I am going to the...

I must have been lumped in the PRO sprocs column but "it depends" is really how I work

In my current job, I use stored procedures exclusively - but I've gotten...

I am something of a newbie but ...

not to use stored procedures? that's nuts

it makes no sense in a networked environment to send over the network a lot of...

In your case LEFT OUTER JOIN is the way to go (and the fastest)

but with a lot of columns (and a smallish database) EXCEPT can be powerful consider this application

table...

I am surprised this post did not provoke some witticism about the clarity of the problem presented so I too will hold my tongue...

Junior - we really need more information...

I've seen this in Oracle, where call records (telcom application) are keyed on phone number, customer number and effective date (and possibly rate plan)

thanks Hari

I didn't post it (yet) but needed a way to find all fields called xxx

in the database

the system was designed by one programmer and he was highly disciplined in...

My boss does it this way

CREATE Procedure bla

@Country = NULL,

and so forth

AS

BEGIN

SELECT bla from bla

WHERE (Country = @Country) OR (@Country IS NULL)

END

Gary is it? (or Grant?)

Thanks!

I had to make a fix 'CREATE PROC', 'ALTER PROC'

and there actually was a stored procedure so knarly it was more than 8000 characters!

also, I...

Loner - yes, I went through SetFocus and did quite well after

their "job" postings were deceptive but the school itself was worth it, at least to me

I had tried for...

For me it was a no-brainer

I had just spent 16.5K for SetFocus, 3 months no income paying 2 rents - for another month of part-time studying as a break from...

If what you want to do is to get a high-power high-paying career developing applications for financial industries then of course you should take C#.NET. If you work outside...

many ways to skin a cat

not that I would want to skin a real cat...

CAST(CAST(mydate AS VARCHAR(12)) AS DATETIME)

removes the time for comparison purposes

"WITH EXECUTE AS CALLER"

isn't that the default option?

Not that it matters but carrot is what, in a bunch, BunnyRabbit on Captain Kangaroo used to put up on the counter all the time

I believe the ^ (capital 6)...