-- sample data

DROP TABLE #Sample

CREATE TABLE #Sample (PurchCode VARCHAR(3), Provcode VARCHAR(5), ArrivalDate DATE, ArrivalTime VARCHAR(5), DepartureTime VARCHAR(8))

INSERT INTO #Sample

(PurchCode, Provcode, ArrivalDate, ArrivalTime, DepartureTime)

SELECT '5A3', 'RD130', '01/02/2010', '18:13', '20:30:00' UNION ALL

SELECT...

Hi Richard

Thanks for providing the data, however, for anybody to be...

sgambale (8/17/2010)

---

Thanks for the replies. It makes sense that 1, 2, or 3 blanks is treated the same (with the entire column filled with blanks), but the empty string...

Do you run the same statement many times with different @assessmentID?

How long does...

Hi Richard

Can you give us some sample data please? This will get you started, and there are also notes in the link in my sig.

Cheers-- Create some sample data

CREATE TABLE...

What is the maximum number of rows for any orderno?

-----------------------------------------------------------

-- The Customer table is at the top of the hierarchy of

-- objects Customer, CustPhone, CustEmail, AddrDetail, AddrHeader

-- so use Customer as the driving table i.e. first in the...

Ok, starting at the beginning, does this query return the same as your second query:

SELECT DISTINCT mh.LocationID

FROM tblManifest mh

-- the reference to l.Route in the WHERE clause turns...

dennisv (8/16/2010)

---

Thank you.

Trying the last example I get these:

Msg 207, Level 16, State 1, Line 4

Invalid column name 'LocationID'.

Msg 207, Level 16, State 1, Line 4

Invalid column name 'LocationID'.

Msg 207,...

Hi Dennis, thanks for posting the feedback.

I think there's room for performance improvement here. The second query can be rewritten slightly like this - reasons are in the code:

SELECT DISTINCT...

Yep; if you take the ears off a rabbit, you got a draught excluder.

None of us here are psychic:-P

How about starting...

ningaraju.n (8/13/2010)

---

Hi All,

I am executing delete statement in production server and its taking more time . can any one please explain the reason

my delete statement looks like

: Delete from...

The reason I'm asking is this:

roelofsleroux (8/13/2010)

---

This function is used in a procedure where we step through about 6000+ LineUp records and use it to calculate what has been allocated...

Can you post the part of the procedure which utilises the function?

DROP TABLE #tb1

CREATE TABLE #tb1 (

[trade] [varchar](10) NULL,

[leg] [varchar](10) NULL, -----say it is my Unique key

[ccy] [varchar](10) NULL,

[idex] [varchar](10) NULL

)

INSERT INTO #tb1 (trade, leg, ccy, idex)

SELECT 'a1', 'b1', 'usd',...