Viewing 15 posts - 3,286 through 3,300 (of 7,429 total)
Or SP3 if you can go there. But I am not sure where PeopleSoft support level is at.
February 28, 2003 at 3:13 pm
Actually instead of spounting off a query can you give me what your actual base query is and how the tables relate and what you want to accomplish. I just...
February 28, 2003 at 8:07 am
SELECT CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END
as 'Example',
CAST(title AS varchar(25)) AS...
February 28, 2003 at 6:17 am
Speaking of decoy code. You could easily write several SPs that do basic tasks like INSERTS, UPDATES, DELETES, and SELECTS on small tables and even on large tables pulling a...
February 28, 2003 at 4:04 am
Take a look at the execution plan and see if it is even using the Clustered index on Field1. I don't think it will because the index only has 3...
February 28, 2003 at 3:51 am
quote:
Sure is amazing what cut/paste can accomplish and the trouble it can cause. This might be kind of like clicking yes to...
February 27, 2003 at 3:13 pm
Oooooh, aaaaaw.
Cool, hadn't thought of that before.
February 27, 2003 at 12:39 pm
Ah, I was thinking rows not columns. Never split a table on columns unless you cannot fit it in 8K wide (not counting text).
February 27, 2003 at 12:38 pm
Same here, copy and paste.
Just didn't catch it as was busy with something else at the same time.
February 27, 2003 at 12:33 pm
Have you tried
SELECT @@version
it should output the version number and I thought the type as far as Standard, Enterprise, etc.
February 27, 2003 at 12:31 pm
So really your issue is datatyping problems. I believ your other server may be implicitly converting the int to varchar but the server in question isn't so it gives the...
February 27, 2003 at 5:57 am
IsNull and COALSCE are te same except for the number of options supported.
February 27, 2003 at 5:31 am
quote:
I'm a bit hazy on the hole firewall/port thing but web servers listens on port 80 for HTTP and 443 for HTTPS....
February 27, 2003 at 5:28 am
Also, to keep speed up if you have time to allow for, drop your indexes then add back after done, plus disable Triggers and Constraints on TableA if TableB will...
February 27, 2003 at 5:20 am
However, the query engine makes some odd decisions sometimes.
Might try a subquery for Table1 thus forcing the query to handle the WHERE condition for the subquery first before the...
February 27, 2003 at 5:17 am
Viewing 15 posts - 3,286 through 3,300 (of 7,429 total)