Correct SQL Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a lag analysis project and am curious how you might go about
arranging the categories. Would you create a new column or several new
columns? I have a beginning date range as well as an ending date range. In
need to include various intervals, i.e., 1-2 days, 3-7 days, etc. What sort
of SQL statement would you use to satisfy this? I was thinking about an IIF
statement with 'date' BETWEEN 'date' and then another IIF statement, etc.?
What would you do?
 
Chris,
I am unable to understand what you are asking here. I can not speak for
others but for myself, I would need more information. It almost looks like
you are asking if it would be better to create columns with the names of "1-2
Days" and "3-7 Days" etc... instead of creating one column with these
inserted as data? And then following that with another question of IIF
statements within your SQL. It may just be me, however, I believe anybody
looking at this post is going to require more information. Hoping to help! ~
Take Care & God Bless ~ SPARKER ~
 
Back
Top