Viewing 15 posts - 1 through 15 (of 34 total)
Thanks for all your help. I'll try to make one of these options work in my context.
October 9, 2005 at 7:33 pm
Your solution works great to meet the first criteria (regarding day-of-week), but when I try to use the following construct to check for the holiday schedule, I fail to get...
October 6, 2005 at 8:29 pm
Thanks for the help.
No, I wasn't thinking about a cursor. I was, however, thinking about a WHILE... BEGIN statement to move the date forward one day at a time until...
October 6, 2005 at 5:22 pm
Don't take offense. I am impressed with your solution, and I like the abililty to look at all the tables in a database. At the same time, that doesn't work...
September 21, 2005 at 12:24 pm
Here's another way (credit goes to Mike H., friend of mine and a Microsoft Valued Professional in the SQL world), and this gives me the results in original...
September 21, 2005 at 11:58 am
Wow! This is great! Thanks.
The prior post was close, but even after making some adjustments I ended up with NULLs in the ActDataLength column for ALL columns.
But THIS one really...
September 21, 2005 at 11:39 am
Unfortunately, I don't write or have immediate access to writing in VB code, so I'm stuck doing this in T-SQL. I've changed my code (see below) to dynamic...
September 21, 2005 at 9:58 am
Yep, you're right! I just discovered that.
How do I fix it???
September 21, 2005 at 9:33 am
Well, it may be crude, but I wrote the following and it works:
/******************************************************************************
This script will fetch the ACTUAL MAX DATA LENGTH of data resident
columns of the...
September 21, 2005 at 9:16 am
I think I found the problem. TranCount is an Integer data type. Therefore, the division always produced a zero result because the value was a fraction less than zero, but...
June 29, 2005 at 12:59 pm
I wish I could take credit for this script, but I can't. It was done by a friend and business associate of mine. He created it and uses it to track...
March 16, 2004 at 10:59 am
Yes SPIDs are blocking other SPIDs...when I have to fix the problem I have to run sp_who and trace back the Process ID numbers till I find one that's...
March 12, 2004 at 7:05 am
Hmmmmmmmm...
Your request to have me post the desired result set led me to think through additional factors. I think I may have figured out how to get where I want...
March 9, 2004 at 3:10 pm
Well, here goes. See if this will get what you need:
CREATE TABLE [tsoDSVoucherCOGS_SSSI]
(
[POLineKey] [int] NOT NULL ,
[VoucherUnitCost] [decimal](15, 5) ,
[VoucherPostDate] [datetime] ,
[VoucherTranDate] [datetime] ,
[VoucherTranID] [char] (25) ,
[VoucherQty] [decimal](15, 3) ,
[POExtCost]...
March 9, 2004 at 2:58 pm
Viewing 15 posts - 1 through 15 (of 34 total)