This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by SQL Server. Selecting the collation sequence on setup provide the Instance Collation however the collation…

When a double period is used, as in:   ExactMAXSampleDB..Part_Master   This means the schema is inferred to be the default schema of the current login.   In most cases this will be .dbo. So instead of having to provide it one could use the shortcut of the “..” or more correctly the default for…

    Many companies are still running older versions of MAX even DOS MAX. We can convert and bring you up to the current level. Contact me and I can assist you.       Vince Stefanetti Senior Consultant

    Below is a recursive CTE that does a multi-level explosion for the current effective date. ;with mlBOM as ( select  PARPRT_02, COMPRT_02 , QTYPER_02, EFFDTE_02 from Product_Structure WHERE PARPRT_02 = ‘ENTER PARENT PART’ union all — CTE recursion select  n.PARPRT_02, n.COMPRT_02 , n.QTYPER_02, N.EFFDTE_02 from Product_Structure n inner join mlBOM c on c.COMPRT_02…

Web: http://www.max.exactamerica.com Training: https://training.exactamerica.com/ Portal: https://customers.exact.com

Then get:   Msg 5834, Level 16, State 1, Line 1The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration.   Use this to fix it:   sp_configure ‘Allow Updates’, 0RECONFIGURE WITH OVERRIDE

SELECT     SUM(COST_15 * RUNTTL_15) AS EXTFROM         dbo.Transaction_History AS THINNER JOIN (SELECT     PRTNUM_15 AS PART, STKID_15 AS STK, CAST(MAX(CAST(CONVERT(DATE, TNXDTE_15, 120) AS CHAR(10)) + ‘ ‘ + LEFT(TNXTIM_15, 2) + ‘:’ + SUBSTRING(TNXTIM_15,                       3, 2) + ‘:’ + RIGHT(TNXTIM_15, 2)) AS DATETIME) AS DTFROM         dbo.Transaction_HistoryWHERE     (TNXCDE_15 IN (‘A’, ‘C’, ‘I’, ‘R’, ‘S’, ‘N’, ‘T’, ‘F’)) AND…

To solve this you need to grant permissions in the folders to the service account you used to run the SQL Server services   Vincent Stefanetti

Right click the cell you want to use to go to the other report Select Text Box Properties Select Action Select Go to report Specify a report and select the one you created that you want to go to. Note: The report you are going to needs to have the same settings as the parameters…