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...

... if I may... I've read this post and gone to all the others that are suggested, and I am still having a problem. I have a slightly different task, I am trying to call a fox exe from a SQL DTS package. I DO have all of the DLL's in all the of the directories that are mentioned that they need...

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

just in case anyone ever runs into this... i figured out my problem. the sqlsa login which is what was calling the sp didn't have the rights to the shared drive that the files were stiting on... moving the files to the local machine fixed this problem

C'mon all these smart people and nobody has a response for this one?????

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...

I like all of these ides, thank you much for helping. One additional question I have to ask, though, is how to have them prove that they know these concepts without actually making them sit down and code because I agree that I don't think putting them on the spot proves anything really b/c they...

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...

Thanks for that. This returns all the claims, though too, I just ran it. I get all the members as many times as there are claims for that member. What am I doing wrong? I'm after each member ONE time with a Y or N to the question of do they have a claim with this proccode. I probably didn't...

Can you help me understand why I am looking for NULL? or is that where I plug in the number I want to look for - the 83655.

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...

so nobody has any ideas about this? I thought it would have been a more common task...

sorry, grouped by quarter desc if I can be that picky 2005 03 2005 02 2005 01 2004 04

Site Quarter Year Datafield1 datafield2 datafield3 101 1 2002 test20021 test20021 test20021 101 2 2002 test20022 test20022 test20022 101 3 2005 test20053 test20053 test20053 101 3 2004 test20043 test20043 test20043 101...

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 had that in the beginning and that didn't make much difference in eliminating the dups, but here is what I did that DID give me the results that I was after, just in case someone is interested for any future issues... select member.aalastnm, member.aafname, rx.labelname, --rx.labelname as...

ok, I've modified this a little bit to put the subquery in the ON clause instead. Does this not makes sense to do? select member.AALASTNM, member.aafname, rtrim(ltrim(rx.labelname)) as [memberrx], --rx.labelname as [Current Medication], min(dispdate) as earliest_date, deamap.ppfname as...