Viewing 15 posts - 12,181 through 12,195 (of 15,379 total)
Just google for "sql server 2012 new features". You will find a whole laundry list of changes.
April 30, 2012 at 8:36 am
Please read the first link in my signature about best practices for posting questions. We need ddl, sample data and desired output. In this case we probably also need ddl...
April 30, 2012 at 8:29 am
If you have no DTS packages you want/need to migrate then don't worry about it. The packages you don't want/need will not be created. If that is your only warning...
April 30, 2012 at 8:00 am
Again if you want detailed help you need to provide ddl, sample data and desired output. This is pretty straight forward code but without something to work we are shooting...
April 30, 2012 at 7:36 am
tysonlibelula (4/29/2012)
---------U need to use a fetch row sintax
Actually this is not a good approach as far as performance is concerned. The set based solution suggested in the original thread...
April 30, 2012 at 7:31 am
OK that is what I thought. This shouldn't be a big deal. I would stay but I have to go pick up the kiddos.
April 27, 2012 at 3:08 pm
I hate it most when I lose the arguments. :Wow:
April 27, 2012 at 3:04 pm
OK so you want the most recent TO_PAY_RATE? I think we can do this.
The only thing I changed from your original was to remove the extra temp table. No need...
April 27, 2012 at 2:59 pm
That can be complicated for sure. I have been in that situation and the way I handled it was to make the process a little more formal. After meetings I...
April 27, 2012 at 2:56 pm
ColdCoffee (4/27/2012)
Sean Lange (4/27/2012)
April 27, 2012 at 2:44 pm
OK I realized your first select was filling your temp table and then you selected from it. Still not 100% what you want for output but here is a shot.
I...
April 27, 2012 at 2:39 pm
SQLRNNR (4/27/2012)
Sean Lange (4/27/2012)
i am putting it in if condition,does that is the problem?
I know exactly where the problem is...that big blob right between...
April 27, 2012 at 2:33 pm
Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps the guilt of that is...
April 27, 2012 at 2:31 pm
Such is the complication of IT people everywhere. "Normal" people think about what software could/should do and have concept of programming. The challenge is to take incredibly vague and often...
April 27, 2012 at 2:28 pm
opc.three (4/27/2012)
Sean Lange (4/27/2012)
opc.three (4/27/2012)
Lynn Pettis (4/27/2012)
opc.three (4/27/2012)
...on second thought...comment removed...Dang, had three minutes to see what you said and I missed it. 😛
Yeah...for once I need to stop...
April 27, 2012 at 2:22 pm
Viewing 15 posts - 12,181 through 12,195 (of 15,379 total)