Viewing 15 posts - 1,711 through 1,725 (of 5,685 total)
ColdCoffee (3/22/2012)
Mathew Abraham (3/22/2012)
Update D set j=s.j, k=s.k from @table_D D,@table_S s where d.i=s.i
The problem is the CROSS JOIN. why do u want to do a cross...
March 22, 2012 at 3:39 pm
Hmmm, that IS really odd.
You can't guarantee the order of the updates but I wouldn't expect the null to be ignored.
Wrapping the k setting with an isnull also doesn't correct...
March 22, 2012 at 3:38 pm
Burninator (3/20/2012)
We're trying to locate a 6 month contractor to handle a SSRS report request overload from the business.
I'm your huckleberry...
Needs to be on-site in Phoenix, AZ. Chair warmth...
March 20, 2012 at 6:16 pm
codebyo (3/20/2012)
Evil Kraig F (3/20/2012)
However,...
March 20, 2012 at 6:12 pm
This is basically a running totals query, and I believe that's where Jeff's going with his solution so I won't work the same process twice. 😉
However, there's another concern with...
March 20, 2012 at 5:13 pm
GilaMonster (3/20/2012)
I have a number of physics courses, a couple of astrophysics, one or two philosophy and a calculus one queued up to watch.
My hats off to you for considering...
March 20, 2012 at 2:47 pm
It has nothing to do with the log backups and everything to do with how the file is grown. Kimberly Tripp's articles are the best I've seen on this...
March 20, 2012 at 2:39 pm
I'm currently dealing with this exact issue. We're trying to locate a 6 month contractor to handle a SSRS report request overload from the business.
So far: Three people who...
March 20, 2012 at 2:38 pm
Jack Corbett (3/15/2012)
Isn't there some Date guy too?
Nono, that was Data, from Star Trek... and he was a walking database, not a designer. That was Midnightian Soong....
March 15, 2012 at 4:37 pm
Grant Fritchey (3/15/2012)
GSquared (3/15/2012)
March 15, 2012 at 4:36 pm
Not a problem. Sorry, this fell off my radar for a bit and I got sucked into a project for a week so I hadn't reviewed old threads for...
March 9, 2012 at 2:23 pm
I almost got this wrong but the 'select 2 answers' bit excludes the need for the answer 'both run to completion', which would thus give me 3 answers.
The first option...
March 9, 2012 at 1:23 pm
I'm afraid we're going to have another polite disagreement, Travis. 🙂
TravisDBA (3/9/2012)
1. Shop doesn't want to spend the money to upgrade software/hardware
There's no reason to spend money 'fixing' something that...
March 9, 2012 at 12:00 pm
jbalbo (3/9/2012)
Evil,This works great and I even understand it!! lol
Thanks
Joe
Great, I'm glad that helped. 🙂 Good luck.
March 9, 2012 at 11:44 am
MidBar (3/9/2012)
So anything just clicked in your mind?
Ah, so it's the sub-procedures to the reports you want to adjust for pre-calculations. Gotcha. Offhand, no. Most of the...
March 9, 2012 at 11:43 am
Viewing 15 posts - 1,711 through 1,725 (of 5,685 total)