Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A complex query syntax
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008 R2
OS:
Windows Server 2012 R2
Miscellaneous
Thread ID:
01643914
Message ID:
01643926
Views:
21
>>tested it
>>
>>AWESOME
>>
>>exactly what I needed
>>
>>thanks a ton
>>
>>
>You're welcome.

Last question though

how can i add a calculation there

should be something like this

,
min([Date]) + min(CASE WHEN MIN(Type)='Local' THEN 6 ELSE 7 END) as Expiration

??
.......
DO WHILE .T.
      ME.Work()
ENDDO
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform