Yes, (10A,  10,      2) is NOT at the bottom

isn't that the purpose ?

Right

I may need more details for the data types you are using

but this is an ex

Select m,b,l

From TableName

Order By Left(m,2),b,l

Take a look at this script that creates a stored procedure that uses BCP to export data to a file

To build the exact query I may need more info

But here is how you do it :

Update TableName SET FldZipcode = CASE WHEN Len(LTRIM(RTRIM(FldZipCode))) = 5 THEN FldZipCode ELSE Left(LTRIM(FldZipCode),5)...

You have to use BCP or DTS but if you have connectivity with that other system may be you can use linked serves.

did you change the VP.PK = VP2.PK for some fields that uniquelly identify the records?

I put PK just so you replace those because I don't know what is the undelying primary...

That I believe has happened to everyone of us starting be me

You May Not need a Cursor. If All that is dynamic is just the "Types"

then You could:

Declare @str varchar(8000)

SET @str ='Select User'

SELECT @str = @str +  , 'SuM(Case when...

For syntax BOL is pretty good you just have to read sometimes more that once what is explained...

SELECT firstname, lastname from Teacher_data_main

WHERE

(Firstname like '[FBC]%')

AND

Schoolnum = 371  

Can you try somthing like this:

DELETE VP

FROM   dbo.vw_part  VP

 JOIN

 ( SELECT *

 FROM  dbo.vw_part

 WHERE dbo.vw_part.partition_number = 1

 AND EXISTS  (

     SELECT   NULL

     FROM     dbo.vw_part b

     WHERE

  b.recipient_id = dbo.vw_part.recipient_id

  AND b.message_id...

select User

 , SuM(Case when DocType ='Type1' then 1 ELSE 0 END) as Type1

 , SuM(Case when DocType ='Type2' then 1 ELSE 0 END) as Type2

 , SuM(Case when DocType ='Type3' then 1...

Are you trying to authenticate directly to SQL  ? in that case you have to have that port open in your firewall

Good. when you are doing something in production ALWAYS, ALWAYS,ALWAYS ... did I said ALWAYS     make sure you have...