i try with following

select *

, TimeDeiff = cast(right('00:',CAST(DATEADD(ms, DATEDIFF(ms, LAG(CreationDate, 1, CreationDate) OVER (ORDER BY ID), CreationDate), 0) AS time(3))) as varchar(30))

from dbo.TradeCodesErrorLog;

it give me error

Msg 206, Level 16, State...

ok it working

remaining one thing

data display as

00:33:55.480

exactly I need to display as

33:55.480

so how to do that

how to handle features or  columns that i don't know it

suppose i add new feature today and every feature have column

then every feature added will modify on code

if you are...

i don't understand what you mean

i ask for way move data from stored procedure to another

so how to do that please

ok but i think if i use go on stored procedure it will end execution

so what i do

thank you for reply

can you write these statement below by joining using id

without join by url text

are there are any way to do that

update t set t.Revision_ID = r.rec_id

FROM extractreports.dbo.TempROHS...

i make all indexes and still issue exist

can we rewrite these statement or what

so can you help me on code

and tell me what statement update should be to run faster

1- when prioritycode=replacementcode

if priorityname contain x   and no other codes then UPDATE FinalCode By NULL

AS replacement 199 and 700 and 600

2- when prioritycode=replacementcode

if priorityname not contain x  then UPDATE FinalCode...

• This reply was modified 3 years, 1 month ago by  ahmed_elbarbary.2010. Reason: more explain

yes invoice id is invoice no

and i use this field to store Purchase ID AND  sales or consume ID

but my issue How to handle transfer from inventory to another inventory

this...

thank you for support

according post on multi forum

it will not repeated

sorry

can you tell me how to do that please

when do like that

cast((t1.PartNumber+ t2.PartNumber) as varchar(200)) PartNumber

can i concave two string without make cast  when insert data

ok you are correct

i will change data type

are there are any other thing can change it to enhance performance

i need to use that below

Alternately, you could use an ID value that is an INT (or bigint) and set it up as an IDENTITY(1,1) so it is ever increasing...