GSquared (4/16/2009)

---

Alvin Ramard (4/16/2009)

---

She was in "Bride of the...

What? Only in that one movie?

Hi Pieter, there was a discussion about this quite recently which...

SELECT ISNULL(ITPolicyName, 'No Policy Assigned') AS Category,

COUNT(*) AS TotalNumber

FROM table1

GROUP BY ISNULL(ITPolicyName, 'No Policy Assigned')

ORDER BY 2

Using this excellent suggestion, try the following:

SELECT R.RID, F.from_dos, T.ICDCOD

--MIN(CONVERT(DATETIME, F.from_dos, 12)) AS EARLYRDATE

FROM R7541f6 F

INNER JOIN DISABILITYCALIMS...

Hey get some rest Barry! Like the first part of your article,...

adonavon (4/15/2009)

---

Hello, I was wondering if anyone could help with this T-SQL problem that is stumping me.

Here is the current UPDATE statement that works; the subselect only returns 1 result...

dheer (4/15/2009)

---

I have one table name CALIMS and i want to select 2 columns

SELECT RID ,DATE

FROM CALIMS

WHERE DAG='Y'

and again want to select the data from the same same talbe...

You're welcome!

There's no option for marking a thread as "answered" - they're all kept open for reference. Also, someone could come along yet with a killer solution.

Cheers

ChrisM

Thank you for providing the sample data. Your requirement is very difficult to understand, there is probably a language difference. Can you please provide a sample of what you expect...

Aha, gotcha! Thanks for the clarification. Blonde moment. Try this:

DROP TABLE #temp

CREATE TABLE #temp ([ID] INT, Meal VARCHAR(20), [Order] INT)

INSERT INTO #temp ([ID], Meal, [Order])

SELECT 1, 'Tomato Soup', 1 UNION...

@puyinc (4/15/2009)

---

There is no formal relationship between FirstOnes (entrances) and SecondOnes (Main Dishes). The resultant query will be something like a Restaurant's Menu, where one column will be Entrances...

Bit by bit - and of course they need those dandy RBARS on...

I'm very sorry bvinay, I have...

Anyone for pork chops?