Why do you think the query should return only one row (or none) regardless of how many rows may or may not match the filter?

I'm not sure if this...

Look up CONVERT in BOL, and choose the 'Style' which matches your text date. 106 looks promising even though...

Humble apologies. Revised code attached.

Declare @t Table

(

id int,

EmpName nvarchar(500),

...

What datatype are the 'date' columns in your table?

Sure. Here's a start:

-- create a sequence table (this...

Study the code, if there's anything you are unsure of, then please ask 🙂

You don't need a cursor for this, it's a simple UPDATE...FROM:

UPDATE l SET

CAL_HEADER_ID= @PVC_CALENDAR_HEADER_ID,

PERIOD_NAME= t.ATTRIBUTE2, --@lvc_period_name,

FROM_DATE= CONVERT(VARCHAR(11),LTRIM(RTRIM(t.ATTRIBUTE3)), 106), --@ld_from_date_1,

TO_DATE= CONVERT(VARCHAR(11),LTRIM(RTRIM(t.ATTRIBUTE4)), 106), --@ld_to_date_1,

QUARTER_NUM= t.ATTRIBUTE5, --@li_quarter_num,

F_YEAR= t.ATTRIBUTE6, --@lvc_f_year,

ADJUSTING_PERIOD = t.ATTRIBUTE7, --@li_adjusting_period,

TRN= @PBI_TRN,

STATUS=...

SELECT s.*, x.*

FROM @t s

CROSS APPLY (

SELECT EmpNamePart = SUBSTRING(s.EmpName, b, e), b, e

FROM (

SELECT

n.n AS b, -- delimiter at beginning of string

ISNULL(NULLIF(CHARINDEX(',', s.EmpName, n.n+1), 0), LEN(s.EmpName)+1)-1...

When you wrapped your query in another SELECT (sometimes - usefully - known as an onion select), you removed the DISTINCT. Remember "ORDER BY items must appear in the select...

Just as the message says,

Msg 145, Level 15, State 1, Line 14

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Try this, which works

;WITH TestCTE...

The update is performed strictly...

You don't. You DECLARE it, then use it, exactly the same as you might in an SSMS window.

Can you give us a few more details of what it is you...

Tom.Thomson (10/19/2010)

---

Ray K (10/19/2010)

---

Boy, this thread's been too quiet lately. Let's stir the pot a bit.

How about . . . neat things to do or places to see...

Foreplay

mpalaparthi (10/18/2010)

---

Hello SQL Experts,

I have a question.... I have 3 tables (table1, table 2 and table3)

table1: ...