How about pasting the assignment here so we don't have to guess what you're trying to...

The values of i (1, 2 and 3) have a value of j which is common to all of them (4). Another way to view this: a value of j...

karthik babu (3/18/2014)

---

i have the below table.. i need the intersection of j with group by of i column, which is 4. pls let me know the query to arrive...

HanShi (3/18/2014)

---

The value in column "tm.LIBTYPMVT" differs, so this will result in a single row for each value. If you remove column "tm.LIBTYPMVT" from the SELECT list, the results will...

Use table aliases to eliminate unnecessary noise from your queries,...

So if you have an empid with...

david.dartnell (3/16/2014)

---

Hi Everyone,

I would like to 'drop' some trailing zeros from a decimal value, e.g.: 50.000000, and I am wondering how to go about this?

The value is definitely of decimal...

rock

What makes 2 and 3 different from 1?

How...

Grant Fritchey (3/14/2014)

---

Ed Wagner (3/14/2014)

---

Grant Fritchey (3/14/2014)

---

Yeah, that one is killing me. Vague weirdness, badly edited execution plans...

Any time.

There are several ways to write this query, including joining the lookup to the original query as a derived table.

Thanks for the feedback.

SELECT

EnqueueDate = CAST(m.EnqueueDate AS DATE),

m.Siteid,

s.[SiteID name],

Total = COUNT(*)

FROM MessageQueue m

INNER JOIN SiteID s

ON s.SiteID = m.SiteID

GROUP BY

CAST(m.EnqueueDate AS DATE),

m.Siteid,

s.[SiteID name]

ORDER BY m.EnqueueDate DESC

You're welcome, good luck.

Sure, try this:

SELECT processingday = CAST(processingday AS DATE), ID, COUNT(*)

FROM mytable

GROUP BY CAST(processingday AS DATE), ID

MickyD (3/13/2014)

---

Hi everyone.

Can someone offers some advice on how to achieve this.

I need to count the number of records that exist for a distinct value in a table.

I.e. On...