Jackie Bird
Last Activity: Jan 17 '11, 04:57 PM
Joined: Dec 16 '10
Location:
-
Jackie Bird replied to How can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIMEin SQL ServerThe Age_Group ranges are 1-3, 4-6, 7-13 and 14+. CURR_BAMTIME can be a value from 1-500. -
Jackie Bird replied to How can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIMEin SQL ServerSure, thanks for asking.
Say CURR_BAMTME is 1, then Age_Group needs to be "1-3", or if CURR_BAMTIME is 2, then Age_Group needs to be "1-3". All the Whens are not listed to catch all possible values of CURR_BAMTIME, but the 1-3 Age_Group is good enough for the example here.
Thanks, again!Leave a comment:
-
Jackie Bird started a topic How can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIMEin SQL ServerHow can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIME
...Code:USE [REP] GO /****** Object: StoredProcedure [dbo].[rpt_AR] Script Date: 12/16/2010 11:35:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[rpt_AR] AS BEGIN SET NOCOUNT ON; Select Case When DB_Source = 'IMVPB' and DATEDIFF(dd, dAssignedDate, DATEADD(dd, 0, Getdate())) -(DATEDIFF(wk, dAssignedDate,
No activity results to display
Leave a comment: