Viewing 15 posts - 2,266 through 2,280 (of 15,381 total)
hreyes819 (9/22/2015)
Col1 - has values that originate from table 1
Col2 - has values that originate from table 2*
Col3 - has values that originate from table 2*
Col4 -...
September 22, 2015 at 9:00 am
Lynn Pettis (9/22/2015)
Sean, we will need to run some tests between our respective answers.
Agreed. I have a feeling yours might win out because iirc the unpivot can get a bit...
September 22, 2015 at 8:57 am
While the real world application of this is totally elusive the actual code is quite simple.
if OBJECT_ID('tempdb..#something') is not null
drop table #something
create table #something
(
col1 int
, col2 int
, col3 int
,...
September 22, 2015 at 8:46 am
hreyes819 (9/22/2015)
New to SQL Server. Have a lot of MS Access experience and know how to do this task in Access vba but I have not been able...
September 22, 2015 at 8:36 am
WayneS (9/21/2015)
Alan.B (9/21/2015)
The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?
Anyone good...
September 21, 2015 at 10:13 am
PLEASE don't cross post. You have at least two threads for the exact same issue going on. This only fragments replies and makes it more difficult for you AND the...
September 21, 2015 at 10:11 am
Is there a reason you are trying to use a cursor here? Cursors are horribly inefficient and not be used for this type of thing in the real world. If...
September 21, 2015 at 10:07 am
WayneS (9/18/2015)
Sean Lange (9/17/2015)
September 21, 2015 at 8:16 am
The speed issues seem to have been elusive for me too. Not sure what, if anything, you did but it seems to have helped.
September 21, 2015 at 7:53 am
Alvin Ramard (9/18/2015)
Student: Teacher, do you want the solution based on your methodology, or the correct solution? 😀
Guessing that won't work out too well. We all have to keep in...
September 18, 2015 at 2:05 pm
Jack Corbett (9/18/2015)
'
SELECT
*
FROM
"database"."dbo"."table" WITH (UPDLOCK, REPEATABLEREAD)
WHERE
...
September 18, 2015 at 7:55 am
Eric M Russell (9/17/2015)
Sean Lange (9/17/2015)
Eric M Russell (9/17/2015)
September 17, 2015 at 9:52 am
Kristen-173977 (9/17/2015)
Luis Cazares (9/17/2015)
It should come to personal preference.
... so long as Personal Preference doesn't include the, 7x slower, MS provided one!!!
Heh I would choose my own complicated version over...
September 17, 2015 at 9:20 am
Luis Cazares (9/17/2015)
Sean Lange (9/17/2015)
Awesome thanks Luis. I have been focusing on other aspects of this process today and hadn't gotten to writing up a test harness for performance yet....
September 17, 2015 at 9:17 am
Viewing 15 posts - 2,266 through 2,280 (of 15,381 total)