I see a couple of big hurdles for what you are trying to do. First an audit or history is about a million times easier if you record the whole...

So given your example what do you want the output to be? Read the link in my signature for details about how to ask a question that is more likely...

The other problem is that you are using float as your datatype which is an approximate datatype and your value on record 4 is very large. Try changing the column...

You don't have any numbers to the right of the decimal so your number is being truncated.

You will need to change this datatype in order to get decimal place...

Glad that helped. That block of code is called a comm table expression, frequently referred to as a cte. To steal the line from Wayne's signature...

If you can't explain to...

Did you try google?

The following code would get the entire hierarchy but I am not sure this is what you want.

declare @EmpID char(10)

set @EmpID = 'Rs001'

;with cte as (

select EmpID, ManagerId from...

This is certainly a good start. Now what do you want the output to be?

How about some ddl and some readily consumable data? For instruction view the link in my signature.

With no ddl or sample data it is a stab in the dark but I guessing that your problem is in

where OUR.IsActive IN (SELECT DISTINCT ITEMS FROM dbo.Split(@ActiveStatus, ','))

My...

LOL nvm. If I actually read what you posted I would had a different answer. 😛

How about

select

floor(rowid),

sum(case when [status] like '%in-service%' then 1. else 0. end)

...

Jason Selburg (4/28/2011)

---

Sorry, I missed the parentheses around the *1.

select

rowid,

sum(case when [status] like '%in-service%' then 1 else 0 end)

--/ (count(*)*1.) as Availability -- the *1. is to force...

See if this gets you closer

Declare @hostNameIP VARCHAR(1000);

set @hostNameIP = 'AMEDNBWR01C003X';

Declare @softwares VARCHAR(Max);

set @softwares = NULL;

Declare @Make VARCHAR(5000);

Set @Make = 'LENOVO';

Declare @SoftwareQuery VARCHAR(5000);

CREATE TABLE #SoftwareInfo

(

HostName Varchar(1000),

SerialNum Varchar(100),

SWName Varchar(1000),

Version Varchar(1000)

)

INSERT INTO...

I still say drop the dynamic sql. From the code you have posted there is absolutely no need to build a big old nasty string and execute it. Just perform...