Farrell,

SELECT SUBSTRING( CONVERT( varchar, DATEADD( dd, -1, GETDATE()), 101), 1, 2) + '_' + 

 SUBSTRING( CONVERT( varchar, DATEADD( dd, -1, GETDATE()), 101), 4, 2) + '_' +

 SUBSTRING( CONVERT( varchar,...

Uhh, that depends entirely on what you will be doing and what you are willing to spend.

I believe per processor for standard is $4995.00 per and enterprise edition is $19,995.00...

Ah yes, I see exactly what you mean.  Thanks for the illustration.  RH

Matt, since you are joining on the ID, is it safe to say that all matching child records would have the same (distinct) fields for:

,s.ID

,s.City

,s.State

,s.PhoneNum

,c.id

,c.City

,c.State

,c.PhoneNum

If so, you could always...

David, how is my solution volnuerable?  The VB application is locked down so that almost all values (and all operators) are drop downs of some kind and not editable.  The...

What front end are you using?  I once built an entire query front end for users in VB where all the logic was in VB, not SQL.  I simply built...

Yes, yes, yes.  Database Daily is appreciated.  Please continue with the service.

Ryan Hunt

Being that the website is based out of Russia, I had not given the certfication much thought.  However, your comments have reminded me that there may be members of this...

Wayne, thanks for the response.  I am not interested in the site's certification.  I am only interested in improving my SQL skills and it is the only place I found...

Jason, are you using Named Pipes or TCP/IP?  I believe TCP/IP is greatly preferred as the default protocol in a bandwidth constrained WAN.  See BOL for a detailed explanation.

Ryan

Hmmm.  Zero to two, depending on how you look at it.  I always have a really nice laptop furnished by work.  All personal and work info resides there so it...

Frank, would you mind elaborating on your commment about temp tables?  I was under the impression that table variables typically incurred less server cost during use.

Or, are they typically just...

Micheal, instances can be tricky - they usually indicate that more than one set of SQL executables are running on your machine.

First - go back to the utility and make...

Steve, what is your disk configuration?  I guess they are both physical disks - not logical disks right?  No RAID differences - nothing like that?

If that's the case, I think...

RUN: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe

This is the SQL Server Network Utility.  Enable Name Pipes and TCP/IP.  Then try running OSQL -E at a command line.

However, please note that your workstation's SQL...