Viewing 15 posts - 1,831 through 1,845 (of 5,678 total)
Jon MM (2/2/2012)
If you know of a better approach I would love to hear about it!Thank you for your help 😀
I don't know of a better approach but I've thought...
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
February 2, 2012 at 12:10 pm
Out of curiousity, what's the problem with doing it this way:
Update t1
set status = 5
FROm
table1 AS t1
JOIn
table2 AS t2
ON
t1.DOC_CD = t2.DOC_CD
AND t1.DEPT_CD = t2.DEPT_CD
AND t1.DOC_ID = t2.DOC_ID
AND t1.VERS_NO = t2.VERS_NO
AND...
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
February 2, 2012 at 12:06 pm
Koen Verbeeck (2/2/2012)
Sri8143 (2/2/2012)
I am doing it thru transfer sql server objects tasks which was recomended initially in this conversation so going with it as i am unable to do...
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
February 2, 2012 at 11:23 am
JAZZ Master (2/1/2012)
Springer
Crying mothers in broken households who want to sue their ex husband and will have their five current boyfriends to show him all the reasons why!
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
February 1, 2012 at 2:51 pm
Star Trek (2/1/2012)
how can I get it for a particular query?Do I need to write a query for that?
The SPID itself needs to be reviewed during operations. You need...
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
February 1, 2012 at 2:34 pm
SQLKnowItAll (2/1/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
February 1, 2012 at 2:24 pm
sartis (2/1/2012)
Hey Craig, So i moved my where statement into my join statement and I got it to work correctly, thanks for trying to help.
:blink: I'm glad that made...
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
February 1, 2012 at 1:48 pm
SQLKnowItAll (2/1/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
February 1, 2012 at 1:47 pm
Rem70Rem (2/1/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
February 1, 2012 at 12:05 pm
Calling for backup here, if you could. Guy's got data that apparently is inconstently left out of his query in what he swears is a static system. I'm...
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
February 1, 2012 at 10:40 am
drew.allen (2/1/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
February 1, 2012 at 10:35 am
johnitech.itech (2/1/2012)
:w00t:Hello ,Why not found ,If you install excel 2007 ,You will found automatically
thanks
That's incorrect. You need to install Excel 2k7 or 2012, then still perform those tasks....
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
February 1, 2012 at 10:34 am
Not from SSIS, once it's handed off the VBA command. You'll have to log into the machine and directly stop the process via Task Manager. Stopping the process...
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
February 1, 2012 at 10:29 am
sqlzealot-81 (2/1/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
February 1, 2012 at 1:09 am
You have to go through a couple of hoops to hook SSIS to the new office documents (2k7+).
This walkthrough is a good place to get started:
http://dataintegrity.wordpress.com/2009/10/16/xlsx/
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
February 1, 2012 at 1:06 am
Viewing 15 posts - 1,831 through 1,845 (of 5,678 total)