Gianluca Sartori (5/3/2010)

---

I think Paul wants to join the "world's worst procedure" competition... :-P.

I would have put some more BREAK / CONTINUE in it and maybe nested another cursor,...

Configure the server correctly, improve the hardware, tune the queries, and refine the database design.

Frankly,...

No, you raise a number of important points. Rather than try to summarise an entire White Paper here, forgive me for just providing...

Sorry for the duplication - I didn't see the reply from sharath.chalamgari because I had the reply window open for a while before submitting it :pinch:

Only in SQL Server 2008.

Yes.

which one will be better for performance - string, XML or...

IF OBJECT_ID(N'dbo.Nums', N'U') IS NOT...

The (nicely correctly by Dohsan) posted...

Compare your code to this simple example:

SET NOCOUNT ON;

CREATE TABLE

#Example

...

You think so...what? I didn't ask a question.

I rewrite your query:

WHEN EXISTS (SELECT * FROM B JOIN A ON A.CusNo_A = B.CustNo_B WHERE B.Second_CustNo...

DECLARE @test-2

TABLE (

Country VARCHAR(50),

City VARCHAR(50)

...

Can you give...

a.black (4/30/2010)

---

The function GetNextID() creates a unique id based on the last id stored in the 'destination_table' table. However when calling the insert for multiple rows the query fails due...

nguyennd (5/2/2010)

---

@paul-2 White NZ : Thanks you for help.

But about require of business:

WHEN EXISTS (SELECT * FROM B WHERE B.Second_CustNo = C.CustNo_C) THEN 1

If not extist (A.CustNo_A = B.CustNo_B) is...

One other way to write Lutz's solution:

DECLARE @tbl TABLE (Room_ID INT, Check_in_Date DATETIME, Check_Out_Date DATETIME)

INSERT INTO @tbl

SELECT 1 ,'20100530','20100604' UNION ALL

SELECT 1 ,'20100610','20100612' UNION ALL

SELECT 1 ,'20100613','20100617' UNION ALL

SELECT 2...