Viewing 15 posts - 1,501 through 1,515 (of 1,553 total)
I'm probably not getting the point here, but..
Why the loop-thingy at all?
Seems unnecessary to me - just get what you're after within the given daterange - at least that what...
April 16, 2004 at 5:30 am
No solution, just some questions as how this new approach is
supposed to work in reality.
After all, that's what you have to model.
If a ticket is...
April 16, 2004 at 4:45 am
Only thing is it's legacy syntax, and not recommended to use (if possible)
If you're in a situation where you can choose, never use *= or =*syntax for outer joins.
Use the...
February 11, 2004 at 12:54 am
No real answer to your question, but...
why do you create the db first and then do the shuffling around?
There's no need for that at all. Just find out where to...
February 11, 2004 at 12:48 am
No, yes and no.
Issue 1 - No, you can't output like you want in any easy manner.
When a batch is run in QA (like exec myProc), results will be returned...
February 11, 2004 at 12:40 am
Short answer (imho of course) is No.
It's not appropriate to circumvent triggers by disabling / enabling them.
Having said that, I'm sure that there may be some circumstance that would warrant...
February 11, 2004 at 12:30 am
Well, I'm by no means any replication guru, so I guess that you could.
After all, all things are run through stored procs anyway.
Questions is more why you want to meddle...
February 10, 2004 at 2:47 am
Just be aware that often when applying a function on a column,
the same behaviour as using a cursor happens.
The effect may be that performance becomes abysmal for the query.
If...
February 10, 2004 at 2:37 am
There is however no such thing as a 'replication service', so I'm not really sure as to what the question really is..?
/Kenneth
February 10, 2004 at 2:25 am
The most efficient method is to implement a 'last changed' column in the load table.
However, it's very likely that this also forces the mechanism that modifies the loadtable to be...
February 9, 2004 at 8:29 am
AFAIK, there's no easy answer to this. It may depend on what kind of replication you're running,
why you want to stop it (not something you would normally want to do)...
February 9, 2004 at 8:24 am
Looks like something a codegenerator would barf out... =;o)
I would do it along theses lines....
Find out exactly what the purpose of this query is.
Rip it apart piece by piece and...
February 9, 2004 at 8:05 am
A couple of things....
Firstly, you most likely don't want @unitweight to be of type real.
I'd guess that a numeric(n,2) would do the job for you. Real is an imprecise datatype,...
February 9, 2004 at 8:00 am
Viewing 15 posts - 1,501 through 1,515 (of 1,553 total)