Chris Morris-439714 (1/27/2010)

Guess the OP didn't like the awkward questions there, Nabha - like which aggregate function to use for date. Since the same questions have arisen in this thread,...

Not sure if I am missing something here but isnt it the same query that was posted earlier here

I guess discussion was already started there!

Not sure if it would behave differently in linked server context!

DROP TABLE #S1

DROP TABLE #S2

CREATE TABLE #S1(ID int, VERSION int)

CREATE TABLE #S2(ID int, VERSION int)

INSERT INTO #S1 VALUES(1, 1)

INSERT INTO...

dean 62842 (1/26/2010)

---

I want to write a scheduled job for my database to run every night.

Essentially I need the job to match todays date in the database and then add...

May be the sum is giving a negetive value and they wanted to show absolute(positive value). Have a look at this,

SELECT -isnull(1, 0)

SELECT -isnull(-1, 0)

Not so elegant but this is what I could think of.. there could be an elegant way of doing it.

SELECT CONVERT(datetime, STUFF(REPLACE(<DateColumn>, '.', '/'), LEN(<DateColumn>)

- CHARINDEX('/',...

Will this do?

SELECT DISTINCT * FROM RANGES R1

WHERE EXISTS (SELECT 1

FROM RANGES R2

WHERE R1.ID = R2.ID

AND R1.Code = R2.CODE

AND ABS(R1.DOS -...

RPSql (1/25/2010)

---

I didn't submitted the correct data as I don't want to send company data out...Next time I will make sure to put question in right format...sorry this time...Plz let...

Are you sure the dates are only in these two formats?

'25/01/2010'

'25.01.2010'

Lorna-331036 (1/25/2010)

---

I also tried adding the Drivers table twice when creating the View but that didn’t work either. I can redesign the tables if you think that would be...

nothing actually 😛 (I guess so)...

Select convert(datetime, '25.01.2010', 104)

i think expected result is wrong!(isadmin would appear in the result but not iscont)

will this do?

select eno, CASE WHEN SUM(CASE WHEN isEmp = 1 THEN 1 ELSE 0...

UR welcome ..:-)

The "bad" thing about it: since CTEs made it so easy to use subqueries I think I tend to not spending enough time on trying to find an easier solution...