Viewing 15 posts - 4,726 through 4,740 (of 5,678 total)
Solution, Round 1:
if OBJECT_ID('tempdb..#Employee') is not null
drop table #Employee
go
create table #Employee
(EmployeeID int,
Work0110 bit,
...
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 6, 2010 at 4:12 pm
Paul Herbert (12/6/2010)
Thanks Jeff. Good stuff ... as usual.I guess this makes me a lurker no more.
Hey Paul, welcome to the club.
Your brother Frank does nice 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 6, 2010 at 3:45 pm
parthi-1705 (12/6/2010)
Hiwhere ProcedureCodeID = @CodeID)
)-- is Missed
Dont just post the code with out crossverfying it is simple and basic step, you should be able to solve.
Thanks
Parthi
Be gentle...
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 6, 2010 at 3:44 pm
cvandevoorde (12/6/2010)
I still don't understand why, if the columns...
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 6, 2010 at 12:29 pm
Well, this amused me... I recieved this PM. Allow me to share my reply with you:
petersonlawson9 (12/6/2010)
Dear Friend
i am Mr.peterson lawson, personal friend...
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 6, 2010 at 12:07 pm
I did a stint at GoDaddy. While I'm not excited by the leadership there (and that's all I'll say publically), most of the tech side of the house actually...
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 6, 2010 at 12:03 pm
ken.trock (12/6/2010)
Lowell (12/6/2010)
because 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 6, 2010 at 11:57 am
You've run into a common issue, and it's a natural one to make. The Where clause limits the data, then we do the rest...
Sadly, this isn't true. You...
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 6, 2010 at 11:55 am
I need to agree here, SSIS for this is using a sledgehammer as a screwdriver.
Activeworkbook.worksheets(1).move ("Targetfile", vbLastSheet) is the syntax you want, if memory serves. It's been about 10...
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 5, 2010 at 2:57 am
I think this is one of those things in the back of my head I always knew, and just never really appreciated just how intrusive the problem could be.
Awesome article,...
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 5, 2010 at 1:27 am
Short form: No, not directly. Carries too much metadata.
Longer form: Screen print is your best, optimal choice here. Mostly because it's your only one.
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 5, 2010 at 1:12 am
I know there's all the rendering bits and whatnot to make sites pretty, but I know what 2400 baud looks like. I tried playing graphical MUSH's on them. ...
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 5, 2010 at 1:10 am
Trey Staker (12/3/2010)
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 3, 2010 at 4:11 pm
For those playing along at home, Ragged Right needs a specific setup, you need to have one extra column in the advanced section for the CR/LF. Basically, it creates...
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 3, 2010 at 3:29 pm
markshelden (12/3/2010)
Anyway, I found the answer in another thread. You need to use the ragged...
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 3, 2010 at 3:15 pm
Viewing 15 posts - 4,726 through 4,740 (of 5,678 total)