Subscribe to:
Post Comments (Atom)
How to Auto-generate Order Line Item numbers for bulk uploads
I had a problem where I had 17000 line items to insert into 9000 orders. The system required line item numbers, preferably numbered 1throug...
-
There is a long explanation about SQL server caching values for autoincrement columns, and losing them when the server is restarted, but the...
-
The easy and obvious answer is to use a function, not a procedure. Then you can use it like any built-in T-SQL function. select 1, dbo.Fun...
-
If you're wondering how to create a list, or temp table in a SQL Server Stored Procedure, look here . But what if you're joining to ...
No comments:
Post a Comment