Sounds like you are going to have to do field parsing to determine the group by value.  I would research the PATINDEX or CHARINDEX and probably a couple of different...

I would check the query that you build on the ASP page to ensure that the syntax is still correct.  Populate it in a message box or better still a...

Just for giggles I would make sure that you are connecting to the server via TCP/IP and not Named Pipes (if in same LAN else the other way around for...

What was the process doing before you killed it?  If it was a SELECT then you may need to cycle the sql service not the entire box.

If it was another...

You can use CAST and CONVERT in the WHERE clause however, depending on the format of the date as an integer it may not work.  Can you post some examples...

Check out xp_logininfo.  also BOL if you look this up has some other info xp_loginconfig, etc...

Why not create the FirstName and LastName separate and then do the following:

UserName = RTRIM(LTRIM(@FirstName)) + SPACE(1) + RTRIM(LTRIM(@LastName))

This is a problem with importing data from Excel.  I have run into this in the past. 

Our workaround was to place an apostrophe (single tick) before each numeric value...

another way to do this would be to:

From Access goto File > Get External Data > Import.

Select the ODBC datasource, all the tables, and sit back and watch.  1 caveat...

You could do any of the following:

1.  Set-up a VB application to populate data into the table(s) using SQL in a loop.

2.  Create a SET-BASED loop inside QA to populate...

Another thing to consider is security (both data and network).  IF you outsource AND the skills are no longer available at your company to check the system how do you...

I have worked at a couple of different shops that have outsourced and they had the same outcome:

1.)  4 - 6 outsource personnel to do the same job as in-house

2.)...

SELECT CEILING(CAST((174 + 231) AS DECIMAL) /2)

This should work for you

The following are some different ways of doing this

1.)  Create a temp table with processed flag and walk it to return the 1st unprocessed record using set-based processing

2.)  Create a...

I just tried on my system the following:

osql -Usa -Pxxxx -SMyPCName  and it logged right in.  Is the scott user set-up properly?