Viewing 15 posts - 12,826 through 12,840 (of 15,381 total)
If they do not have to be sent instantly I would recommend the approach of using an audit table and scheduling a job to do this at some regular interval.
If...
March 8, 2012 at 7:28 am
Nice back to basics question. Keep them coming!!!
March 8, 2012 at 7:15 am
Need a little more clarification on what you are trying to do but in general your approach to this trigger is not going to work well. In your code you...
March 7, 2012 at 3:08 pm
How about some ddl and sample data to work with?
March 7, 2012 at 12:24 pm
DBA_SQL (3/7/2012)
I am still not so clear with your explanation. Can you please, explain which statement executes first in a step by step method. Thank you
Lowell did a good...
March 7, 2012 at 12:19 pm
There is no magic formula for this. You have to figure out what is the most appropriate for you situation.
Read up on it here. http://msdn.microsoft.com/en-us/library/ms190787.aspx
March 7, 2012 at 12:12 pm
This sounds like a classic "catch all query". Read Gail's blog about here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
March 7, 2012 at 12:03 pm
Eugene Elutin (3/7/2012)
Sean Lange (3/7/2012)
Eugene Elutin (3/7/2012)
You will need to drop your table before doing so.
The next option is...
March 7, 2012 at 8:46 am
Eugene Elutin (3/7/2012)
You will need to drop your table before doing so.
The next option is to batch your insert....
March 7, 2012 at 8:17 am
SKYBVI (3/7/2012)
I dont think DDL is needed and sample data i already put..Leave the question if u can't help.
It's not that we can't help. It's that you can't help us...
March 7, 2012 at 7:41 am
Evil Kraig F (3/6/2012)
SQLRNNR (3/6/2012)
jcrawf02 (3/6/2012)
Evil Kraig F (3/6/2012)
And a week of troubleshooting later I'm back.Problem 2... I LIKE IE. *shrugs* It does what I need... usually.
So does...
March 6, 2012 at 2:42 pm
It is pretty hard to determine why that is. It could be one or more of the joins is returning a cartesian. There are a number of reasons that could...
March 6, 2012 at 2:18 pm
siva 20997 (3/6/2012)
March 6, 2012 at 2:13 pm
Well I got this working, but it looks like the data isn't correct [Sad]
the first 1000 rows are all the same...
Any ideas?
Here is the view, same as yours Jared, just...
March 6, 2012 at 1:58 pm
You know with over 1,100 points you should know how to post a question. ddl, sample data, desired output.
Take a look at the first link in my signature.
March 6, 2012 at 1:52 pm
Viewing 15 posts - 12,826 through 12,840 (of 15,381 total)