Search results for query: *

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

Thanks George, that worked perfectly

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

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

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

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

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