Comments by Sahan2u - CodeProject

Sahan2u 7-Nov-16 5:48am View

This could be happen due to invalid date for @StartDate or @EndDate paramenters such as 2016-11-31. There is no 31 in November month.

Sahan2u 7-Sep-16 22:42pm View

You welcome cormaclee !

Sahan2u 18-Jan-16 3:53am View

Read the answers given to that question. For more information you can also read the answers here.

http://stackoverflow.com/questions/15980318/trigger-error-the-current-transaction-cannot-be-committed-and-cannot-support-op

it has bit more description.

Sahan2u 18-Jan-16 2:39am View

Yes you can.

Sahan2u 18-Jan-16 2:11am View

OK. Can you tell me what is the expected outcome of the query using above tables and data? just mentioned the data rows that you need to get.

as a sample
Work Number| Customer | Entered Date
1000 | Cust A | 2016-01-01
1000 | Cust A | 2016-01-02

(I just took some data. But mention the exact row details as you expect)

Sahan2u 18-Jan-16 2:04am View

Do you have a TRY/CATCH block ?

Sahan2u 18-Jan-16 1:46am View

Your question is bit unclear.

If you want to remove only the worknum showing up in the result you can just remove "tblA.worknum," from your select statement. But I hope that is not what you want to do. So need more clarification.

Sahan2u 18-Jan-16 1:14am View

Have you tried to execute the update statement outside of the transaction block.

Sahan2u 17-Jan-16 10:02am View

OK. I modified my answer. Just a little change inside the inner join. (Assuming job no will be increasing.)

Sahan2u 17-Jan-16 9:49am View

You welcome..

you can get data like that. But you need to make sure the job number is increasing when adding a new job. Simply the job number must not be decrease in any situation. Agree ?

Sahan2u 17-Jan-16 9:38am View

last date for what ?

for a particular car_id ?

Sahan2u 17-Jan-16 8:58am View

Then find my solution bellow. If you want more help pls comment here.

Sahan2u 17-Jan-16 8:41am View

Do you want to get one row per particular car_id and job_number or you want to get all the data rows for each and every car_id and job_number ?

Sahan2u 17-Jan-16 8:36am View

Deleted

Do you want to get one row per particular car_id and job_number or you want to get all the data rows for each and every car_id and job_number ?

Comments by Sahan2u (Top 14 by date)