Viewing 15 posts - 2,356 through 2,370 (of 3,232 total)
"if table A has null value raise error 'please enter your ID'"
Wouldn't this be the same as your post from here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=354363
except that you would want to stop the UPSERT...
March 30, 2007 at 3:37 pm
Wow, sorry about the multi-post. My PC blinked on me and it posted multiple times as I was still typing.
Anyhow, if my above suggestion does not help, please post...
March 30, 2007 at 3:22 pm
Well, what are you expecting to get back? For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1. Shouldn't...
March 30, 2007 at 3:21 pm
Well, what are you expecting to get back? For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1. Shouldn't...
March 30, 2007 at 3:21 pm
Well, what are you expecting to get back? For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1. Shouldn't...
March 30, 2007 at 3:21 pm
Well, what are you expecting to get back? For starters, it appears that you have a typo in your @write tally in the line: Select write =@write + 1. Shouldn't...
March 30, 2007 at 3:21 pm
There are a few differenct licensing models to choose from depending on your needs. SQL Server 2005 licensing info can be found here: http://www.microsoft.com/sql/howtobuy/default.mspx
As far as your expected growth,...
March 27, 2007 at 3:27 pm
Your query (as posted) cannot possibly return the error in your post. This is a very straight forward error and there must be a sub-query...
March 23, 2007 at 11:52 am
Make sure your columns in dbo.Database_Logins are big enough to hold the result set from sp_DatabaseLogins.
March 22, 2007 at 11:24 am
SQL Server is designed to grab as much memory as it can and not release it. If you want to limit how much memory SQL Server can use, set you...
March 19, 2007 at 11:04 am
UNION removes duplicate rows. Use UNION ALL if you want the duplicates to remain.
March 19, 2007 at 11:00 am
'Unless the drive array was being hammered from another server [File or Exchange]; I never checked that.'
Is this on a SAN? If so, you want to make sure that your...
March 19, 2007 at 10:00 am
Are all inserts slow? What about updates? Is your t-log the only thing using the mapped array? Is it on a SAN?
March 16, 2007 at 2:51 pm
Are you using SQL Server 2005? Your post is in the SQL Server 7,2000 T-SQL section....
Here's the cost w/o the CTE:
SELECT Cost
FROM #CostHist ch
INNER JOIN (
SELECT s.SaleID, s.Item,...
March 16, 2007 at 2:46 pm
Can you post the full table DDL including the indexes and the execution plans for both queries?
March 16, 2007 at 2:14 pm
Viewing 15 posts - 2,356 through 2,370 (of 3,232 total)