Viewing 15 posts - 8,371 through 8,385 (of 10,144 total)
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...
December 9, 2009 at 9:06 am
namrata.dhanawade-1143388 (12/9/2009)
select RowID
from dbo.Table1 a
inner join dbo.Table2 b on (a.RowID = b.RowID1 and b.TableID1 = 30) OR...
December 9, 2009 at 8:57 am
namrata.dhanawade-1143388 (12/9/2009)
And I dont want to check for NULLS in the where clause
Neither do I, it's so untidy.
December 9, 2009 at 8:43 am
Ryan Keast (12/9/2009)
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...
December 9, 2009 at 8:30 am
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...
December 9, 2009 at 7:58 am
<<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...
December 9, 2009 at 7:08 am
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"...
December 9, 2009 at 6:58 am
charu.verma (12/9/2009)
update
p_audit set j_num = (select c.new_j_num from tbl1...
December 9, 2009 at 5:24 am
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...
December 9, 2009 at 4:37 am
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...
December 9, 2009 at 3:32 am
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...
December 9, 2009 at 2:11 am
DECLARE @FileNM VARCHAR(70)
SET @FileNM = 'Audio Visual Enterprise Centre (Sidney Str) CYP0076 Floor Plan'
;WITH Numbers AS (SELECT (N10 + N1) + 1 AS n
...
December 8, 2009 at 9:25 am
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...
December 8, 2009 at 8:45 am
Hi
Is that...
space - [word] - space - "floor" - space - "plan"
where [word] = 4 numerics '####', 5 numerics '#####' or 'CYP####'
Or to put it another way, you...
December 8, 2009 at 8:14 am
Viewing 15 posts - 8,371 through 8,385 (of 10,144 total)