Search results for query: *

At quick glance it looks like it works with my test..I will test on the real database and let you know. Thanks again!

So out of my insert and your insert above the desired results should be: '2011-02-23 00:00:00.000' '22803668' 2 3 '2011-02-24 00:00:00.000' '22803789' 5 13 '2011-02-24 00:00:00.000' '22803668' 2 14 '2011-02-24 00:00:00.000' '22803668' 2 13 '2011-02-24 00:00:00.000' '22803668' 5 3 Thanks again.

You might add this too so you can get the date check too..and another case too. insert into list values ('2011-02-23 00:00:00.000','22803668',5,3) insert into list values ('2011-02-23 00:00:00.000','22803668',2,3) insert into list values ('2011-02-24 00:00:00.000','22803789',5,13)

Only thing now is it only pulls the error_type 2 for my test case when on one page it doesnt have an errortype 2 so I would want it to show. So with the data below, it should pull the page 3 error and the error 2 type errors for page 13 and 14 only. So 3 total rows in the results There will...

Casenumber is unique.

Rows.. Here is random example. Date casenumber error page 2011-02-18 00:00:00.000 0000045404 1 12 2011-02-18 00:00:00.000 0000045404 1 12 2011-02-18 00:00:00.000 0000045404 1 12 2011-02-21 00:00:00.000 22820767 3 3 2011-02-21 00:00:00.000 0000062666 3 1 2011-02-21...

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

That worked..All i needed was your getdate expression, since my original column is datetime already too.. Thanks again!

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

Got it to work. I took that logic but had to turn this year({@Hire Date}) = year(currentdate) - 1 into this: year({@Hire Date}) <> year(currentdate) to exclude this years new hires...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..

Couldn't you also just do:? convert(varchar,p.expenditure_ending_date,101) between 2010-06-10' AND '2010-06-11'

Beautiful! It worked! 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...

Sorry figured it out.. if isnull(field) then 0 else (field)

Version XI

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

Awesome, Thanks!

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