Viewing 15 posts - 1 through 15 (of 83 total)
Crap! I just discovered the problem.
Was testing (again), entering all but the last character. When I was typing the confirming entry my brain, having typed it so many times was...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
January 11, 2013 at 12:45 pm
Thank you both, Artoo22 & opc.three for your replies. I read the links.
The following is what I got out of the articles. Let me know if I'm on the right...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 9, 2012 at 11:05 am
Sorry for making assumptions about how you'd end up using it.
Actually, I'm glad you didn't. Having to execute the different scenarios was good practice for me to understand it...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 8, 2012 at 9:00 am
The SNAPSHOT isolation level would have to be enabled at the database level before you could use it, so you will want to check with the DBA, if that's you,...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 5, 2012 at 2:33 pm
Thanks!
sp_who2 should have had a bit in the BlockBy column showing your open transaction blocking your other update. Won't see it now, but you could reproduce it by starting and...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 5, 2012 at 11:00 am
It's known as UPDATE FROM, and it's typically used to update a table with data from another and / or update a table filtered by a join with another.
I realize...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 5, 2012 at 2:43 am
Problem Resolved: It was a PICNIC - Problem In Chair, Not In Computer
I had run an UPDATE on the table earlier in another query window, but, had not COMMITted it.
Discovered...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 4, 2012 at 1:49 pm
Are you asking for: dbo
i.e. dbo.ClosedJobsSumms
All the other tables created in this DB are dbo.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
October 4, 2012 at 1:18 pm
Stop The Presses... My Thread has been hijacked. 🙂
Would you please take this REFERENCES conversation to another thread?
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 27, 2012 at 11:38 am
Wow! 🙂
There's a lot I have to learn.
Some of what you mentioned was over my head. That's OK, just letting you know.
Did a cursory read of the Forum Etiquette....
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 26, 2012 at 3:55 am
LOL - I know what you mean.
If this customer follows their pattern, next year they will have a request with something else that is different. It's always been YTD Sales...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 24, 2012 at 7:06 pm
I just took a moment to get an appreciation of CTEs, found and article by Robert Sheldon, with examples that make it clear.
Jeff - What do you mean by the...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 24, 2012 at 1:13 pm
LOL - The first thing that pops into my head is that "10,000 Hours Rule" (Malcolm Gladwell, more familiar as a quote by Bill Gates).
Thanks for the advise. ... I...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 23, 2012 at 3:12 pm
🙂
So much to learn! And so little time. (ha, ha)
This job has been quite the learning experience for me. Before 2004, when I started, I had developed two custom ERP...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 23, 2012 at 6:59 am
First! Thank you all for taking the time to reply. I appreciate all the feedback.
A little background about me and my situation. We have a 3rd party ERP system, SQL...
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 22, 2012 at 8:25 am
Viewing 15 posts - 1 through 15 (of 83 total)