you could use dateadd(month, -4,eff_date) to get the 4 months prior date.

Thankyou very much for the reply. 🙂

Yes , OR operator's functionality is, it will returns the computers, which is having both or either one of the software is present.

excel ...

hi,

may be you could try use the 'in' operator in where condition for multiple inputs.

Sorry, if this is what you not expected.

Select t0.[Name] AS 'Computer Name', t1.[ProductName] AS 'Software', t0.[guid]...

hi,

may be you could try using the 'in' operator in where conditon for multiple inputs.

Sorry, this is what you expected.

Select t0.[Name] AS 'Computer Name', t1.[ProductName] AS 'Software', t0.[guid] FROM...

Hi. I am new to DB administration. Its a general task. my task is to check the performance counters (DMV) and wait statistics that will give an accumulated results (not...