Home Forums SQL Server 2005 SQL Server 2005 General Discussion To set the quarter date according to the date flag. RE: To set the quarter date according to the date flag.

  • September 8, 2015 at 7:21 am

    #1825113

    no input, just consumable data to help:

    ;WITH EstimatedData([QuarterDate],[sf_115],[sf_315],[sf_415],[sf_515],[sf_615],[sf_915],[sf_1015],[sf_1115],[sf_1215])

    AS

    (

    SELECT CONVERT(DATETIME,'01-15 -2015'),'1',NULL,NULL,NULL,NULL,'1',NULL,'1',NULL UNION ALL

    SELECT '12-15-2015',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1' UNION ALL

    SELECT '09-30-2015',NULL,'1',NULL,'1',NULL,'1',NULL,'1',NULL

    )

    SELECT QuarterDate,

    sf_115,

    sf_315,

    sf_415,

    sf_515,

    sf_615,

    sf_915,

    sf_1015,

    sf_1115,

    sf_1215

    FROM EstimatedData

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!