Now that the exchange rate is roughly 1 pound=2 dollars (today's rate as best I could find it), sounds like our colleagues "across the pond" are making out better than...

you're not doing anything wrong - it's a formatting trick.

95% of 1 hour = 95% of 60 minutes = .95*60 minutes= 57 minutes.

It's simply a matter of formatting (probably best...

Kenneth Wilhelmsson (10/23/2007)

If you want to know which day of the week a given date is, then there is exactly one way that will always give the correct answer, regardless...

oh I'll keep an eye on it - and I'll jump on when I can. I just got something dumped in my lap I now have to evaluate and...

of course - you need to have a clustered index - you just don't need the clustered index to be based on something sequential, like an identity field.

Jeff - no major caveats. Just for S & G's, a few weeks ago I did a "full" sloppy install (zone alarm and avg still running, upgrade right...

Well - I'm having some fun with having "lost" what I was testing earlier - but I will recreate later.

What it seemed to tell me though that it was performing...

Sergiy - what I do believe is that it took a while for people to learn how to optimize 2000 when it came out, so to toss something out based...

In either case, performance will be based on however many procs you "give" to SQL server. being licensed for a few user CAL's will not affect performance on the...

When in the eidtor window - pick the...

I'm thinking you probably want to use an output parameter, instead of messing with the return code.

Looks something like this:

create procedure blah (existing param list.....,@MYOUTPUT varchar(50)= null OUTPUT)

as

.....

SELECT DISTINCT...

This might be "cheating", but - have you considered asking your mainframe folks to provide this data in a fixed width format (i.e., not delimited)? if you did -...

Well - I didn't notice Joe asking to get paid on their payscale. Just said he'd like to work over there:)

Of course - the way the dollar is...

Pete -

What is wrong about what you see. It would probably be helpful to see what you're sending and what you're getting back, so we can help you...

As I recall from Microsoft's "Holy Book of Licensing" ( )- the divine rule reads this way:

- SQL CAL's are NOT concurrent-use CAL's. That means you'd need...