You may need to try some dynamic SQL. In Books Online (assuming SQL
Server), look up "EXECUTE", paying special attention to the section
on "Using EXECUTE with a Character String". This will allow you to
dynamically add the date value you require to a SQL statement and
execute
it. Something like below:
DECLARE @CurrentDate datetime
SET @CurrentDate = getdate()
EXEC 'SELECT Assigned_Group, Assignee, Categorization_Tier_1,
Categorization_Tier_2, Categorization_Tier_3, Comment_1, Comment_2,
Comment_3, Comment_4,
Company, Create_date2, Department, Description,
Detailed_Decription, First_Name, Group_Transfers, Incident_Number,
Individual_Transfers,
Last_Name, Modified_date,
Original_Incident_Number,
Priority, Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3, Question_1_Rating,
Question_2_Rating, Question_3_Rating, Question_4_Rating, Re_Opened_Date,
Request_ID,
Resolution, Service_Type, Site, Status_,
Submit_Date,
Submitted_By2, Survey_ID, Total_Transfers
FROM SAGE_RQC_SurveyReporting
WHERE Create_date2 >= ''' + @CurrentDate + ''''
Best Regards,
Jim.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
