Cash_Requirements Download and rename to .sql and open in Management Studio — Create a Stored Procedure using this code DECLARE @Rng_CashRequirement int = 0 –0 = All, 1 = Range, 2 = Individual DECLARE @Rng_CashRequirement_Start nvarchar(30) = ” DECLARE @Rng_CashRequirement_End nvarchar(30) = ” DECLARE @Rng_CashRequirement_Individual nvarchar(MAX) = ” DECLARE @Rng_CashRequirement_Field int = 0 –0 =…
declare @ThisDate datetime; set @ThisDate = getdate(); select dateadd(dd, datediff(dd, 0, @ThisDate), 0) — Beginning of this day select dateadd(dd, datediff(dd, 0, @ThisDate) + 1, 0) — Beginning of next day select dateadd(dd, datediff(dd, 0, @ThisDate) – 1, 0) — Beginning of previous day select dateadd(wk, datediff(wk, 0, @ThisDate), 0) — Beginning of this week…
This was an extract using the command shell that extracted table data to a text file on the file system on the server. /* AFS Feeds */ /* AFS Business Unit Feed – Command Shell */ EXEC xp_cmdshell ‘bcp “EXEC [<<Enter MAX DB Name Here>>].[dbo].[AFS_BUSUNIT]” queryout “D:\ExactShared\AFS_Xfer\busunit.txt” -T -c -t’ /* AFS…
Finding hidden characters in your data using Dynamic T-SQL On occasion you may have run into a situation where you have had extended ASCII characters in your DB fields. They could be from old data conversions or from various problems and errors in the databases. The script below can enable you to find the characters within…
First create the Function below. Next, run the query against your source DB, be sure to change the parameters so you get the length you want. This was used on a migration from MAS200 to MAX where the Sales Order Notes was a long string in an old text column (this was a challenge too)…
A common request I get from customers is the need to sequence their parts on Pick Lists and in Engineering Reports. MAX sorts by the default Primary Clustered Key PRTNUM_01 (Part Master) or PARPRT_02 in the Product Structure. You can check this login in the Max Sample Company in Management Studio. Have Fun! /* You…
The other day I had a customer ask me for a query that would find Part Routing records the did not include a specific workcenter. I provided this snippet to help. This query selects the set that includes both(or all depending) work centers then “excepts” or removes the ones that contain “Work Center A”. USE…
1) Open the txt file and edit the file as needed. 2) Rename the sample file to .BAT. 3) Copy to the Server and place in the \EXACT\RMCLIENT\EFW folder 4) Enter a Scheduled Task in Windows to run it. MRP