Viewing 15 posts - 901 through 915 (of 5,678 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. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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()
...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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'...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 2, 2013 at 3:52 pm
kevin.kembel (1/2/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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:
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 31, 2012 at 12:24 pm
Grass (12/18/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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,
...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 18, 2012 at 4:56 pm
Viewing 15 posts - 901 through 915 (of 5,678 total)