Hi Carleton,

I have done the same way as you have suggested but the only difference...

I got a workaround to this but its not a good way but it works. But I would still like to work on this.

I stored all the selected districts...

ALTER PROCEDURE SA_STPR_Report_CAPSignup_ByDistrict

@DistrictId varchar(255),

@year int

AS

BEGIN

CREATE TABLE #t

(

dealerid varchar(50),

dealername varchar(255),

district varchar(255),

tmname varchar(255),

packagename varchar(100),

totalinvestment varchar(100),

coopclaim varchar(10),

submissiondate datetime

)

INSERT INTO #t

SELECTcss.dealerid,

c.dealer_name,

d.DISTRICT_NAME,

t.TMName,

NULL,

NULL,

c.coop_claim,

css.submission_date

FROMcurrent_signup_submission css

INNER JOIN current_dealers c ON c.dealerid = css.dealerid AND css.year = c.year

INNER JOIN...

Thanks PS. That helped.

Thanks for the post Luke. I did try the other way to make this work. Though, it has turned out to be a long query, but I think I am...

Yeah it was the space and the @sql was to be wrapped around a parenthesis. I did that and now it says it can't find the @startDate and @endDate.

ALTER PROCEDURE...

Hey Luke,

I get this error when I execute the stored proc.

The name 'SELECT u.FirstName + ' '...

Thanks Luke, I will try this and will let you know.

I did export the data into tab delimited instead of csv and this...

How would I handle any fields that has a comma in them. Right now, if a field has abc co, inc..then the outdata data is shown as abc co, inc...

I got this figured out. I was trying to open the file in notepad which by default opens the txt file in notepad. The notepad cannot open that big file,...

What I did was I closed the application, then I closed the sql server management studio..reopen the mgmt studio, then ran that query and this time it worked. Since I...

PlanIdintUnchecked

CampaignIdvarchar(50)

OrganizationIdint

CenterIdint

PlanNameIdint

Budgetmoney

MediaTypeIdint

SegmentIdint

yearint

SubmittedByvarchar(255)

CoopClaimbit

Commentstext

Activebit

IncludeinBlockingChartbit

IncludeinWorkBack bit

IncludeonGMCalbit

LastModifiedUservarchar(255)

LastModifiedDatedatetime

Thanks for all your guys input. After talking to my boss, we will either move this database to a sql server or we will upgrade the sql express. This forum...

Hi Krishna,

Thanks for the info. I thought at some point of time, the sql server express was...