I set the string to a variable to help in the readability.

Declare @String varchar(1000)

set @String =

'action=acct_zip&id=1B25B81JVJT&eid=FD05063&custnbr=281050&ky=FD05063&oc=$99 Free Shipping&mwn=&zip=90650&email=lafaithhome@yahoo.com'

select substring(@String,(charindex('&custnbr=',@String) + 9), charindex('&', @String, (charindex('&custnbr=',@String) + 9)) - (charindex('&custnbr=',@String)...

Your Request lacks the detail to produce an accurate answer.

I am guessing here, but I am thinking this is what your looking for:

How to dynamically number rows in a query

I had a Cow-Irker say Microsoft recommended a reboot every 30-45 days but I have never found documentation to support that.

I have had servers up for over 8 months with...

I have used identity columns sucessfully in transactional replication with no issues of this happening, except when some joker is goofing around in the subscriber destination database.

Is there any activity...

as bkelly suggested change for insert to for UPDATE.

And you also want to change your from clause to be from Deleted, not INSERTED. If you do it the way you...

Try Saving the sql script to file, having the job call osql and osql runs the script.

Your almost there.

If your using sql_Server 2000 then use scope_identity() instead of @@identity. Look up scope_identity in books online if you want a brief explaination why.

declare @id

-- This will get...

You cannot perform an aggregation without a group by function.

Please post some sample data and an example of what you want the result to look like.

http://www.aspfaq.com/etiquette.asp?id=5006

The opposite is...

With a little work and Time, I created this. It uses the sys tables not information_Schema. It Figures all tables columns data types, and even outputs all the attributes you...

Note the Database Option only appears in a certain version, I believe its Enterprise. Not exactly sure

How about Evaluate the @FormType and @FormId parameters, to set the value of Gender ID then insert.

You cannot do it inline in the Values Statement.

How about.

If...

Enterprise manager is a management console built using the Microsoft MMC application. All it does is uses SQL DMO and t-SQL to issue statements to sql server to do various...

What question are you specifically asking?

How do you create a stored procedure?

How do you create a cursor?

Have you tried Books Online? (Sql server Help)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp

Create Procedure

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp

Don't worry about Cursor....

Nice call Govinn,

RTFM (Read the Manual)

Sql Server will Do alot for you, but will not Everything!

I don't think DTS Supports BAS.

Try Checking out http://www.sqldts.com/

All things that are DTS