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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.