Viewing 15 posts - 7,051 through 7,065 (of 7,429 total)
Try this
UPDATE cd
SET TotalPaidIn = TotalPaidIn + cp.TotRec, BalanceOnHand = BalanceOnHand + cp.TotRec
FROM casedata cd
INNER JOIN
(SELECT CaseNumber, SUM(ReceiptAmount) AS TotRec
FROM currentpostings
WHERE batchId = @batchId
GROUP BY CaseNumber) AS cp
ON...
March 1, 2002 at 4:27 pm
Deffinently stick with the default as is. Only adjust in the queries themselves if you find a need to.
"Don't roll your eyes at me. I will tape them in place."...
March 1, 2002 at 4:06 pm
From this 'NT AUTHORITY\ANONYMOUS LOGON' I can tell you used NT Authenication to connect to the other box when you built. The problem is SQLAgent does not have a domain...
March 1, 2002 at 9:14 am
Haven't got a file that large to test but have you tried setting up a table with a text datatype field and import to it?
"Don't roll your eyes at me....
March 1, 2002 at 7:44 am
Sorry, I meant one single quotes (') must be submitted as two singles ('') not a double.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
March 1, 2002 at 7:36 am
Submit as "Mary''s book", in your app just do a replace ' for '' before submitting.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
March 1, 2002 at 6:49 am
My son loves to roll his eyes when I am talking to him and he is sort of avoiding my words (got it from his mom for sure). I heard...
March 1, 2002 at 5:54 am
I agree with Andy 30 seconds should be sufficient but keep in mind this affects how long the current query and if a really long query is already running you...
March 1, 2002 at 5:45 am
You could also create the rol in the model database that way when you create a new database it will already be there, then you just have to assign permissions...
March 1, 2002 at 5:42 am
Glad to hear.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 1, 2002 at 5:23 am
Sorry, terminal is not a supported font in web so you will not be able to. I also don't know of anything similar that you could provide.
"Don't roll your eyes...
March 1, 2002 at 5:08 am
All depends on the amount of data, the number of read/writes average, network throughput and mostly the physical configuration of the server. But as far as instances you actually are...
March 1, 2002 at 4:50 am
Absolutely loved it. Top notch.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 1, 2002 at 4:36 am
Yes. However I think we forgot you have to setup the server with the proper code page see BOL
Collation Settings in Setup
Use the Collation Settings screen to modify default collation...
February 28, 2002 at 10:40 am
Viewing 15 posts - 7,051 through 7,065 (of 7,429 total)