Viewing 15 posts - 7,711 through 7,725 (of 15,381 total)
Check out this article. It not only explains the "issue" you are facing, but also it can reproduce it.
June 28, 2013 at 1:43 pm
Steven Willis (6/28/2013)
manibad (6/28/2013)
What I need in the end is I have to achieve the Proper...
June 28, 2013 at 1:17 pm
batgirl (6/28/2013)
This is standard practice in the US - the week of July 4 and the week of Christmas are typically no production.
True enough. I expected next week to be...
June 28, 2013 at 12:24 pm
This sounds like a job for..."Super Duck!!!". Oh wait...wrong thread.
err...have you looked at the resource governor? It can handle all these things pretty nicely.
June 28, 2013 at 12:19 pm
steve.pantazis (6/28/2013)
June 28, 2013 at 12:14 pm
realvilla (6/28/2013)
If I run the same query below against VehiclesToUpdate I get 9. So the update can choose "X" number of VINs not caring if...
June 28, 2013 at 12:06 pm
jasona.work (6/28/2013)
Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...
Nothing in here since ~5:30am and that from someone...
June 28, 2013 at 11:57 am
briancampbellmcad (6/28/2013)
June 28, 2013 at 8:22 am
$w@t (6/28/2013)
can we use retrive data from microsoft word to any application..as same as database it has to bind to application
You said previously that you have huge data and require...
June 28, 2013 at 8:19 am
tstagliano (6/28/2013)
June 28, 2013 at 8:12 am
Luis Cazares (6/28/2013)
I understood that he wanted the code to fill a datetime column instead of using the int columns. I might be wrong :hehe:
It very well could be that...
June 28, 2013 at 8:11 am
HanShi (6/28/2013)
That's an interesting link. I've never thought of using the "0" in the DATEDIFF function, but it's an nice approach and consistent for the different dateparts (and therefor...
June 28, 2013 at 8:09 am
BE VERY CAREFUL HERE, from what you posted I suspect that @Start_Date DATETIME and @Part_Type_MP are inbound parameters to your stored proc. You have created a huge hole here that...
June 28, 2013 at 8:06 am
rajkiran.panchagiri (6/28/2013)
Execution plan attached.
Can you post the actual execution plan? The estimated plan is pretty useless here. Also as Gail asked previously, please post the table definitions and indexes.
June 28, 2013 at 7:58 am
In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results...
June 28, 2013 at 7:55 am
Viewing 15 posts - 7,711 through 7,725 (of 15,381 total)