Viewing 15 posts - 57,346 through 57,360 (of 59,070 total)
Sorry, Remi... that wasn't directed at you... I got so ticked
at the mere suggestion that such a simple data manipulation be done...
October 24, 2006 at 7:49 am
Ok... I know... "put up or shut up, Jeff"... fine
Let's see you do it any simpler in an app
October 24, 2006 at 7:20 am
I try to use my memory... but I forget... ![]()
October 24, 2006 at 6:08 am
Serqiy... You really that old ? ![]()
October 23, 2006 at 11:35 pm
Commando...
First, I gotta share the normal diatribe about your numeric sequence and forgive me while I blast the designer... if you were the designer, sorry, but not sorry...
October 23, 2006 at 11:18 pm
No sure what the "Number" parameter in Sybase is but...
There a multiple functions in SQL Server that return info about the current connection... for example... @@SPID returns the SPID of...
October 23, 2006 at 6:56 am
create an updateable passthrough view in each target database
I don't see where you said those words, but may that's what you meant... I was talking about just creating...
October 23, 2006 at 6:28 am
Yep... I missed that one... guess it's time for some sleep ![]()
October 22, 2006 at 8:15 pm
Doesn't seem to be "automatically scalable" unless you create the views and the trigger dynamically. Maybe that doesn't matter much... non-dynamic solutions do require some human intervention but they usually run better...
October 22, 2006 at 8:12 pm
i had intended using a dynamically constructed sql string - but it failed everytime. i was... |
October 22, 2006 at 7:43 pm
Use the other form of case...
, SUM( CASE WHEN r.packagetransmethodid NOT IN (1,2,3,4,5,6,7,8,9) THEN ShipmentQty ELSE 0 END) as "Others"
October 22, 2006 at 1:54 pm
I've just got to start selling the "T"-Shirts that say...
SELECT *
FROM Users
WHERE Clue > 0
(0 row(s) affected)
Jono,
You should probably be a bit disgusted with...
October 22, 2006 at 9:33 am
Viewing 15 posts - 57,346 through 57,360 (of 59,070 total)