Search results for query: *

Sorry...I wasn't even thinking about the version having any real bearing on this problem...but you are right, I guess it could. I am working with version 9. Good point Madawc, thank you! Antiskeptic

I know I've seen this formula before...but I can't for the life of me remember it. *argh* I have a field that displays a number 40.5...I need it to display in hours and minutes...like this - 40:30 Anybody got any ideas? Sincerely, Antiskeptic

...I wanted. I'm so excited to have learned something new...though since it is a CURSOR, it's not some thing I intend on using much if any ever again. *ha* But to get this project done...it was worth it. My only problem now comes with my Crystal report. I ran this whole procedure with a...

...Thanks for pointing it out. Anything else? Anybody? I don't have a clue why it would be skipping people...but when I call up the Select * from #allcounts...I get people with PTO records (4 in a row for a couple of them) yet it does not make it through the CURSOR. I'm baffled! Brenda

oh, I commented out the and ptocnt<3 just to see if it would make a differnce, but it did not, and I forgot to uncomment before posting this... ~Brenda

...actualtime, convert(varchar(5), dateadd(mi, round((((process_raw.stop_time-process_raw.start_time)/60.0) * 60.0),2), 0), 8) ActualTimeHours, convert(datetime,(dateadd(day,process_raw.item_date,'1/1/1930'))) Item_Date...

This definitely looks like enough to get me started...and You don't know how much I appreciate your help! Thank you so much for your time, and I will let you know how it comes out. Just wanted to let you know right away how wonderful you are for giving this a shot. :-) THank you and you'll be...

okay I'll check back on Monday?

I have no choice...I have no other way of doing this...are you telling me that no one out there knows how to wrote a cursor...anybody, please help! I'm frightened!

I have never written a cursor from scratch...so I'm completely befuddled as to where to start, can anyone help me? I started this thread a couple days ago looking for a solution...and realized, and was told, that a LOOP or Cursor would be my only option...so here goes... I am working on a...

Don't know why I'm getting this error...very bizarre! I'm using CR 9.0 and I have a very simple report that works just fine until I go to put the parameters into effect in the Record selection My record selection statement looks like this: {rsp_RMS_ReconciliationReport;1.entry_date} >= {?From...

...know someplace to read up on it. I've already found something...so I think I'm on the right track. Thank you everyone for your help, and if anyone knows how to do a cursor...please chime in. I'm reading up, but still not sure if I'm on the right track. *haha* thank you, thank you, Antiskeptic

...SQL guys around here say the same as you, that a cursor would be my best bet. But none of them know how either. We are a pathetic lot, we are. *ha* I found some code online that might help, but I could use any resource you might happen to know of. I'm having to learn something new to get...

Okay..., maybe I just don't really get how this works. I'm getting GrpFld numbers of 999 or 345. Not exactly what I was looking for, so I'm wondering how this is supposed to be working. What number should be updating into the GrpFld? and would my theory of the Looping count work? Sincerely...

Donutman... we did it again...*ha* I will give this a shot and see where it puts me. :-) Thank you so much for your input so far. Thank you, Antiskeptic

that's okay...thank you for the attempt anyway. *ha* I wasn't sure I was understanding it...so I'm glad you wrote back .*haha* Any way to do this other than ASP? To all, My theory is this could be done with a loop. I just need to figure out how to assign the fields needing to be counted to...

Donutman... You must have responded as I was writing my last reply... did I answer your question at all, or do you still need more explaination? And you are correct about the holidays...if it's a holiday or they simply didn't have a timecode for that day then it just does not come into play...

actually anyday that is skipped is needing to be taken into consideration. I was just using a weekend as an example... ...so if I have: 8/3/04 PTO 8/5/04 PTO 8/7/04 PTO 8/10/04 WT 8/11/04 WT 8/13/04 WT 8/14/04 WT Or 8/3/04 PTO 8/4/04 PTO 8/5/04 PTO 8/6/04 WT 8/7/04 WT...

I am using SQL Server 2000. I am creating a stored procedure of which the output will be used in a Crystal report. But I need help getting the output right. I am making a payroll audit report to see how many consecutive days are taken off during a pay period. I have tried several different...

well, I tried yours vongrunt...but it's just running, and running...it's been running for over 10 minutes with no output. So I don't think that's it either this is what I used exactly...did I do something wrong? select A.[User],A.[Permissions],A.FolderPath from PermissionsByBaseFolder A left...