Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Veejc
  • Order by date
  1. Veejc

    Cognos 8 & Siteminder

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

    Help to Optimize this query

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

    Sum function and distinct values

    ...112), 5,2)+ '/' +right(convert( varchar,rx_all.Dispdate, 112), 2) + '/' + left(convert( varchar,rx_all.Dispdate, 112), 4), cur.unique_id,/* this is the unique indicator*/ rx_all.dayssupply, case rx_all.otc when 'F' then 'N' when 'O' then 'Y' end as supply , sum(rx_all.ingcost) as...
  4. Veejc

    version 9 tables -can they be used with version 8 code w/out problems?

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

    VFP cannot start. Could not load resources.

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

    ANSI 834

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

    File not found; calling DTS from SP

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

    File not found; calling DTS from SP

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

    File not found; calling DTS from SP

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

    Knowledge for a Senior Level developer

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

    Knowledge for a Senior Level developer

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

    outer join

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

    outer join

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

    outer join

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

    Generating the "last 4 quarters"

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

    Generating the "last 4 quarters"

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

    Generating the "last 4 quarters"

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

    Generating the "last 4 quarters"

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

    self join question

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

    self join question

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

Part and Inventory Search

Back
Top