You're welcome.

Of course, it's fine!

WHERE (Row1 IS NOT NULL OR Row2 IS NOT NULL) .. or whatever.

But don't you want to know what the problem is, with an OR in...

namrata.dhanawade-1143388 (12/9/2009)

---

Well, the OR does work. So I am going to use this -

select RowID

from dbo.Table1 a

inner join dbo.Table2 b on (a.RowID = b.RowID1 and b.TableID1 = 30) OR...

Neither do I, it's so untidy.

Ryan Keast (12/9/2009)

---

[/code]

Now getting the following message -

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'Age'.

Server: Msg 207, Level 16, State 1, Line 1

Invalid column name...

Other than those pesky NULLS in the last row of your output where table B has no matches to table A, does the query do what you want it to...

<<while importing data>>

You could avoid a huge headache by importing your data into a staging table first, then pouring it into your real table. The staging table can have any...

The new column [Age range] has the new column [Age] as an input. It can't. You can either replace references to Age with the entire expression, or use an "onion"...

charu.verma (12/9/2009)

---

I am writing the following update query which is giving me an error saying more than 1 records returned by the subquery

update

p_audit set j_num = (select c.new_j_num from tbl1...

Left join twice to the same table:

SELECT a.*,

ISNULL(b1.TableID1, b2.TableID2) AS TableID,

ISNULL(b1.RowID1, b2.RowID2) AS RowID

FROM Table1 a

LEFT JOIN Table2 b1 ON b1.TableID1 = a.TableID AND b1.RowID1 = a.RowID

LEFT...

SELECT ClientNo, ContractNo, InstallmentNo, Amount, EBTDate, [Status]

FROM MyTable m

INNER JOIN (

SELECT clientno, Contractno, ebtdate

FROM MyTable

GROUP BY clientno, Contractno, ebtdate

HAVING COUNT(*) > 1) d

ON d.clientno = m.clientno

AND d.ContractNo = m.ContractNo...

Top work, Dom.

A CTE is like a derived table defined outside the main body of the query, with the advantage that you can refer to it multiple times in the...

DECLARE @FileNM VARCHAR(70)

SET @FileNM = 'Audio Visual Enterprise Centre (Sidney Str) CYP0076 Floor Plan'

;WITH Numbers AS (SELECT (N10 + N1) + 1 AS n

...

Here you go...

-- This is a crude numbers table and is not part of the solution

;WITH Numbers AS (SELECT (N10 + N1) + 1 AS n

FROM (SELECT CAST(0 AS...

Hi

Is that...

space - [word] - space - "floor" - space - "plan"

where [word] = 4 numerics '####', 5 numerics '#####' or 'CYP####'

Or to put it another way, you...