May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
DAYS_IN_STATUS = IF @@ROWCOUNT = 1 (SELECT DATEDIFF(dw,AU_TIME,GETDATE())-(DATEDIFF(wk,AU_TIME,GETDATE())*2) AS DAYS_IN_STATUS ELSE ??
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Union & Crosstab qrys 101!||6||73|
|How to add an Index to a date/time field?||15||43|
|Modify SQL Query to Select records between two dates||4||37|
|Populating a table from inside a trigger||2||15|
Join the community of 500,000 technology professionals and ask your questions.