Viewing 15 posts - 901 through 915 (of 5,685 total)
john 60195 (1/3/2013)
After some more read maybe this would lock a record (and only one record) until all work is done,
I just want to second what Gail said above. ...
January 3, 2013 at 1:24 pm
kamal_ece (1/2/2013)
Hi Andrew,This link probably answer your query "http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/91665/"
Hope this helps.
Regards,
Kamal
that's... wow. Intricate and overkill.
In VB:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
Public Sub Main()
...
January 2, 2013 at 3:57 pm
I personally use a filewatching script task as step one of the job, and then the main 'package' in step 2. A few reasons. First, not all 'missing'...
January 2, 2013 at 3:52 pm
kevin.kembel (1/2/2013)
January 2, 2013 at 3:47 pm
Bron Tamulis (12/31/2012)
Craig - I tested your solution for a multi-level BOM and it worked great.Thanks for your assistance..........
Glad to hear and my pleasure. I just don't always trust...
January 2, 2013 at 12:27 pm
Merry Christmas and Happy New Year to all! Warm wishes for 2013.
Oh, yeah, and Happy Birthday to me. :hehe:
December 31, 2012 at 2:04 pm
*facepalm* Seriously?
CELKO (12/30/2012)
How can a quantity be NUMERIC(19, 5) and not an INTEGER?
Water: 1.5 gallons
Flour: .75 cups
It's a Bill of Materials table. Decimals are definately part of...
December 31, 2012 at 1:55 pm
Hm, there's a few nasty pieces to this but the biggest problem is the fctTxPayPlan table.
Estimate: 39,000 rows. Actual: 23 billion.
Might problem there. The table's a heap, get...
December 31, 2012 at 12:57 pm
I have to agree with Koen here. The correct answer here is not SSIS, it's replication, log shipping, or mirroring. SSIS is point in time upkeep on large...
December 31, 2012 at 12:54 pm
aykut canturk (12/31/2012)
the trigger is very simple and only makes some calculations. what I need is get the ID number of this record and write it to another field.
For the...
December 31, 2012 at 12:48 pm
A few words regarding SSNs:
1) It's identifying information. Damn near illegal to physcially store next to medical data on a client. You will fail audits if your encryption...
December 31, 2012 at 12:42 pm
Scott, the trouble with sp_applock is that it's designed around single user - single process aspects. My understanding of the OP's question revolves around multiple dentists accessing multiple clients...
December 31, 2012 at 12:24 pm
Grass (12/18/2012)
December 19, 2012 at 3:21 pm
Use the code="sql" IfCode on the left, like so. Dwain's right, I flipped the order for having/group by, need to put it after.
SELECT
O.OrderID,
...
December 19, 2012 at 3:18 pm
support 86837 (12/18/2012)
Your query works only if I omit the HAVING clause.
What error are you getting? You're getting untested code as I don't have a sample set to work...
December 18, 2012 at 4:56 pm
Viewing 15 posts - 901 through 915 (of 5,685 total)