Viewing 15 posts - 10,321 through 10,335 (of 14,953 total)
foxjazz (3/23/2009)
Since there is a constraint, I have to delete the applicationid from the application table first, then delete it from the applicationproduct table.As seen in the code above.
Do you...
March 23, 2009 at 11:37 am
Try this in a test copy of the database, or wrapped in a transaction you can roll back.
DELETE
ApplicationProduct
FROM
dbo.ApplicationProduct
INNER JOIN dbo.Application
ON ApplicationProduct.ApplicationID = Application.ApplicationID
INNER JOIN dbo.Product
ON...
March 23, 2009 at 11:29 am
I'm not sure what you mean by "markers".
March 23, 2009 at 9:51 am
Nah. If the temp table is created/populated with a select from the main table, you'll just be processing the data twice instead of once.
March 23, 2009 at 9:41 am
Is there a reason to do this with a cursor instead of with Cross Apply?
March 23, 2009 at 9:40 am
I can't tell just from that what it's trying to do. Are you executing that as a command?
Are you getting an error message? If so, what?
It would be...
March 23, 2009 at 9:35 am
Here's something you might try. I have no idea if this will work, but it might be worth a try.
Create a separate database that in Compat 90. Write...
March 23, 2009 at 9:31 am
I think the only way you're going to get SQL 2000 to do that is with dynamic SQL.
You can parse out a string with a Numbers table, but that won't...
March 23, 2009 at 9:30 am
Right. Because that's an execution problem in the Try block of the calling query. Try adding a Try...Catch to the dynamic SQL command, and see what that does.
March 23, 2009 at 9:27 am
I would need to see your code to know what to suggest.
March 23, 2009 at 9:24 am
It'll depend on a number of factors.
For example, if you delete all 1-million at once, that will create a rather huge transaction, which might take a long time to commit....
March 23, 2009 at 9:23 am
I can't tell what the function does. Is it something that could be turned into a correlated sub-query?
March 23, 2009 at 9:20 am
There's an "ASCII()" function that will generate any given ASCII character. Just put the number in it.
You can get the numbers from Wikipedia. Just Google "ASCII" and it...
March 23, 2009 at 9:17 am
Have you found what's causing the timeouts? That'll be a good place to start.
Coincidentally, there's actually a front-page article today on that exact subject. Check that out, it...
March 23, 2009 at 9:14 am
Per Books Online:
A TRY…CATCH construct catches all execution errors with severity greater than 10 that do not terminate the database connection.
Note that it says, "execution errors". Those are what...
March 23, 2009 at 9:13 am
Viewing 15 posts - 10,321 through 10,335 (of 14,953 total)