BrenBart,

You are absolutely correct. When the problem has been to clean up formatting and reduce multiple occurences to single, I have also been resigned to while loops. Fortunately,...

BrenBart,

You are absolutely correct. When the problem has been to clean up formatting and reduce multiple occurences to single, I have also been resigned to while loops. Fortunately,...

This is probably too simple... Remember that checking for 0 and checking for NULL are not the same thing. If the parameter is passed as NULL it will bypass...

I have had occasion where the double quotes also cause problems with the ADO object. I am hoping this was a "previous version" bug.

Basically - any string where you...

No problem doing this. The biggest factor you need to keep in mind is storing the quotes properly as though you were building a dynamic SQL statement.

Remember to pay...

Could you use SET @stName = REPLACE( @stName, ' ', '' ) ?

Guarddata

That is a good start. However - this will only catch errors relating to violations in SQL itself (CHECK and FOREIGN KEY constraints - duplicate indexes, etc.)

If that is...

We have found that transactions work great by using the BEGIN TRAN and COMMIT or ROLLBACK - and NOT using XACT_ABORT. The only time we have ever had to...

This is duplicated in two forums. The problem is that the string is 11 characters. Convert Varbinary 10 cuts off the last character.

Guarddata-

jraha,

My guess is that the first statement uses an index. The second query is forced to do a table scan and wouldn't need to sort anything. The CONVERT...

I'm not sure this makes sense - so please forgive my ignorance. Because of the hyphen, there is no direct conversion from the string to a number.

Converting the string...

I agree with Andy in that this does not have a single answer for every join criteria.

That said - if this is the method you generally use to access table...

This depends a lot on what you want to do with the files. We generally avoid storing files in the database because we access them from so many different...

You will need to use an ADO Command object and set the parameters...or change the stored procedure to SELECT the output variable into a dataset.

Guarddata-

One thing to remember is that the date is actually stored as a decimal so there is no real "conversion" when going to a float or int. I have...