Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #51  
Old 05-02-2019, 06:34 PM
Helena Lake's Avatar
Helena Lake Helena Lake is offline
Member
SOA AAA
 
Join Date: Jan 2019
Studying for Nothing ever again!
Favorite beer: Whisky
Posts: 6,203
Default

Quote:
Originally Posted by Meshuga View Post
ms sql has some things not available in nzsql. there would be no easy way to do this on netezza since you don't have variables and can't create dynamic sql unless you're using a stored procedure.

the only problem with your sql is, like you said, repeat the last two steps for each mod_code that he has. with the dynamic sql that is not a concern as you can perform a count to find the number of codes and then loop to create a field for the number of codes you have,
Way better. NZA was good for some things, but really limiting for a lot of others.
__________________
Quote:
Originally Posted by BernieSanders2016 View Post
I don't think calling beliefs absurd and bullshit is criticism, it's insulting.
Reply With Quote
  #52  
Old 05-02-2019, 06:37 PM
Helena Lake's Avatar
Helena Lake Helena Lake is offline
Member
SOA AAA
 
Join Date: Jan 2019
Studying for Nothing ever again!
Favorite beer: Whisky
Posts: 6,203
Default

Quote:
Originally Posted by Meshuga View Post
i like your sql but you're maxing out at 4 mod_codes, where he says above there are 200ish
I thought he said that around 200 codes exiszt, but no diagnosis can have all 200 of them. I thought he said each dx only had like 3 or so.
__________________
Quote:
Originally Posted by BernieSanders2016 View Post
I don't think calling beliefs absurd and bullshit is criticism, it's insulting.
Reply With Quote
  #53  
Old 05-03-2019, 09:47 AM
Steve Grondin Steve Grondin is offline
Member
SOA AAA
 
Join Date: Nov 2001
Posts: 6,784
Default

Quote:
Originally Posted by Steve Grondin View Post
Note that behavior is different if the zero length strings in the input data are NULLs. Records with NULL in mod_code are dropped from results set.
If you make this change
Code:
((SELECT A.Claim_sk, A.proc_code, a.mod_code, count(*) AS
it might handle NULLs
Reply With Quote
Reply

Tags
microsoft sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 10:13 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.14033 seconds with 9 queries