So what they want is a custom application so that users with no technical ability can query the database. It must be fast because the current application is not fast...

GAH! Didn't even think about this being interview questions....

Delete or truncate depending on your requirements.

2....

LoosinMaMind (6/30/2014)

---

More than 2 numbers is where the problems lies. !!!

I would like to have them showing as separate fields but there should never be more than 5 sets of...

SQLRNNR (6/30/2014)

---

Lynn Pettis (6/29/2014)

---

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are...

Glad you found a working solution. Even more glad you are willing to see if somebody can come up with another approach to get rid of the cursor.

In this example...

patrickmcginnis59 10839 (6/27/2014)

---

This is actually the insecure part I was...

Loner (6/27/2014)

---

I came up with this, not as good as Sean.

SELECT a.userid, u.NAME

FROM ( SELECT a.userid

FROM (SELECT u.*,

ROW_NUMBER() OVER(PARTITION BY u.userid ORDER BY u.colorid ) AS Row

FROM UserColor u )...

Here is one way. This was a very quick stab at this but it works.

select u.Name, u.Userid

from MyUser u

join UserColor uc on uc.Userid = u.Userid

group by u.NAME, u.Userid

having COUNT(*) =...

No the actual values are not sent to the client. The client passes UserName and password to the server. In a webapp this is all done on the webserver well...

Dominic Gagné (6/27/2014)

---

I have the following recordset:

cmdBatchNbPdsLbsZONE

817159644 1.55320031

817159652 9.09590031

817159679 ...

Sarah Wagner (6/27/2014)

---

First you don't need the quotes for your in, because year returns data type of int. (http://msdn.microsoft.com/en-us/library/ms186313.aspx) Using functions is not recommended in the where clause you...

hehe meant to put Amount = 0. Hopefully the query Jeff posted is close to what you...

atultiwari.eng06 (6/27/2014)

---

Table : Consumer

KNO Amount

8789 10

8896 15

6963 0

8959 30

8789 0

8896 0

6963 0

8959 0

select KNO from Consumer where...

You can...