Forum Discussion
Data selection formula
I am trying to write an SQL query to select / change a value based on a formula Below is the query I have written so far - SELECT PV_Job.JobCode, PV_Customer.CustName, PV_JobLine.ItemCode, PM_I...
Sorry, I'm not sure what you mean
I'm fairly new to this & using an editor I've been provided with
I'm fairly new to this & using an editor I've been provided with
SSMS is official management tools of SQL Server from Microsoft. It has a great SQL editer, and you can run SQL and check result direct from server with it. That means you can verify if your SQL was correct natively. Download from here https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#download-ssms
- Thanks for your help, I managed to sort this with the CASE statement rather than IIF
- Glad to heard that. IIF is a short version of CASE, and newer syntax, might have some Incompatible