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...
-
Microsoft did a brilliant thing in SQL Server. I applaud them for this. You can actually pack more than one SQL Query into a stored proced...
-
There is a long explanation about SQL server caching values for autoincrement columns, and losing them when the server is restarted, but the...
-
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