Viewing 15 posts - 20,941 through 20,955 (of 26,484 total)
Jeremy Brown (5/18/2009)
May 18, 2009 at 10:33 am
FelixG (5/18/2009)
declare @cargo int
set @cargo = 5
Select distributorid, distributorname, distributorstatus,distributorcargo
from Dist_Main M inner join Dist_Details D on
M.DistPK = D.DistFK
where distribuborcargo = @cargo
and distributorstatus in ('9', '7','5','1')
You should consider the use...
May 18, 2009 at 10:30 am
There may be other alternatives, but the only two I can think of are to create a temorary (dynamic) table and join to it in the FROM clause or create...
May 18, 2009 at 10:09 am
Please don't double post. Please reply on the this thread.
May 18, 2009 at 9:56 am
Since an INSTEAD OF INSERT trigger fires prior to the actual INSERT, I'd actually vote for Gus's solution, but I also agree with him on the testing in a development...
May 18, 2009 at 9:49 am
Not only that, but you are trying to insert records that have already been "inserted" into the table. I agree with Luke. You need to extend your primary...
May 18, 2009 at 9:14 am
I agree with Steve. Also, I'd run separate backup processes for each database.
May 18, 2009 at 9:06 am
The only two things missing from the above is your expected results and the code you have developed so far. Sorry, but the graph and your verbal description just...
May 18, 2009 at 9:03 am
John Marsh (5/17/2009)
Generally speaking it is preferable to filter records at the Server, particularly in order to reduce Network Traffic.
A slight alternative to Lynn Pettis’s suggestion would be to...
May 18, 2009 at 8:35 am
As this is an assignment, I'd like to suggest that you show us what you have done so far to try and solve your problem. From there we can...
May 17, 2009 at 10:14 pm
At this point I am going to chime in and suggest that you read the first article I reference below in my signature block and the following blog, The Flip...
May 17, 2009 at 10:06 pm
Unless you are experiencing disk space issues on the disk where tempdb resides, I'd leave it alone. It grew to whatever size it is for a reason. If...
May 17, 2009 at 9:56 pm
I have to agree, the wording of the question is questionable.
Directly from the source sighted in the answer to the question:
50 instances on a stand-alone server for all SQL Server...
May 17, 2009 at 9:28 pm
smknox (5/17/2009)
May 17, 2009 at 9:07 pm
Viewing 15 posts - 20,941 through 20,955 (of 26,484 total)