Viewing 15 posts - 56,911 through 56,925 (of 59,067 total)
My 2 cents... IDENTITY column on table "A" with trigger on table "A" that adds 1 to that column to store in table "B". Then, kill the person that designed...
February 14, 2007 at 11:26 am
Maybe I misread and, if so, sorry...
If CMRGDT is an integer, I don't think that WHERE CONVERT(DATETIME,CMRGDT) > GETDATE() - 2 is going to work without an extra conversion like...
February 14, 2007 at 9:42 am
I'm not sure, Lowell, but have you tried converting the DLL to an "extended stored procedure"? Books Online tells how...
February 14, 2007 at 9:32 am
Since I'm mostly a data troll, I don't know what language you are writing in, but I'll give it a shot even though this is Oracle... replace the "&" with...
February 14, 2007 at 9:30 am
As a side bar... if your trans_date has time in it... don't use BETWEEN because it will ignore most of the end date. For that same reason, you shouldn't use...
February 14, 2007 at 9:22 am
Just for grins... the following two items are functionally equivelent...
CASE
WHEN MONTH(ledger.trans_date) < 7 THEN MONTH(ledger.trans_date) + 6
WHEN MONTH(ledger.trans_date) > 6 THEN MONTH(ledger.trans_date) - 6
ELSE 13
END...
February 14, 2007 at 9:10 am
A slightly different take on David's 2 character solution...
REPLACE(CHAR((Number/27)%27+64)+CHAR(Number%27+64),'@','0')
Just remember that both of those 2 character solutions "lose their mind" at a decimal value of 730... David's starts producing special characters...
February 14, 2007 at 7:37 am
Heh... Thought I explained it just fine... Tim, the key for me was the value 1 being A, 26 being Z, and 52 being AZ... I should have said, "I don't think you want...
February 14, 2007 at 5:55 am
Ok... in the absence of a response about what the primary key might be...
First... no loops... think set based... loops just slow things down.
Second, I can only believe that you...
February 13, 2007 at 9:42 pm
Hey there John, I think you'll like this...
First, your numbering is a bit off... if 1 is "A", and 26 is "Z", and 52 is "AZ", then 53 MUST be...
February 13, 2007 at 9:04 pm
No matter which way you do it, we're going to need to know what the primary key for the table is.
February 13, 2007 at 7:35 pm
Guess I'll have to ask the obvious question... is either (or both) the SELECT and/or the INSERT wrapped in a BEGIN TRANSACTION/COMMIT pair?
February 13, 2007 at 7:24 pm
Is the ProfileID column an IDENTITY column or not?
February 13, 2007 at 7:20 pm
Why not have Informix do an export to, say, a comma or tab delimited file and then DTS that bad boy in?
February 12, 2007 at 8:29 pm
Anders is correct... the reason why you're getting the arithmetic overflow is because SQL Server looks at those types of numeric dates as the number of days since the 1st...
February 12, 2007 at 8:26 pm
Viewing 15 posts - 56,911 through 56,925 (of 59,067 total)