Viewing 15 posts - 6,661 through 6,675 (of 7,191 total)
Ryan
Assuming the taskid column doesn't allow nulls, something like this:
SELECT e.empid,
e.name,
COUNT(t.taskID) as tcount,
COUNT(t.taskID) - COUNT(t.resolution) as NullRes
FROM tasks t
RIGHT JOIN employee...
December 21, 2006 at 9:01 am
Ah - it's an AS400 database? I don't know anything about AS400, I'm afraid. However, if it's ANSI compliant, you should be able to run SELECT TABLE_SCHEMA, TABLE_NAME...
December 21, 2006 at 8:34 am
Manish
Are you using the Standard or Enterprise Edition of SQL Server 2000?
John
December 21, 2006 at 8:06 am
Nelson
The only thing I can think of is that you may have two tables called BZRCRP, one owned by dbo (with 5 records) and one owned by EBSTSTNEW (with 1...
December 21, 2006 at 8:01 am
David
No, it's because LIKE doesn't work with text data types. The performance of this isn't going to be good, because none of the searches will be able to use indexes. ...
December 21, 2006 at 7:22 am
Dave
Glad you got it working. Just one more thing. If you use my method, and any of your tables have text columns, you will need to add the following:
December 21, 2006 at 6:39 am
Raj
So do you only ever insert one row at a time? Is it during the insert itself that you experience the poor performance, or during the duplicate checking?
John
December 21, 2006 at 6:27 am
David
You will need to build a script dynamically. Something like this rough-and-ready effort, which generates a script that returns all rows where at least one of the columns has a...
December 21, 2006 at 5:10 am
Raj
So you're doing this once for every row you're inserting into the table? Are you using a cursor or a WHILE loop to do that? I think this is probably...
December 21, 2006 at 4:17 am
Anchelin
OK. Can you please put a PRINT @Query3 statement just before the EXEC command and post the result of that.
Thanks
John
December 21, 2006 at 4:04 am
Probably what you need, then, is to create a trigger in the table that checks the time of the previous insert, and if it was less than ten minutes ago,...
December 21, 2006 at 4:00 am
Anchelin
How many columns are in the result set when you run sp__DBBackupInfo on the remote server?
John
December 21, 2006 at 3:32 am
Raj
I'm sorry, I don't know anything about Materialized views in Oracle so I can't advise you on that.
If you had a unique constraint on CUST_PRODUCT_ID, ATTRIBUTE_ID and DATA then that...
December 21, 2006 at 3:29 am
Would this not work?
SELECT Titleid AS tit FROM title WHERE Titleid=11
John
December 21, 2006 at 3:08 am
What are the circumstances under which you wish to discard the less recent value? Is it when it is less than an hour before the previous one? Or is it...
December 21, 2006 at 2:39 am
Viewing 15 posts - 6,661 through 6,675 (of 7,191 total)