Viewing 15 posts - 571 through 585 (of 621 total)
Matt Miller (10/18/2007)
I think you need to try the solution I posted. The reverse engineering you did has some logic flaws. In particular - you're going to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 18, 2007 at 8:58 am
Jeff Moden (10/18/2007)
Kenneth Wilhelmsson (10/18/2007)
I've found that date tables are fine for RBAR... but, how would you use the date table in this instance of batch code and still have...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 18, 2007 at 8:36 am
Kenneth, I probably should refer to it as weekdays, but as far as my production is concerned no weekends are work days. I may end up having to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 18, 2007 at 6:11 am
False alarm. There is still something wrong with saturdays.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 7:36 pm
Ok, I think I fixed it. I forgot one thing from Jeffs function, then I just fiddled with the numbers until it seemed to work.
IF OBJECT_ID('dbo.fnAddWorkdays','fn') IS NOT NULL
DROP...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 7:32 pm
Well...it seems to have some problems. If I start on a week day I should always end on a week day, but my function does not seem to do...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 6:56 pm
Ok, I figured it out. I knew it had to be a reverse of Jeff's code, which can be found at
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/.
And it was. I had to read the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 6:18 pm
vadimt (10/17/2007)
Greg Snidow (10/17/2007)
"Tally": what doest it mean? i'm selecting a string, so why FROM is required?
"N": can i just write it like that? without declaring it anywhere?
I am so...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 5:43 pm
Thanks Daryl. I want to do it without having to make a days table. I know there is a way, I just can't get my head around it
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 5:23 pm
This ought to work. Jeff Moden helped me with a couple of these, and I think this is one of them, but I can not remember exactly, but it...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2007 at 2:32 pm
[/quote]
Every time record is created trigger copies required data to EmailOut and set "delivery date" to 5 days from now.
Every time record has got updated with proper customer response trigger...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 8:44 pm
Still not much to go on. Maybe you could post your table structure and some sample data to work with. Are you tracking which object the data came...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 12:57 pm
You can also open Enterprise Manager, expand the console root to your database, then expand the objects in your database. If you expand the tables, for example, then right...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 12:38 pm
Chris, If you search in the above search box for 'audit table' you will see more solutions than you can shake a stick at. I can tell you one...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 12:06 pm
Roberto, I am unclear on what you are trying to do. How are you calling the procedure? Your procedure selects, but not from another table. Are you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 16, 2007 at 11:55 am
Viewing 15 posts - 571 through 585 (of 621 total)