kinnon_2000 (3/31/2009)

---

Hi,

Order is determined by the customer via the gui.

if the user adds a member to a group using the gui, the default order is the last order...

Allan, to reiterate Ade The main question is how do you decide about the order. what do you want the values in the [order] column to be dependant upon?

The...

Reckon Flo's got the nail on the head here - so all we need is some sample data:

DROP TABLE #GroupMembers

CREATE TABLE #GroupMembers (

Group_member_id INT,

Member_id INT,

Group_id INT,

[Order] INT)

INSERT INTO #GroupMembers (Group_member_id,...

mithun.gite (3/31/2009)

---

I think this is not the expected and best of ur reply....

but fine,,, i respect u sir....dnt get angry on me....

I m just raising my doubts........

I will check and...

mithun.gite (3/31/2009)

---

superb,, now can u tell me if i have used joins of two-three tables , and

then in case statment i m using these tables's columns based...

No kidding, Kinnon!

If these ID's are used by the database and are PK's and FK's, then don't change them - they're there for the...

mithun.gite (3/31/2009)

---

Dear Friend,

I think when u use case in select statement it has to process it row by row just like the function we use....so it might hit the perofrmance...

mithun.gite (3/31/2009)

---

hi,

as per me avoid using cases in select stmt... and better u go with the union all option , i think i would have opted for union all as...

CAST to INT isn't necessary, according to BOL YEAR() "Returns an integer that represents the year of the specified date."

SELECT * FROM tbl WHERE imgdata IS NULL

NULL isn't equal to anything, hence the special operator.

Hi Paul

Quite possibly, but we'll need more information from you. Firstly, let's have a look at the original query. I've added table aliases to make it easier to read, and...

It helps a lot - if the data doesn't matter to you, then don't use it. Your query will be a lot simpler. Just group by your three required columns.

Michael you may not have found a par playmate on this one but here's some sealion clapping for originality...

You're welcome Blanktree, thanks for the feedback.

If you don't already know, TSQL has two flavours of CASE, simple and searched. The query above uses the searched flavour because the conditions...

Spot on. I should have known that you would have tried and covered all bases 😎