November 9, 2009 at 9:56 am
Declare @reportingBeginDate datetime ,@reportingEndDate datetime
select * from dbo.application
where ProgramCode In('02','03','05') AND TermEnd Between @reportingBeginDate and @reportingEndDate
@reportingBeginDate and @reportingEndDate. where might they be getting their values?
this I am sure is so simple but my boss will not give me the answer. he referred me to a table where we keep stored proc info. that was a great answer. Ask the teacher a simple question and he tells me where I can find the answer. Well we my boss coworker have had heat on us for not being productive enough, not the best time play that game. He should of given me the answer so I could get this simple report and also told me for future reference where I can get the answer.
I never said I'm a T-sql guy.
November 9, 2009 at 10:03 am
Also if someone could point me to the code that exports what is selected to excel 2000 including column headers I would be quite thrilled. Currently we use SSIS but someone mentioned it can be dont in t-sql becuase we want to export this data monthly an wrap this in an sp.
November 13, 2009 at 4:26 am
Is there some code missing here??? The parameters are not being set at all from what you're showing us
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply