Heh no worries. Try this;

SELECT

MarketName,

COUNT(*)

FROM (

SELECT --top 100 percent

f.FormName,

m.MarketName

FROM Form f

INNER JOIN FormMarkets_Link l

ON f.FormID =...

It works fine on 2008R2, that's what I tested the script on. Are you sure that the server you...

CassieF (2/11/2013)

---

thank you, i just tried to execute that and it gave me an incorr syntax error near keyword Over..:doze:

it also didnt pink out the first [count] so i...

sku370870 (2/10/2013)

---

DECLARE @LastOne bit = 0

CREATE TABLE #tblTasks

(

TaskID int,

...

Ed Wagner (2/11/2013)

---

Is this what you're looking for?

insert into different_table(computername, auditid, auditdate)

select computername, auditid, auditdate

from original_table a1

where auditdate =...

Paul Munter (2/11/2013)

---

Thanks for the advice, I was hoping to store it to avoid the computations being done by an application. I like to have as much stored as possible...

You can have whatever headings you want:

SELECT [Count] = 1, [Market name] = 'Borough Market'

What's important is the column content. Can you explain further? Is it something like this?

SELECT...

Paul Munter (2/11/2013)

---

I'd like to be able to write a cursor of similar code which does this dynamically for me based on a data set that I have. So I...

Cool, it was a lucky guess. Now what do you want to do with it?

Something like this?

DROP TABLE #mytable

CREATE TABLE #mytable

(P_KEY INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

LAST_DAY_OF_MONTH DATETIME,...

Hi Paul

You have rows in your table which have a datetime column. You want to pick some rows which have a "recent" date, from the table. On the same output...

Hi Jason, it's been subjected to a significant...

lilywhites (2/11/2013)

---

ive got over 500 queues and 15 extra data columns to compute also....would those links scale up??

ive got this running in under 20 seconds....ill look into those other methods

many...

huy1002 (2/10/2013)

---

Master table

ComputerName. AuditId. AuditDate.

A. 111. 1/1/13

A. 222. 2/1/13

A. 000. 2/1/13

B. 111. 1/1/13

C. 000. 1/1/13

C. 111. 2/1/13

AuditId equals to zero telling no vulnerability found on that day scan.

I need...

Jason-299789 (2/11/2013)

---

You might wnat to revisit the code, I would suggest reading this article http://www.sqlservercentral.com/articles/T-SQL/61539/ and then look at a turning this into a Quirky update for the Running total,...