Select FirstCommunityChoice, Count(FirstCommunityChoice) as 'Community Count'

From dbo.tblApplicationCommunities

Group By FirstCommunityChoice

This will fix what you have:

declare @startdate Datetime

declare @enddate Datetime

set @startdate = getdate()-480

set @enddate = getdate()-90

--set @vStart = select convert(varchar,@startdate, 102)

print @startdate

print @enddate

WHILE (@startdate < @enddate)

BEGIN

print 'delete from vending where...

I think you're looking for something like this:

CREATE TRIGGER trigger_test ON test FOR UPDATE

AS

SET NOCOUNT ON

IF UPDATE(column9) OR UPDATE(column10) OR UPDATE(column11)

BEGIN

--do your main DML here

END

Not only confusing, but dangerous! I'm reading Defensive Database Programming by Kuznetsov and he describes where any triggers on the table in the code above will be affected by the...

Ajay.Kedar (4/25/2011)

---

BOL is right, Ser rowcount overwrites the TOP function used in select statement. The statements will get executed from right to left so first Select statement will get executed...

SQLkiwi (4/24/2011)

---

It's a good thing to know, because SET ROWCOUNT will not work with INSERT, DELETE, or UPDATE in the next...

I didn't know INSERT could have a TOP clause. Now it makes sense. Thank you.

I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here use...

You're in the wrong forum. This has very little to do with SQL Server. My company also has many databases offshore and do you know what I do when I...

Your UDF is based on getting the next box number of that day's orders. So I'm saying don't join tblOrders to avoid locking it and instead pass the procedure the...

Multiple columns (not fields) won't matter. Try it out and you'll see that they are tacked on to the end of the rows just like a scalar total. You'll only...

Yes, you can tack on as many as you like if your additional queries return one value. If they contain more than one row, your results will cross-multiply and we'll...

Ah, I thought you would copy the whole queries from the first post into the parenthesis. If these are views, then just remove the parenthesis.

SELECT *

FROM...

Copy and paste what you currently have.

None, just paste your queries where I...