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: *

  1. mtepfer

    Update Random Integer Column

    Never mind figured it out needed to have set statement as follows : set @lottery = table column a = @lottery + 1
  2. mtepfer

    Update Random Integer Column

    Have a table with column that contains random integers. Need to reassign a portion of these integers based on certain criteria. I want to start from s specific number then increase the counter by one. Am working with something like this but when I try to increase the counter it will not allow...
  3. mtepfer

    Update Statement needed

    Have one table with vendor information in it. The vendor may be in this table duplicate times, their fed id number is the same but their index is different. Want to update the index to the lower index number when the fed id number matches. Example : FED ID VendID 123-45-6789 8939...
  4. mtepfer

    Displaying Names in Cross Tab report

    Never mind on this, figured it out, basically was an error with my view on the sql side that was not allowing the name to display.
  5. mtepfer

    Displaying Names in Cross Tab report

    Am using CRXI. Have a database in Sql 2008 , have 2 tables, The first table (Data) has a column for counselors - this column is an integer that ties back to our user table where the actual name is stored. Example in the Data table counselor = 2. In the User table then 2 is the PK with a column...
  6. mtepfer

    Percentage in Cross Tab

    Thanks lbass did figure that out after messing around with it last night. Thanks for your insight.
  7. mtepfer

    Percentage in Cross Tab

    lbass, thanks for the info looks like it is working perfect except for one thing, the last 2 columns(Total and Percent) are not showing the totals and percentages per row (auditor). Sure it is something simple I am missing. Fail Pass Passwcom Total Percent Anita 4 6...
  8. mtepfer

    Percentage in Cross Tab

    Have a cross tab report that shows auditor names in the rows and results in the columns. The results are in 3 categories (Fail, Pass, Pass w/comments). These then total per auditor. I need to find the percentage passed (passed includes passed w/comments). I can create the formula to do all of...
  9. mtepfer

    Help with a Group Selection

    Never mind got it, read that the sum function cond does not work except for date, time and boolean, but was able toget the desired results using the following command : If {?Inc1} = "Child Support" then (({Command.TotalEarnedIncome}) <= Sum ({Command.dIncome6e7d},{Command.sIncCode7b}) and...
  10. mtepfer

    Help with a Group Selection

    There is a field for Total Income and then a detail field for the Amount based on the income code, i am trying to get it to select those groups base on the sum of the detail for 'C' if it equals the total. Here is what i am trying to do but am getting a "group condition is not allowed" error on...
  11. mtepfer

    Help with a Group Selection

    Am using Crystal XI, Have a group on a clientid, within that client am listing different sources of income for them, could have zero to multiple codes and also duplicate codes. Want to display based on one code, in this instance "c" but also only display if this is the only amount. I am able...
  12. mtepfer

    Help Combining 2 Queries

    Need some assistance on how to proceed with this, have looked at it so long have confused myself by now. Have a query that returns me payments on hold. The query looks like this : SELECT p.scode Property, t.scode TenCode, rtrim(t.slastname) + ', ' + rtrim(t.sfirstname) TenName...
  13. mtepfer

    Selecting Top Record

    Thanks Alex, exactly what i needed. Sorry about the wrong forum, thought i had clicked programming, need to proof better before posting.
  14. mtepfer

    Selecting Top Record

    can have numerous inspection dates per client, want to select the top record from each client and display. For instance may have : ClientNo Name Type Date 1 Smith annual 2/1/08 1 Smith annual 2/1/07 1 Smith Initial 2/1/06 2 Doe Annual...
  15. mtepfer

    Counting in a subquery

    Thanks George, that worked perfectly
  16. mtepfer

    Counting in a subquery

    Have 2 queries I am trying to join together. I used the second one as a subquery in the first but am not getting the results I need. Not sure how to get it to segregate based on proeprty since you can't use Group By in the subquery with more than one item returned. The Output from the Queries...
  17. mtepfer

    Pass a Javscript Function

    Scripting is not my thing but am trying to write one, have got it so it will log into our application and now i need to select a menuset, just have no idea where to begin on that. Any help is appreciated. My login script looks like this : Set IE = CreateObject("InternetExplorer.Application")...
  18. mtepfer

    Column Update from Another table

    Thanks for the idea, just wrote a trigger and so far seems to be working fine. USE [yardi_test] GO /****** Object: Trigger [dbo].[Insert_Client] Script Date: 11/06/2007 15:34:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= --...
  19. mtepfer

    Column Update from Another table

    TheSQL, This would be an event triggered update. Table A is a form table that has a form created at minimum once a year for each person(Table B), could be multiple forms in the year, but each time the form is created and the record entered into this table I want that field to look for the client...
  20. mtepfer

    Column Update from Another table

    Have a column in Table A, want that column to be set to the value in another column that resides in Table B. Example : Table A.user_Field = Table B.Client_Num They would be related on a primary/foreign key Table A.HTenant(FK) = Table B.hmyperson (PK) What is the best way to go about this? A...

Part and Inventory Search

Back
Top