this PIVOT works fine for MsAccess - Now I am converting to MSSql - How would I do this please?
TRANSFORM Sum(AceData.InCredit) AS SumOfInCredit
FROM ListJob INNER JOIN AceData ON ListJob.JobList = AceData.Job
GROUP BY AceData.Type
Which version of SQL Server? Pivot is one of the areas that have been improved in the last few versions of MS SQL.
Here is one method that I have used with SQL 2000:
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …