Celko, Sorry for my English wrong!!! I may be poor this time to explain.

Sean Lange corrected me that not to use VARCHAR(50) and use bit Now my...

HI WayneS ,

you gave me to convert the complete table... My apologies that i have re-created as suggested by Sean Lange.

Please help me to get the query to...

Hi Sean Lange,

Thanks for pointing me to the right data types use's I have chnaged my data types as suggested

USE [abc]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MY_Table](

[i_serial] [int] NULL,

[i_State]...

Hi UMG Developer,

The first True considered as TRUE Since the as per the below explanation there is nothing to check above rows values for TRUE or False. Next it should...

Thank you opc.three .............. You saved made my job easy for any time if i want to post the results in the format of insert or update!!!!!!!!!!!!

Currently MAX_ico is the value coming from I_C_O highest value from last above and below rows, this should be set to check the value all the time from...

Do you know any easy way to get the data for this from exisiting table and exisitng data to post as a sample... ? I mean from SQL Studio Management...

Thanks it worked after left joining and order by ...

ORDER BY i_serial i will use...

however how to get the data in the same row i.e, the diffrence of two rwos in the current row

thanks this worked after using the http://msdn.microsoft.com/en-us/library/ms186243.aspx

I have posted here step by step all i have done and what ever i am trying to do here...

Please let me know what data you don't have in readble...

My apology that I could not get the DDL and DML... finally I got it from SQL...(I finally learned how to get these DDL and DML.. it's interesting learning

---step...

OKey... understood the output is not in readable format please find the input and output in excel format

Can i get the DDL and DML from my SQL Query analyser ?

if so what is the command i can use? please...

Below is the SQL Query i used to create as view

CREATE VIEW [v_AMP_C] AS

SELECT dbo.IC_Raw_In.I_Date, dbo.IC_Raw_In.I_O_P, dbo.IC_Raw_In.I_O_H, dbo.IC_Raw_In.I_O_L, dbo.IC_Raw_In.I_C_O, dbo.AMPS12_C.AMPS12_C

FROM ...