Viewing 15 posts - 4,876 through 4,890 (of 6,036 total)
I hope that table has Primary Key.
If no, create it.
Than create dummy table referencing this table with FK. Truncate will not work then.
October 24, 2006 at 3:12 pm
Find school hanbook on Math and read the chapter about interpolation.
October 24, 2006 at 4:57 am
Who knows...
At my age people cannot rely on their memory... ![]()
October 24, 2006 at 4:54 am
update L
set [values] = 0
from Lookup as L
left join source...
October 23, 2006 at 6:31 pm
Did you manage to compare execution plans?
October 23, 2006 at 4:38 pm
I see difference in 2 places:
1) second option uses implicit INNER JOIN, not CROSS JOIN as first one;
2) compare these:
(f.receivedate BETWEEN DATEADD(dd,-10,f.receiveDate) and f.receivedate)
and
g.receivedate BETWEEN DATEADD(dd,-10,f.receiveDate) and f.receivedate
October 23, 2006 at 3:42 pm
You are using wrong name.
It must be master.dbo.xp_smtp_sendmail
And you need probably visit this site:
http://www.sqldev.net/xp/xpsmtp.htm
October 23, 2006 at 3:36 pm
Always do
PRINT @strSQL
just before
EXEC (@strSQL)
Do it and you'll see your error by yourself.
October 23, 2006 at 3:22 pm
DECLARE @itemList VARCHAR(8000)
--SET
@itemList = ''
SELECT
@itemList = ISNULL(@itemList
October 23, 2006 at 3:02 pm
Again, wrong database design returns problems.
Each entity must have a table. YOu don't have table for Invoices. Only for Invoice Rows.
You must create it.
Will you create it once as...
October 23, 2006 at 5:48 am
You nned, probably, read what INTERSECT is for and than look for this functionality in BOL or ask here.
October 23, 2006 at 2:00 am
That's not only one you missed. ![]()
Compare this:
1) Create VIEW in all tarteted databases with set of fields matching set of inserted data;
2)...
October 22, 2006 at 8:45 pm
Table inserted does not exist in the scope of dynamic SQL.
It must be mentioned only inside of trigger itself.
October 22, 2006 at 7:58 pm
My approach does not touch design of the data storage db.
I add just a view with trigger - it's just SP with table parameter "inserted".
Table inserted exiats only in trigger.
To...
October 22, 2006 at 6:09 pm
Viewing 15 posts - 4,876 through 4,890 (of 6,036 total)