Search results for query: *

Hi all, I've seen some older posts with people inquiring about Siteminder and SSO, but I see no answers/responses to them. I am using Cognos 8 and my company would like to implement SSO through our portal, however I am hearing many different recommendations from Cognos so I am reaching out here...

I am trying to get just one record for each person who gets returned and a flag of either "Y" or "N" set on one column. The Y or N value comes from this kind of logic: Queries 2 tables. (Prof. claims and Inst. claims) I am looking for a specific code in both of those queries. (83655) So, in...

Hi All Here is the Query I am running. select distinct cast(rx_all.memberid as varchar) + cast(rx_all.dispdate as varchar)+ cast(rx_all.ndccode as varchar) as distinct_rx_claim , substring(convert( varchar,rx_all.Dispdate, 112), 5,2)+ '/' +right(convert( varchar,rx_all.Dispdate, 112), 2) +...

I have an off the shelf vendor application that uses fox version 9. In house, we have some foxpro code (version 6,8) that manipulates some of these dbfs that the vendor app creates and maintains. I am wondering if there is something I need to do with the tables or should the program and new...

Does anyone have any code that parses an ANSI 834 formatted file?

Hi all I've got a DTS package that I am successfully calling from a SP using the following command exec master..xp_cmdshell 'dtsrun /S Tahiti /E /N DTS_QA_leadscreeningoutput' The package is being found and run fine. The problem is this: There is a transformation being done TO a text file...

Can someone give me a few questions or concepts that you would expect someone who is a senior level .net devoloper to know and understand? We're interviewing for a senior level developer to comein and seriously hit the ground running, I'm not recruiting for that, we have plenty of candidates...

I have this the left table is people, I want to return all the people that are born during a certain date period (where clause) The other table is a claims table. from that table I need to only determine whether that person from the left table has had a claim that has a certain code. I want...

Can anyone tell me if there is an easy way to do handle going through years of data to pick out only the last 4 quarters of data? I have a date on the field and I know I pick that apart and get todays date and go back so far to find out what quarter it is and do a bunch of casting and date...

I think what I need is a self join, I'm just uncertain how to structure this. Here is the english. I have one table. From that table I want member name member rx label EARLIEST RX date LATEST PRESCRIBING DOC this information is found in several different records in the same table, but in...

Hi all I've got a couple queries successfully doing the following process: 1. Selecting all records that have a certain date range 2. From that query then I need to look into history table that can have several of the same "unique identifiers" and return all of the "history" for that "unique...

Hi all I have been reading lots of posts and in most I am getting the picture that looping is "poor practice"... and that you should build a user defined function. Can someone post a basic example of how you would accomplish simulated looping in a function? Here is the "english" of what I am...

I am trying to do this: declare @percent int, @convertedpercent int set @percent = 5 select @percent select cast(@percent/100 as decimal(5,2) ) (it's part of a bigger SP, but that's essentially where my problem is lying) All I am looking for is the result to read accurately 5/100 = .05...

I have a report that I created and it is leaving 4 or 5 inches of blank space at the bottom of the report. I have text boxes set up to remove the blank line if the field is empty. This works fine throughout the report, but for some reason it leaves a lot of space at the bottom of each page of...