You should be able to, if you have access, create a table with the state name and the abbreviation and update those records.

CREATE TABLE [tblStateMaster] (

 [StateAbbrev] [varchar] (2) NOT NULL...

I don't know if this is the BEST practice, but you could have an update/insert trigger on the table and write the newid value to another table and have your...

Put the SQL in a text file and use the /i parameter of OSQL to specify the inputfile.

See the documentation about OSQL.EXE and the other switches. So, your CmdExec job...

Hi Anne,

Could you send the text of the sql script?  It would help also to have the schema info(create table statement).

thanks,

bob

From a search on Google Groups:

Try SET NOCOUNT ON before starting the cursor

while loop...

...and if SQLAgent doesn't honor NOCOUNT (due to a bug), run the script from

OSQL.EXE.

 I just ran into...

What you can do is to create two variables and use them to store your codes.

declare @SOPNum as varchar(30)

declare @SOPNum1 as varchar(30)

set @SOPNum = 'STDINV2256'

set @SOPNum1 = 'ORDST2225'

select * from...

My first guess is that when you're grouping by salesperson, your distinct number is includes custaccno's that are also assigned to another salesperson.   If you have 25 customers and they...

What kind of field is Rnum and does it actually exist in the table?  ntext, text, or image columns cannot be used in an ORDER BY clause.

Three of my main reasons for using dynamic sql is:

1.  Need to change the database context.

2.  Need to change the tablename ( I think you can do this without dynamic SQL,...

The method I suggested still works with your data structure.   The ActiveX script would definitely work but it would probably take literally 1000's of times longer (although with hundreds of...

My first guess is that someone added a password for sa.  It's one of the vulnerabilities that was exploited by one of them dang worms, I can't remember if it...

If it would be possible for you to add something to the actual Package, you could follow the script with an select @@ROWCOUNT  that gets inserted into a log table...

Hi,

Instead of doing all of that character manipulation, how about just converting it to float and dividing  by 100?   Once you cast a value, it discards any invalid preceding numeric...

I would also go with Derrick on this, but here's more detail.  Anyone have a better idea?

1.  Import the data into a table with 2 fields.  Field one is DataRowID...

Your best bet, if I'm correct in assuming that all of the records are inserted in ID ascending order, would be to write a UDF in SQL Server that has...