John Hanrahan (3/21/2013)

---

Thanks for the response. I was just hoping someone would say look at xxxx or such. It's my first ever request for help I believe....

Alan.B (3/21/2013)

---

The query below should do the trick. I don't know what day counts as "Media Start of Week" but I went with monday (isowk). Also, I don't know what...

markcrosbie (3/21/2013)

---

How do I sleect from a populated temporary table using a dynamic query

declare @Tmp table (.....)

SET @SQLString =N'select * from @Tmp'

EXECUTE sp_executesql @SQLString

I am getting : Must declare the...

In the sys.indexes table an index_id of 0 indicates that the table is a heap, no clustered index. An index_id of 1 indicates that there is a clustered index....

sqldba_newbie (3/21/2013)

---

I have a query which does a order by at the end.

where WFID ='Something'

Order by Rkey asc, NFD desc

And my index is:

CREATE NONCLUSTERED INDEX [temp] ON [dbo].[WrkFS]

(

[WFid] ASC,

[SId] ASC,

[NFTId]...

Adjust this piece of...

The one you work with now. However, it is possible that one or both will access tempdb or that one or both will reside completely in memory. It...

I think this is a good example of why you (the OP) should provide full disclosure when asking a question. Eugene's first answer is a good one based limited...

Also, based on the phrasing of the question, it looks like a query against historical data. If all statuses were to be returned it could have been interpreted as...

Sean Lange (3/21/2013)

---

Lynn Pettis (3/21/2013)

---

Sean Lange (3/21/2013)

---

Lynn Pettis (3/20/2013)

---

Sean Lange (3/20/2013)

---

I think that the above would miss Claim 7149 which as I read your issue should show up on the...

Sean Lange (3/21/2013)

---

Lynn Pettis (3/20/2013)

---

Sean Lange (3/20/2013)

---

I think that the above would miss Claim 7149 which as I read your issue should show up on the list. This is easy...

Try this:

select whoverified, whochecked AS 'userid', count(*) whoverified, count (*) whochecked

from rxproductivity

join users us1 on rxproductivity.whoverified = us1.userid

join users us2 on rxproductivity.whochecked = us2.userid

group by whoverified, whochecked

having count(whoverified) >...

Jay-246689 (3/20/2013)

---

Thanks for all the reply, i been focus on other things and just read your messages. So it seems it is already optimized (Casting). Yes, on the latter part...

I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and expect a free forum staffed by...

Look carefully at my code, I convert the datetime value to a date only...