We have about more than 200 suppliers, and some of the stores missing couple suppliers.
I tried to run a worksheet 206 and it ask me to select each stores. Is there any way to download all suppliers to update each stores?
*This post is locked for comments
Oh yeah, i accidentally learn this things when i need it most :D
And btw, can you close this thread now? ahihi
I didn't know you could manipulate worksheets like this, thank you so much!
You can add all supplier all at a time during the worksheet design. Just leave the Worksheet Update Supplier no entry and do not approve the worksheet yet, just save the worksheet. Take note the worksheet reference ID. You will use this later.
Next, execute the following sql:
DECLARE @worksheetID AS INT
SET @worksheetID = (indicate workheet reference ID here)
IF OBJECT_ID('tempdb..#myTemp') IS NOT NULL BEGIN DROP TABLE #myTemp END
SELECT ID AS SupplierID, @WorksheetID AS WorksheetID INTO #myTemp FROM dbo.Supplier
INSERT INTO dbo.Worksheet_SupplierUpdate
( WorksheetID ,
SupplierID
)
SELECT WorksheetID, SupplierID FROM #myTemp
Next, open the worksheet, check the entry and approve.
Thats it!
Could you run the 206 worksheet, right click in the contents tab, select recently changed, select start date of 01/01/1900 and end date of today? Wouldn't that pick up all of your suppliers?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,375
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
