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...
-
This function will return a list of all dates between a start date and an end date. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ====...
-
This article explains how to copy a database from one server to another when Backup/Restore is not an option. This will work as long as...
No comments:
Post a Comment