I would like to change this code little more.

Can we write a select query there to fetch value replacing @const1 ?

something like this ..

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

...

thats an impressive code !

You are the SQL God.

Thanks for the quick post.

Thank you.

I wish to add one condition in my code i.e a zero value checking .

like this ...

if(@const1!=0)

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

@_id,

COSTS_DST*@const1/@const2,

'Y'

FROM PRIOR_DIST

WHERE _ID = @id_prev;

else

INSERT INTO PRIOR_DIST...

Thanks for the code. I have understood this part.

Is it possible to round the result upto 10 decimal...

ChrisM@Work (12/13/2016)

---

spectra (12/13/2016)

---

I would like to upgrade this query a bit ...

CREATE TABLE #John (j datetime)

INSERT INTO #John VALUES ('2016-11-10 12:12:42.100')

SELECT j FROM #John

WHERE j BETWEEN '20161201' and '20161213'...

I would like to upgrade this query a bit ...

CREATE TABLE #John (j datetime)

INSERT INTO #John VALUES ('2016-11-10 12:12:42.100')

SELECT j FROM #John

WHERE j BETWEEN '20161201' and '20161213'

If I...

my mistake.... its working..

<scrapped>

Tested .... but its not working...

John Mitchell-245523 (12/13/2016)

---

WHERE UPDATED_DATE BETWEEN '20161201' and '20161213'

Bear in mind that this won't capture anything that happened on 13th, unless it happened at midnight (20161213 00:00:00). If you...

datetime

Thank you guys

I have run that query ...and I checked those files are not present in the returned physical path result.

seems ...I can safely delete those files.

Thanks for the post

>>>you could write your own query to return an INSERT statement for whatever table name you choose.

Could not get it. are you saying not to use generate script