Thanks for your help. I ended up writing it a different way without using dates because I realized that specifying dates wouldn't help with what I was trying to...

I didn't know if searchdate was a statement I could use

I wrote in my original post that I need to write it without referencing a timestamp in a table

I know...

Thanks for the reply

I modified my query but it returns an error

Delcare @dt date

Set @dt = GETDATE()

select distinct v1.name 'Machine Name', v1. 'Username', t1.displayname 'Unlicensed Application',...

Yup got it! I was really beating my head against the wall, thanks again.....

THANK YOU!!!!!!!!!!

I ended up using 6,4 but here is the final query and thanks again!

declare @compliantint

declare @notcompliantint

declare @totalint

declare @percentdecimal(6,4)

set @compliant = (select [# of patches] from vpatchcompliancecount where Status =...

Ok so here is the new code, it works but the problem is that the output for Compliance % is 98 and I want two decimal places after 98

set...

Hey,

Thanks for the reply. All I am trying to do is return a compliance percentage of @compliant/@total and I want to return a percentage with 2 decimal places if...