WITH CTE AS (

SELECT Customer, MAX(Trx) AS Trx

FROM MyTable

WHERE Trx IS NOT NULL

GROUP BY Customer

HAVING COUNT(DISTINCT Trx)=1)

UPDATE m

SET Trx=c.Trx

FROM MyTable m

INNER JOIN CTE c ON c.Customer=m.Customer

WHERE m.Trx...

Apologies, should have...

SELECT KEY1,KEY2,OTHERCOL1,OTHERCOL2,OTHERCOL3 FROM TABLE1

WHERE NOT EXISTS (SELECT * FROM TABLE2 WHERE TABLE2.KEY1=TABLE1.KEY1 AND TABLE2.KEY2=TABLE1.KEY1)

Any of these

Select col1,col2, COALESCE(col3,'def value') as col3 from tbl1

Select col1,col2, ISNULL(col3,'def value') as col3 from tbl1

Select col1,col2, CASE WHEN col3 IS NULL THEN 'def value' ELSE col3 END as...

Mark-101232 (1/4/2010)

---

Try this, not particularly efficient though.

WITH Start_Dates AS(

SELECT s1.Group_ID,s1.Start_Date

FROM Source_Data s1

WHERE NOT EXISTS(SELECT * FROM Source_Data s2

...

Try this, not particularly efficient though.

WITH Start_Dates AS(

SELECT s1.Group_ID,s1.Start_Date

FROM Source_Data s1

WHERE NOT EXISTS(SELECT * FROM Source_Data s2

...

Use ISNULL or COALESCE

SELECT case_sk, COALESCE(pick_date,'112009') AS pick_date, ROW_NUMBER() OVER (ORDER BY cp.pick_date) AS row

Try changing your subquery from

SELECT pickdate

FROM #DaysinStatus

WHERE #DaysinStatus.rownum = #DaysinStatus.rownum + 1

to

SELECT a.pickdate

FROM #DaysinStatus a

WHERE #DaysinStatus.rownum = a.rownum + 1

I think from your description, you're after candidates with all skills from one or more skills groups. So in your example

the candidate would have to have both "Java and Perl"...

Just some string manipulation functions, such as Levenshtein and InitCap. All of which could be coded in TSQL but are easy to do in C# (InitCap is a one-liner).

SELECT r.value('@ProductID', 'int') AS PID,

r.value('@ProductName', 'varchar(40)') AS PName

FROM T

CROSS APPLY CatalogDescription.nodes('/ProductDescription') AS x(r)

Maybe this?

SELECT MIN(Col1) AS StartingNumber,

AVG(Col2*1.0) AS AvgValue

FROM dbo.Table_1

GROUP BY (Col1-1) / 5

ORDER BY MIN(Col1)

Change

Age Range

to

[Age Range]

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate='20100901'

SET @EndDate='20100921';

WITH CTE1 AS (

SELECT CASE WHEN FromDate>=@StartDate THEN FromDate ELSE @StartDate END AS StartDate,

CASE WHEN ToDate<=@EndDate THEN...

Have a look here

http://unicode.org/faq/utf_bom.html

The Byte Order Mark at the start of the file indicates the unicode encoding. You'll need to examine the first few bytes of the file.