Hello @jeff,

We use MAPS to collect SQL inventory from all servers, but MAPS cannot be automated.Are there any other free tools which can scan our network periodicaly and...

• This reply was modified 3 years, 8 months ago by  mtz676.

Thanks @jeff for your time and the elaborate answer.

• This reply was modified 3 years, 9 months ago by  mtz676.

@jeff,

Thanks for the feedback but my question was how do I autoupdate the decommisioned column using a query or some script that says the server is decommisioned ?...

Additional column would suffice.

Thanks, I will start with what you suggested.

FYI..All I trying to get was something quick and dirty...then build onto something more correct and in line with DB designs. I do...

All I meant was you picked up what exactly I wanted to get done....eventually..Thanks

• This reply was modified 3 years, 10 months ago by  mtz676.

Exactly , thats what you are looking at.

Thank you

@Brian,

.

Are CTE's reallt the way to go for this . Every time I execute the stored procedure they are probably going to generate min(2 rows)...

• This reply was modified 3 years, 11 months ago by  mtz676.
• This reply was modified 3 years, 11 months ago by  mtz676.
• This reply was modified 3 years, 11 months ago by  mtz676.

@Brian Gale.

That would update all rows where Q=1 in the table which is not what is needed.Every time the stored procedure executes it will populate the same table...

I am not fixated on a while loop.Anything more efficient will work just fine.

CREATE PROCEDURE [dbo].[ABCD]
(
@M int=0,@D int=0,
@F int=0,@Q int=0,@T datetime,@R int=0,
@RR datetime = NULL,@IO int=0
)
AS
BEGIN
DECLARE @I int = 1
DECLARE @QC int
SET @QC = @Q
DECLARE @Tm DATETIME
   BEGIN
...

• This reply was modified 3 years, 11 months ago by  mtz676.

Hello Brain, I guess I was not clear enough before. I have explained it again and hope it is clear.

I will explore CTE's.

Thanks for taking time to read through it.

• This reply was modified 3 years, 11 months ago by  mtz676.
• This reply was modified 3 years, 11 months ago by  mtz676.

@scott,

Yes it did for most part of it.

The stored procedure takes Name, month or day as input and generates records accordingly.The records are generated as expected but for...

• This reply was modified 3 years, 11 months ago by  mtz676.

thanks