Do you want it returned as datetime or as a string?

Try to run this:

SELECT ID, Status, COUNT(*)

FROM Table

GROUP BY ID, Status

HAVING COUNT(*) > 1

It never failed on my memory.

Unexpected results it returned only in cases when it was used incorrectly.

Can you show your code?

But don't modify anything, every detail may be very important.

You welcome.

Happy to help.

newbie101, Query Analyzer is for analyzing queries, not for data exchange.

Try to use appropriate tools for your tasks.

And another suggestion: try to avoid using varchar(max) by all means.

I once increased...

You need to read about locking in SQL Server to understand the consequences of what you are asking for. When you get to understanding you stop to ask for trouble.

You...

You're welcome.

Did you try computed columns?

Much less hassle.

To give it a try you don't need to delete existing ones,...

Books On Line, "Help" for SQL Server, press F1 to open.

First of all you don't need 2 triggers.

As well as correlated subqueries.

ALTER TRIGGER Cis_OP_No_Trigger

ON dbo.Cis_OP_No

FOR INSERT, UPDATE

AS

IF (UPDATE (N_Vyrobok) or UPDATE (N_Kplan))

update p

set N_Vyrobok2 = i.N_Vyrobok +...

You may replace badly written triggers with better written ones.

That's exactly the problem.

Badly written triggers with subqueries built with an assumption...

Because "T" in T-SQL means "transactional".

Because while you try you may affect the data used in...

CONVERT(DECIMAL(10,2), Wages)/100

If an error happens in a job the whole job fails.

No matter if you have error handler in the code or not.

Forget your Try-Catch habits while in T-SQL, they are...

peter478 (5/19/2009)

---

ALTER Procedure dbo.UPdata

(

@e_Nplan char(20),

...