Recent content by luvmy2kids

Here is my complete SQL statement: create table #emaildata (intid int, fieldid int, extid int, employeeid int, socsecno varchar(11), firstname varchar(255), lastname varchar(255), checkdate datetime, units int, state varchar(50), billdesc varchar(255), name varchar(255)) insert into...

I have the below code: 'Week1' = case when checkdate = dateadd(wk,-4, '2009-9-04') then ISNULL(d.units,0) else 0 end, 'Week2' = case when checkdate = dateadd(wk,-3, '2009-9-04') then ISNULL(d.units,0) else 0 end, 'Week2' = case when checkdate = dateadd(wk,-2, '2009-9-04') then ISNULL(d.units,0)...

Thanks for the reference!

I am working on a report that I would like to capture totals going back 4 weeks? For instance, I can easily capture this week's total because I can write something like this: sum(isnull(e.AllTCHours, 0)) where weekending = '2009-8-29'... How can I get a sum going back for the entire month of...

I have the below code: select cd.custdeptname, costcenterdesc, weekend, 'Regular Hours' = SUM(case when t.paycodeid = 1 then ISNULL(t.units,0) else 0 end), 'Overtime 1' = SUM(case when t.paycodeid = 2 then ISNULL(t.units,0) else 0 end)--, t.paycodeid from prchecktc r inner join vw_tcdetailall...

I have to stored procedures that I am using to call a report: exec udsp_getcandidateinfobyid @candidateid = {?@candidateid} exec udsp_CandidatesSupplemental @candidateid = {?@candidateid} how can I get these to join so I won't have to type the parameter @candidateid twice....

Okay, I tried that I received an error. Maybe I had something typed incorrectly!

Please help me figure out the correct way to write the below code: Having SUM(ARAmount) <> 0 and Having SUM(v.InvCur) <> 0 and Having SUM(v.INV30) <>0 and Having SUM(v.INV60) and Having SUM(v.INV90) <> 0 Having and SUM(v.INV120) <> 0 Thanks!!

Got it~ nevermind!! Thanks!

I figured out the reason I am not getting any data is becuase the date of "weekending" is 8-23-2009 which is a Sunday. So what I need to do is just get the day of the week and based on that day, then do my subtraction from the weekending to get it to display the correct date? Any suggestions...

I have the below formual: If DayOfWeek({Command.weekending}) = 2 Then {Command.weekending}-6 I am trying to return a date of: 2009/8/17, but it returns nothing? weekending is a datetime field, does that matter? Please help!!

Okay! Thanks.

No I don't have a unique id field and that is what's causing the issue. I will try what DJWW suggested and see if that works. Thanks!

I have a situation where I have the main report data with the total amount, and I have a sub-report with monthly breakdown totals as follows: --Main Report 1451 CORAL RIDGE AVENUE CORALVILLE 52241 $15,347.09 2345 Saulsbury Rd Muscatine 52761 $10,000.00 2403 5th Ave SE CEDAR RAPIDS...

Thanks! I will try this.