I actually had to solve this kind of problem a couple of weeks ago. I was modifying some package type software that always sends string type 'WHERE' clauses to...

Rather than using the LEN function to determine the number of times

to replicate your leading zeros, it might be simpler and easier to read

like this:

SELECT RIGHT('000000000' + CONVERT(VARCHAR, ),...

Thanks. This one is very helpful. I hadn't thought about using OpenDataSource. It's not the post/article I was thinking about. The example was opening a text...

I normally use a set based solution with 2 passes for an UPSERT.

Something like:

UPDATE Tbl1

SET Tbl1.SomeData = Tbl2.SomeData

FROM Tbl1

INNER JOIN Tbl2 ON

Tbl1.PK = Tbl2.PK

INSERT INTO Tbl1

(PK, SomeData)

SELECT Tbl2.PK,...

If your data is always numeric and always only has 1 decimal it may be simpler to convert the data to numeric data types and then compare.

Something like:

SELECT ColumnName

FROM Table

WHERE...

Thanks. I tried it before and didn't notice an option for 1 file per object. Maybe I just missed it. I'll try it again.

Todd

Thanks guys. This helps some. Is there any way to have each object script in a separate file?

Todd Fifield

Wow! I never thought my first post on this forum would evoke so many passionate responses.

I still think that my points on the type and number of applications accessing...

Here's a simple little function that will strip off the leading numeric values and return an INT that you can sort by. If the numeric leading digits aren't all...

Your problem may with the the data types. SQL Server is not very friendly with divides of INT / INT.

This will return 0

DECLARE

@Expense INT

, @Income ...

The easiest way I've seen to handle this problem does not involve any sort of serialization. There should be a control table that contains the next number to use....

This is really a matter of what the database was created for. If there is only 1 front end application doing all of the inserts and deletes, there is...