tsql - Add Null rows to table in stored procedure -


i have table:

 row_group           col_group         claim_count      denial_amount not medic nec/pre-x october 2010    6                591.50 not medic nec/pre-x november 2010   8                3154.48 duplicate             october 2010    39               7921.78 duplicate             november 2010   35               7484.17 registration           october 2010    56               10622.55 registration           november 2010   67               7820.69 timely filing          september 2010  6                239.00 timely filing          october 2010 67               8389.25 timely filing         november 2010   6                51127.96

i need able add september (or col_group field) table nulls in claim_count , denial_amount. row_group , col_group dynamically generated can't update fields, has done within stored procedure. mentioned outer left join might create these nulls me, not sure how. suggestions helpful.

it suggested use sql statement colleague @ work, doesn't seem work:

select #trend.row_group, distincttime.col_group, #trend.claim_count, #trend.denial_amount (select distinct #trend.col_group #trend)  distincttime left outer join #trend on  distincttime.col_group = #trend.col_group

the reason needed report builder wasn't viewing dates dates , couldn't trend them. solved using sql function. i'm posting here dealing mdx , having deal weird dates. 

use [dmds] go /****** object:  userdefinedfunction [dbo].[monthformat]    script date: 12/02/2010 14:02:03 ******/ set ansi_nulls on go set quoted_identifier on go alter function [dbo].[monthformat](@date varchar(25)) returns date      begin          declare @retval varchar(50)          select @retval = case              when @date 'jan%' '01/01/' + right(@date,4)             when @date 'feb%' '02/01/' + right(@date,4)             when @date 'march%' '03/01/' + right(@date,4)             when @date 'apr%' '04/01/' + right(@date,4)             when @date 'may%' '05/01/' + right(@date,4)             when @date 'jun%' '06/01/' + right(@date,4)             when @date 'jul%' '07/01/' + right(@date,4)             when @date 'aug%' '08/01/' + right(@date,4)             when @date 'sept%' '09/01/' + right(@date,4)             when @date 'oct%' '10/01/' + right(@date,4)             when @date 'nov%' '11/01/' + right(@date,4)             when @date 'dec%' '12/01/' + right(@date,4)             end     return @retval end

Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more