Search results for query: *

Let's say I have a table called d_gift. The table includes the following fields: d_giftkey, d_giftdate, d_gifttype and d_giftamount. A person can make multiple gift transactions which means the data would show vertically based on the number of transactions. Is there a way syntax wise to set...

I have a created field in Access called Birthdate(text)which is blank. I want to pulled 3 fields, birthm(text) birthd(text) and birthyr(text) into the created field called Birthdate. The display should read MMDDYYYY (ie 09112007). In the query section in Access, must I do an update query and...

Thank you both for your suggetion. It worked. Here is a diagram of what I did: GroupHeader1: Prospect Name Detail Line1: Leader name GroupFooter1: Campaign (displayed in a subreport) The only problem now is I cannot seem to get carraige returns to work. I suppressed where duplicated, I...

Using Crystal9 to create a report that requires a specific grouping. I want to display some data as follows: On detail Line A dbo.Prospect_name On Detail Line B dbo.Leader_name On detail Line C dbo.Campaign_Value Here is an example: John Smith (dbo.Prospect_name) Ed Smith...

Here is the SAS program I wrote to display a userid and the count of the userid: proc sql; create table address1 as select addruserid, count(addruserid) as addrCount from my.address where addrdate between '26-feb-2007'd and '31-mar-2007'd group by addruserid; run; Everything works okay except...

I am using crystal 8.5 (have access to cr 9 and 10). Here is a description of a report I am trying to do: Name Name Type John Smith preferred John L Smith formal Address Address Type 1313 S Street Miami Fl Preferred 125 T Street Washington Former...

Using MS SQL Server 2005, I want to display instances of data horizontally. For example if I choose select membid, membtype from membership where membid = '0001' I would get 0001 c2 (0001=membid, c2=membtype) 0001 c3 (0001=membid, c3=membtype) Is there a way to set up an sql statement to...

I have an sql table called GENERIC. It has a SORTNAME field. Here is an example of data SMITH/JOHN. It also has a NAME field. Here is an example Mr. John SMith. In my cross tab I have a formula, GENERIC+''+Name. This is the only way I know how to alphabetize the name. As we know the...

In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...

In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...

My apologies MrBill. Okay here is the scene. I am pulling school information from the field schoollookup. if a person has multiple degrees, they will appear vertically such as schoollook = 1 1995 BS Engineering schoollook = 2 2004 MBA Business Admin So when I pull this into crystal I want to...

Is there any way to display multiple lines of data (which display vertically by default) in a horizontal or side by side way on a crystal side. I tried doing this on the front end or in the sql table that crystal pulls data into but that does not work. For example if a person has 1 degree a...

Here is my situation. I have a script select schoollookup, degree, schoolname from school left outer join degrees degr where degr.table_code=degree Output: If a person has 2 degrees, the first degree will be schoollookup 1 and the second will be schoollookup2. They will display veritically...

I have a report that creates a work table as follows proc sql; create table address as select addrdate,addruserid from d.address where addrdate >= '05-feb-2007'd order by addruserid; quit; 1. Is there a way to have SAS run this report automatically at 4:00PM each day everyday and put it in the...

sql denis The code worked. It put a 0 in front of the month. However the result was the number 02. The person's birth month was supposed to be 07. It did the same for the day. Maybe if I could get an explanation of the code that might help me ie right(replicate '0',2) does this mean put a...

BirthD is actually a datetime data type. I am trying to take BirthD and segment it into brthyr, brthdy and brthmn which are char datatypes. So it appears that the latest script you gave me needs to convert BirthD from datetime to char so it can be used in the three char datatypes. When I...

sql Bill thanks for your insight. One more question. The update script with the trigger works. The only issue is that if the brthmn or brthdy is less that 10, the number comes over as a sigle digit number without the 0 (ie I want 7 to come over as 07) any ideas

I have the following update query in SQL update dbo.core set birthyr = Year(BirthD), brthmn = Month(BirthD), brthdy = Day(BirthD) Now my boss wants me to turn off triggers while this update query is excecuting then turn it back on. I have not used triggers prevously but I...

Here is my situation: I use an sql table called userlist. I bring the table into MS Access and create a make_table everyday and it is done manually. Does anyone know a way to automatically invoke either sql enterprise manager or ms access thorugh a macro to automatically produce a simple...

I ran a query to show an id and birthday as follows: select id,birthd,brthyr,brthmn,brthdy from dbo.core where id= '0000000' The results are id=00000000, birthd=1877-01-01, birthyr=null, brthmn=null and brthdy=null I want to take the birthd and populate it into the three null tables. Thus I...