Recent content by Veejc

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