ChrisM@home (11/20/2010)

---

WayneS (11/20/2010)

---

ChrisM@home (11/20/2010)

---

WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

I hope you folks in the U.S. will have the following Friday as well as the weekend off and you'll have a wonderful...

Did you not understand?

Do you have a DATETIME or an identity field in this table?

Remember the order in which the rows are inserted, does NOT guarantee that the they will...

--==This is how you should have posted your tables definition

CREATE TABLE #T(Field1 INT, Field2 VARCHAR(3),Field3 BIT)

--==This is how you should have posted your sample data

INSERT INTO #T

SELECT 1, 'A', 0...

What defines the

Do you have a DATETIME or an identity field in this table?

Remember the order in which the rows...

hoangnnm

- I have MsSql Server 2000 installed on a XP machine .

- The machine is running on a network that i can't access the router ( cos the it...

Jeff when the heck do you manage to get some sleep? ? ? ?

You could also use IF EXISTS, for example

--Insert some sample data

CREATE TABLE #T(PatID INT, Stat INT)

INSERT INTO #T(PatID, Stat)

SELECT 1234,1 UNION ALL ...

Sure, I'll share because you do have to be a chapter leader to access that portion of the PASS web site. Probably a former chapter leader as well because...

Dom - Can you use a table variable?

DECLARE @I INT

SET @I = 0

DECLARE @T AS TABLE(d DATETIME)

WHILE @I < 30

BEGIN

...

Your question is rather vague. Can you supply the table definitions, some sample data and the results you require.

To do this to make it possible for someone to give...

This might work for you, although it will not present the results in the order you require

select MIN(Codigo)AS 'Codigo' ,Nombre, Apellido,MIN(Tipo)AS 'Tipo' from #mytable GROUP BY Nombre, Apellido

CodigoNombre ...

Using SQL 2008 if one creates 4 tables (1 for each of the create statements in the question). Insert the same number of rows into each table, and then...

GSquared (11/15/2010)

---

Ron, that'll work if you're processing one row at a time.

If you want to query a set of rows of data, add a Where clause that checks that the...

Have you considered the use of the IF ELSE construct? For example

DECLARE @text VARCHAR(250)

SET @text = 'Login failed. The login is from an untrusted domain and cannot be used...'

IF...

Ann Cao

Please do come back and post your results, it will help others with similar problems.

Sachin.Nandanwar, the OP stated problem, is NOT the transaction rolling back but:

So when...