Search results for query: *

I have a table with 1.date 2.casenumber 3.errortype 4.pagenumber columns I want to pull all records in the table . but, if an error_type of '2' is present for a pagenumber/case_number on the same day that there are other error types for that page, I only want to pull the error type 2 log...

Im trying to get all records that are >= (previous day at noon) This would seem easy but not so much for me..... Our dates are stored like '1995-01-01 00:00:00.000' The time is in military units.(0-24) Any ideas? Thanks again..

I have this right now.. year({@Hire Date}) = year(currentdate) - 1 and month({@Hire Date}) = month(currentdate) Which originally everyone wanted, now they want the same exact thing but instead of just last year, I want it to take in all previous years... Basically, every month this report...

Wanted to get some ideas for good books or sites that I could get to learn StoredProc/Temp Tables/Variables/MyCursor ...Stuff similar to that... Sql Server 2005-2008.. I've been learning sql for a few months now and I think I'm ready to jump into those.. Thanks again..

I have a hire date in this format (mm/dd/yyyy)..the report will run the 1st day of every month and I want to capture all records that are within the same month, 1 year ago for th whole month... For example, if it 07/01/2010, I want the report to capture all records with a hire date of...

In crystal, if i have a column that includes nulls and numbers..How can I make the Nulls show up as 0 and the other fields show up as what they are? Thanks again..

I have this in my suppress section: {Command.ProviderID}<> previous({Command.ProviderID}) and {Command.ProviderID}<> next({Command.ProviderID}) And want to add except on first record and last record.. Is this possible? Im basically wanting to hide any records where the providerid used is the...

Is there a way to use this below top part, but not use any of the fields in the group by other than:a.Zip,a.clientid,a.state,a.agent? By adding the other fields in the group by, it is messing up the results. But since those fields are in my case statements, it makes me use them in the group by...

Right now I'm getting the sum of unused hours for a time period.. I am wanting to change it to where I get a sum of unused hours for that time period if it is in the future.. If today is the first day of the itineray or somewhere in the middle of it, then I want unused hours from tomorrow-the...

I have this:: ;with Monster as (select a.caseno,a.applid, a.applname, s.clientname,a.clientid, a.serial, (a.status +'/'+ a.statusreason) as Status, b.Appt_DateTime as Rescheduled, b.providerid as currentprovider,c.fudate from vwapp0 a with(nolock) inner join vwaccount s on s.clientid=a.clientid...

I have this in my select expert: (({?Members} = 'Yes' and {command.members} > 0) or ({?Members} = 'No' and isnull({command.members}))) The parameter only has a choice of Yes or No to the User..Yes being members with 1+ in the field.No being members with a null value.. My problem is when you...

I want the parameter to show Yes or No to the User.. "Yes" would be if a number field in the report would be any number greater than 0. "No" would be if that number is 0. How is this done? Thanks again.

When I have a dynamic parameter in a report and try to save the report to Business Objects/InfoView I get this: Error with Business Objects Enterprise Failed to read data from report file "my file location" Reason:failed to read parameter object. Any ideas? When I ask anyone here, they just...

The below pulls everything I need except one field that I get errors when I try to add it. I'm needing c.notes. I get this error right now; Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Sql...

I basically have two tables I'm trying to match up and then sum from one... Table 1: tproviderschedule (basically looks like this)It is a log for peoples travel schedules..Can be a range of dates or just one date.. Name ID travelstartdate travelenddate etc...

Why will this not pull back all of the max serial rows I'm needing for the notes field? It does it correctly for about 90% of the records? Any other ideas for getting max record pulled for a notes(text) field? The max record row for the notes field will also have text in it everytime never...

Below is two sql statements separated by the line. They need to join on a.clientid=a.clientid and a.serial=a.serial and bring in the dttime field from the second sql statement and display all from the first..Any ideas. I'm in need of a sql answer. I've tried doing it in crystal where the end...

If I have this below. How can I have it return dates where no activity happened so it will return zero values and I can pivot it and have all dates on top with counts below it? Right now it pulls all the dates for what I'm asking. The tables do not have all date stamps in them, so this would be...

The field "d.dttime" is coming back null and it should have a date. Any ideas why it's not working? Sql Server 2005 Management Studio Express select b.clientname,a.agency, a.applid,a.caseno,d.dttime,a.applname, a.status, a.statusreason,'During Scheduling' as SchedulingProcess from vwapp0 a...

If I want to just add a column to the output of this report to say "during scheduling" for every value, basically so I can pivot off this field later, how would you do it? All I can find is alter table and add column ref. but that is not really what I'm trying to do I don't think.. select...