Comments by Costica U

Costica U 7-Feb-12 8:33am View

Yes, the table has the column name "id" but the query uses max(id) with no column name for the result. Look at the changed query within my solution.

Costica U 8-Nov-11 7:22am View

My 5

Costica U 24-Sep-11 19:19pm View

SDName may have invalid char for the column name, e.g. "Supp Doc 1"
QUOTENAME will make it [Supp Doc 1].

Costica U 13-Sep-11 8:11am View

Check the updated answer with the SET DATEFORMAT DMY

Costica U 19-May-11 7:04am View

What is "20 lakhs records"?

Costica U 6-May-11 6:17am View

You should show some work done by yourself, and maybe someone can help you. Don't expect somebody to write the complete solution for you.

Costica U 4-May-11 11:42am View

You should post the code in the question not as an answer to your question.

Costica U 4-May-11 7:34am View

My 5. good link

Costica U 26-Apr-11 4:30am View

Deleted

My 5. I used this in the past.

Costica U 21-Apr-11 7:57am View

My 5. This is how I would do it.

Costica U 20-Apr-11 20:56pm View

Deleted

And what if there are more then one row inserted?
insert into [dbo].[UserTable]([id],[UserName])
select 1,'user1' union
select 2,'user2'

Costica U 15-Apr-11 9:26am View

my 5

Costica U 14-Apr-11 11:06am View

You are welcome

Costica U 14-Apr-11 10:12am View

You are welcome! Please mark it as accepted solution!

Costica U 14-Apr-11 1:59am View

What table do you use "tbltt" or "tblcharge22"?
Because the insert uses "tbltt" but the err message is "tblcharge22".

Costica U 13-Apr-11 6:46am View

Good point

Costica U 30-Mar-11 9:57am View

Please mark it as accepted solution.

Costica U 30-Mar-11 5:11am View

Please post the exact script.

Costica U 29-Mar-11 13:49pm View

Did you run only a portion of the script?

Costica U 28-Mar-11 18:21pm View

I don't see any problem.
Stop the program after line: cmd = new SqlCommand(sql, con);
and see how the cmd.CommandText looks.

Do you have column ChemistOfficeContactDetails.ChemistCode?

Costica U 27-Mar-11 14:33pm View

Data type for Contracts.StartDate and Contracts.EndDate must be DATETIME.
If not use DATEDIFF (day, CONVERT(DATETIME,Contracts.StartDate), CONVERT(DATETIME,Contracts.EndDate)) AS ShippingDays

Costica U 25-Mar-11 7:25am View

My 5

Costica U 24-Mar-11 11:51am View

my 5
The query needs
where mp.OPMCode=@OPMCode --'my OPMCode'

Costica U 18-Mar-11 6:00am View

You meant "How to reset identity specification in sql server"?

Costica U 15-Mar-11 11:01am View

My 5+.

Costica U 14-Mar-11 7:37am View

You are welcome!

Costica U 10-Mar-11 15:56pm View

You are very welcome!

Costica U 9-Mar-11 7:43am View

I like your solution. My 5

Costica U 9-Mar-11 5:19am View

My 5. This seems right.

Costica U 5-Mar-11 18:24pm View

I agree.

Costica U 5-Mar-11 18:19pm View

Is this kind of joke?

Costica U 4-Mar-11 7:57am View

My 5

Costica U 3-Mar-11 21:14pm View

My 5.
I agree!

Costica U 2-Mar-11 19:55pm View

Deleted

Reason for my vote of 1
There are some issues with your query.
See Alternate 2.

Costica U 2-Mar-11 10:24am View

You already asked the same question.
http://www.codeproject.com/Questions/162088/how-to-display-only-one-user-info-per-row.aspx

Costica U 25-Feb-11 17:50pm View

It's likely that you have duplicates by employee_id in hs_hr_leave for the same emp_depment

Comments by Costica U (Top 36 by date)