Viewing 15 posts - 22,096 through 22,110 (of 26,490 total)
If trade_date is a datetime column, then collation is irrelevant, and the character constants will be converted to a datetime value before the comparison.
March 9, 2009 at 10:29 am
Okay, you showed us the how you are trying to accomplish your task, but how about showing us what you are trying to accomplish with some sample data, like '123'...
March 9, 2009 at 10:27 am
I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread. I tend to inform those individuals that I...
March 9, 2009 at 10:21 am
I always thought that in a clustered environment both nodes needed to be the same? If one node is 64-bit, the second (and additional) node(s) needed to be as...
March 9, 2009 at 9:55 am
Okay, I have to ask, what are you trying to accomplish with this trigger?
March 9, 2009 at 9:44 am
You know what would really help, show us what you are trying to accomplish with sample data. Right now we are all just guessing at what you are trying...
March 9, 2009 at 9:31 am
I'll forward this Thread to our PeopleSoft Admin. All I do is restore the production databases, she takes care of evrything else.
March 9, 2009 at 9:19 am
GSquared (3/9/2009)
Can you multiply the first one by the...
March 9, 2009 at 9:14 am
A Little Help Please (3/9/2009)
I have restored a SQL 2000 DB on to a new SQL 2005 DB.
When I run:
select top 100 * from tbldeals
order by trade_date...
March 9, 2009 at 9:06 am
You have to wonder what people are being taught when you see code like this:
ALTER TRIGGER [dbo].[tr_insert]
ON [dbo].[table1]
AFTER INSERT
AS
BEGIN
...
March 9, 2009 at 9:03 am
GilaMonster (3/8/2009)
Bob Hovious (3/8/2009)
Gail, do they have the "Inspector Gadget" cartoon over there? I find that tune flushes everything else out.
I've seen it, long, long ago. Can't...
March 8, 2009 at 1:19 pm
Bob Hovious (3/8/2009)
Surely there is only one man that can help him.
Noooo, please don't say it!
March 8, 2009 at 11:12 am
I would not call it competition, I'd call it having a partner. Who says there can be only one Saint in the forum?
March 7, 2009 at 5:35 pm
CTE (3/7/2009)
When the hell I said My query is BEST? stop imagining. Get life.
Now I'll talk in the language you will understand.
Enough of...
March 7, 2009 at 8:27 am
He may have agreed that Bob's solution was better, but he also kept trying to defend his solution as it was something he came up with. A lot of...
March 7, 2009 at 8:18 am
Viewing 15 posts - 22,096 through 22,110 (of 26,490 total)