eobiki10 (12/20/2013)

---

Thanks SSC veteran and SSC Champion for your suggestions and also performance tips. However Sean, I would like to know the format that you used to get the SQL...

SQLRNNR (12/20/2013)

---

Based on this set of questions posted elsewhere by the same person, it looks like exam questions or homework questions to me.

It guess it could be interview questions too....

This sounds like a Jeopardy question.

I will take "Obscure out of context IT questions" for 800 Alex.

It's the Daily Double!!!

Lowell (12/20/2013)

---

well, i dunno about the kudos, but thank...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1525134-391-1.aspx

OK. Then you need to provide a lot more detail here. Your post is extremely vague but I it sounds like you...

And that code is all Lowell, I merely made a extremely minor modification to it. All kudos belong to Lowell.

Please don't create new threads in the middle of a discussion. You already started this topic over here. http://www.sqlservercentral.com/Forums/Topic1525064-2799-1.aspx

Mile Higher Than Sea Level (12/20/2013)

---

Our MSAccess applications use dsn-less connections with SQL Server Native Client (are distrubuted with Citrix).

While building a maintenance form for the Access users to perform...

Can...

Using a subselect as a derived column is performance time bomb. You have at least a couple of those in there already. You also have a split function in there...

ashuthinks (12/20/2013)

---

i want to create a database structure for following :

1 member can have many groups

1 group can have only one group member

1 group can be joined by many members

please...

duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1525053-2799-1.aspx

Grant Fritchey (12/20/2013)

---

Sean Lange (12/20/2013)

---

Well strange was not a good choice of words. Some are quite difficult to answer because there is no single choice that would work. On questions...

sqlnaive (12/20/2013)

---

Thanks Sean/Kurt for the wonderful query.

One update to the requirement and one query.

Modification is that there might be some students who have only one or two or all of...