SELECT 1 + DATEDIFF(DAY, 0, '20091217') % 7

Here http://developerworkshop.net/software.html

It also handles logarithmic, exponential and power regression.

UPDATEbt

SETbt.CustCode =CASE

WHEN x.LowerNum IS NULL THEN 'N'

ELSE 'Y'

END

FROMdbo.BatchTrans AS bt

LEFT JOIN(

SELECTLEFT(BottomRange + REPLICATE('0', 50), 50) AS LowerNum,

LEFT(TopRange + REPLICATE('9', 50), 50) AS HigherNum

FROMdbo.ForeignBins

) AS x ON x.LowerNum <= bt.CardNum

AND x.HigherNum...

How large are the BottomRange and TopRange intervals?

Please beware that a correlated subquery is an outer join.

If you have a value in target table before, and the correlated subquery doesn't return any value, the target table value...

I think OP wants several methods to concatenate result, which should work in all three RDMS's.

What we provided is a way for SQL Server to deal with this.

It's a monday...

OP, the senior application engineer, told us that ISADMIN columns had zeros in all the records. It is not true. It is column ISCONT that has zeros in all columns.

Here is a solution.

DECLARE@Emp TABLE

(

eno int,

ename varchar(5),

isemp bit,

iscont bit,

isadmin bit,

ishr bit

)

insert@emp

select1, 'aa', 1, 0, 0, 1 union all

select1, 'aa', 0, 0, 1, 1 union all

select1, 'aa', 1, 0, 0, 1...

No, ISCONT has zeros in all the records.

You can do this with SQL Server 2008 and the new table value parameters.

If you are working on a set of data, you can pass that set of data to...

It's quite tricky to answer because we haven't seen your code yet.

SELECT ROW_NUMBER() OVER PARTITON BY SSN ORDER BY Amount) AS row_num,

SSN, Amount

FROM Table1

See the GROUP BY part above. I added it now.

Well, I have some time left...

SELECTc.ConstructNo,

b.ImportanceBands,

COUNT(cib.ConstructNo) AS [Count]

FROM(

SELECTConstructNo

FROMCompetencyImportanceData

GROUP BYConstructNo

) AS c

CROSS JOIN(

SELECTImportanceBands

FROMImportanceLevelBands

GROUP BYImportanceBands

) AS b

LEFT JOINCompetencyImportanceData AS cib ON cib.ConstructNo = c.ConstructNo

AND cib.ImportanceScoreBand = b.ImportanceBands

GROUP BYc.ConstructNo,

b.ImportanceBands

Thank you. I thought I should post the link so that no more double unneccessary work is done.

I suggested your approach first, but after som clarifications, I saw that OP...