Viewing 15 posts - 28,291 through 28,305 (of 39,771 total)
The data has to move, one way or the other. The thing you want to do is minimize things. So, is it less if the data moves to the report...
June 5, 2008 at 11:17 am
You don't need internal variables.
You might need to convert/cast to get to numerics and then do your math
select (cast(arrivetime as int)/60) 'Minutes'
June 5, 2008 at 11:05 am
Please don't repost full article text. It's a copyright violation. Link to it and quote if you'd like.
They are interesting articles.
June 5, 2008 at 11:03 am
Is there a question here?
Please read Books Online or research a little. There are lots of examples for triggers out there.
June 5, 2008 at 11:01 am
Replication deals with transactions. If there were an issue in the middle of the transaction, it would roll back. If it is committed, it's there.
June 5, 2008 at 11:01 am
Not that I know of. The CREATE PROCEDURE needs to be the first command in a batch. You could perhaps call this dynamically
declare @cmd1, @cmd2
select @cmd1='create procedure sql2k as sxxx'
select...
June 5, 2008 at 10:59 am
I like that one as well! It's entered in the XPrize.
June 5, 2008 at 10:27 am
Never seen that, but if they get around it, I can think of two things:
1. They have linkages between rows, so I know long procs sometimes have two rows in...
June 5, 2008 at 10:04 am
Copy and paste will move stray characters. You'd have to retype it.
If you run various sections alone, do they work? Can you run the IF only?
June 5, 2008 at 10:03 am
Do you know all the actions? Can you change that to an "IN" instead of a "NOT IN"
June 5, 2008 at 10:01 am
DO NOT use domain or local administrator. There is no need and no features are lost.
DO NOT use anything other than Enterprise Manager or SETUP to set the account to...
June 5, 2008 at 9:57 am
I think you want to say "I hope it is NOT confusing"
It's still unclear to people how you know it's a mobile number if it's in the home or work...
June 5, 2008 at 9:52 am
Hey I'm an economics major! I did have 2 years towards a masters in Computer engineering and my first two years of college were CS, but that doesn't appear on...
June 5, 2008 at 9:44 am
Hey, nuclear powered diggers!
That's a good point, and all the extra work that goes into building a nuclear plant as well affects carbon emmissions.
But nuclear runs a long time, and...
June 5, 2008 at 9:41 am
Viewing 15 posts - 28,291 through 28,305 (of 39,771 total)