| || |
Conditions in Select statement Using MSSQL
I would like to write a condition in Select Statement in Tc.
The scenario being,
If its the first day of the month or week write a query from hourly table as the data is displayed in hrs.
If its the 2nd day or thereafter it has to select data from the daily table which is displayed in days.
Any ideas on how to write conditions in select?
Re: Conditions in Select statement Using MSSQL
Actually, if you mean the SQL SELECT statement, you can find information on it here.
If you mean something related to TC, you can check the current date with the conditional statement (normally, it is called 'if') of the scripting language you use and decide which SQL query to run.