Thank you

artsapimp — Thu, 18 Sep 2003 02:07:00 +0000

Thank you.

I did find the answer and Mark you are very close to it. I originally did exactly what you suggested but still generated errors about names not being specified. I was forced to give each field a name where it would usually default to Expr1 like @Month AS myMonth.

Thanks again for your help.

Mark Hensler — Thu, 18 Sep 2003 01:05:40 +0000

You can use static values in SELECT queries. I've used this method in MySQL when moving data from one table to another.

SELECT field1, field2, 'contant value' FROM table1

Now when it comes to stored procs, I have no experience there. But I would assume the theory would be the same...

SELECT DISTINCT TOP 100 PERCENT AgentID, Agent, AVG(Score) AS avgScore, CategoryID, @Month, @Year

PS - CategoryID is also a field (not just a @Var), so you can use that.

hmm... perhaps: MONTH(RecordTime), YEAR(RecordTime) ??

m3rajk — Tue, 16 Sep 2003 18:46:07 +0000

are you INSERTING into a new table? or searching on two tables? i'm not quite clear on that.

if you're trying to sleect from two tables, have you thought about using join?