raghuldrag (6/7/2013)

---

hai friend,

if suppose choose the first row of the table,

create table journey

(

journey_id int identity,

depdate datetime,

fromplace varchar(20),

toplace varchar(20),

mode nvarchar(20),

seattype nvarchar(20),

)

insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-13', 'chennai','Banglore','air','Business')

insert...

Your requirement is still not very clear. Which is the column you want to update and How?

raghuldrag (6/7/2013)

---

if suppose wanna update 10th may-13 data's depends on auto increment id...

It seems you are calling the procedure 5 times for the 5 rows

You will have to change this approach and call the procedure only once and insert all the 5...

A sample data of 1 rows might not be enough

Please provide a few more rows to replicate the issue properly

Now, the main questions, What do you want to update and...

Why do you think it is not so easy? Applying referential integrity is not so difficult either.

Can you explain us the...

You can try the below steps

1. DELETE or TRUNCATE the data from all tables that are dependent...

dwain.c (6/5/2013)

---

I would...

What is the result you are expecting based on your sample data?

You will not get all this information by querying this table.

A better option would be to create a trigger...

Your explanation is not very clear

Can you explain the logic behind the expected results based on your sample data?

It would be a bit more helpful if you could add some...

One way to do this..

SELECTSUBSTRING

(

C.Col,

CHARINDEX(']',C.Col,1)+1,

LEN(C.Col) - CHARINDEX('[',REVERSE(C.Col),1) - CHARINDEX(']',C.Col,1)

)

FROM(

SELECT'[N] 18. Is the C.B. removed from the panel? [Yes / No]' AS Col UNION ALL

SELECT'[NABCD] 18. Is it removed from the...

Something like this..

SELECTCVFileName

,RIGHT(CVFileName,CHARINDEX('.',REVERSE(CVFileName),0)-1)

FROMCandCV

You probably have some data which is not a valid date

SELECT*

FROMYourTableName

WHEREISDATE(LEFT(perControl,8)) = 0

The above code will give you the list of invalid dates.

The data type DATE is not available in SQL Server 2005 and hence, the error

Change it to DATETIME or SMALLDATETIME

select cast(left('201301042',8) as datetime)

Wow. This is the shortest INSERT/UPDATE...