i have this as my sp so far... i am getting the following errors. what is incorrect??

Msg 319, Level 15, State 1, Line 18

Incorrect syntax near the keyword 'with'. If...

this is a different query then i am use to using....

i know need to declare my dates, where do i place them?

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER Procedure [dbo].[spActivityByRegion_TEST] (@start_date1 datetime,...

replication date is a date field

i havent yet, will work with today(hoepfully)

i will keep you posted, thanks for your help

when the sp was created, distinct was neccessary. table has been cleaned up since.

i use all the fields in the report,

replication date is a date field when the...

thank you thank you thank you

i did double click the error message and it brings me to the end of the procedure

Incorrect syntax near 'SEASON_2'.

the procedure posted before is using just the one table...

no need to be snide.

I think i have it figured out. dont have time to read all that information you posted for rules and regulations. i think they way i post my questions are...

i have files that get sent to us i believe in a flat file(not sure yet). someone them puts them in excel. then creates a table from them.(not sure of...

thanks that helps but what i need to finally accomplish is have each value added to a seperate column in a new table.

thanks but i figured it out. i dont need a book, but thanks for the input

The table i am quering has over 70000 records, so all is acceptable on some. different thought

i want to return the data set based upon the parameter selection - how...

thank you, these are my parameters

ALTER PROCEDURE [dbo].[CR_CUSTVOL]

(@SGYR INT)

--@REGION INT,

--@ACCOUNT varchar(20))

--@SEASON Varchar(2),

--@SALESPERSON INT,

--@STORE INT)

this is my where statement, i dont know the exact syntax, im not a newbie,...