Sorry I wasn't more specific.

When you install Sql Server, there is a built-in user name "sa" and you probably entered a password for that account (or were scolded severely for...

I installed Sql 2005 Dev on Win XP using mixed authentication, but I normally connect using Windows Authentication. This is what my login screen looks like:

http://www.wvmitchell.com/SSCentral/Connect_to_Server.bmp

My...

John, is Exam Cram the only book you used?? It doesn't seem to cover all of the published exam objectives. I just might be ready, if that's all you really...

In the original Access table design, were those problem combo-box fields created as "lookup" fields? That is to say, if you open the Access table in datasheet view, do you...

Cool, thanks for the tip. I'm heading over there this morning, I'll let you know how it turns out.

Thanks to everybody for your replies. Let's leave Access out of the equation for now, here is my specific problem with SS 2005:

The production server has two database files. There is a...

Jeff, I did not really mean to offend you, you're a very clever guy but I think you went over over the line with a few of your comments.

You said:

"But,...

Jeff, I think you ARE being confrontational about this whole UDF thing, simply because you don't agree with it. You speak of "code reviews" but who made you the expert...

Thanks for your reply. I ran that on my 2000 dev machine, for UserName "par" I get

0xF5F9569AB6284548A85AD1A73DFF927B

and on my 2005 dev machine, for UserName "par" I get

0xC899D1E7279C2942A9F82CD6204D3EB5

so I can...

OK Jeff, you don't have to place the code in a UDF since performance is slower. But this was not the first OP asking how to accomplish this task.

You yourself...

Lynn,

Your comment was extremely relevant re: the volume & environment. Many of the posters have done detailed analyses of performance using 1 million rows, and have poo-pooped my idea about...

My first test was with SS 2000 on a ThinkPad with only 768 Megs RAM. On my 2.8 GHz Pentium 4 HT desktop with 2 GB RAM and SS 2005, it took...

I see your point Jeff, the function version takes a lot longer, by a 6:1 margin. In your example, on my 2.5 GHz Celeron ThinkPad it was 1.6 seconds vs....

Reusability, encapsulation, object orientation, refactoring, pre-baked code, whatever you want to call it. You establish a standard method and stick to it. Everybody on the team can use the same...

I personally use the DateDiff/DateAdd method which I picked up a while ago from one of the forums here, it performs adequately and performance has not been an issue for...