Viewing 15 posts - 46 through 60 (of 155 total)
Thanks for your reply. I tried it ... C:\MyFolder has one file in it.
The temp table ended up with one column called 'Files' with 11 rows in it showing ...
Volume...
October 16, 2013 at 9:30 am
This is a one time import.
I have saved the Excel file as a csv file and tried to import it.
I have set all the fields in the table that is...
August 6, 2013 at 5:13 pm
Jeff Moden (5/31/2013)
May 31, 2013 at 7:33 am
Ed Wagner (5/31/2013)
SELECT l.LeaderID, l.leader, m.memberid, m.member, ROW_NUMBER() OVER (PARTITION BY l.leader ORDER BY l.leader)
FROM #tblLeaders l
INNER...
May 31, 2013 at 5:49 am
Thanks for that, it does the job.
Edit - sorry, this comment was directed to Nick_UK - but it didn't appear where I expected.
May 31, 2013 at 5:48 am
Thank you very much for your help. I was under the impression that after using a CTE, you had to SELECT from it. I didn't realise you could create multiple...
February 22, 2013 at 2:35 am
Hi, and thank you for your answer.
Following Jeff Moden's answer (and link) - I modified my code to have a sort key that ended up returning...
\6
\6\7
\6\7\12
\6\7\8
\6\7\8\13
... which seems to do...
February 12, 2013 at 1:52 am
Ahhhh! Thank you, thank you and thank you again.
Spent most of the weekend on that and today. I've got a bin full of paper with drawings of little tables with...
February 11, 2013 at 5:05 pm
I see 45 people have looked at this ... but no comments.
Is my question not clear? Or am I going about it the wrong way? Any comment at all? If...
February 11, 2013 at 12:31 pm
Thanks for that, I'll give it a try.
February 11, 2013 at 9:09 am
Thanks very much - as you say, that does the job.
Worst case will be maybe 500 rows - so I'm sure performance won't be an issue.
Thanks again.
October 24, 2012 at 4:27 pm
Thanks for the input so far - as you say, the code so far does not produce the right order.
I've been playing with an awful mess of cursors and temporary...
October 24, 2012 at 4:08 pm
Thanks again guys.
As a matter of interest - the real world scenario is a maximum of 5 templates.
Each template has 15 to 20 blocks.
Each block has anything from 1 to...
September 8, 2012 at 4:06 am
That does the job too. Again, thanks very much.
Just wish I understood both the solutions that work.
September 7, 2012 at 12:51 pm
ScottPletcher (9/7/2012)
SELECT TemplateID
FROM #tblBlocks
GROUP BY TemplateID
HAVING COUNT(DISTINCT CASE WHEN #tblBlocks.BaseStage = 1 THEN BlockID END) = COUNT(DISTINCT BlockID)
That does the job. Thanks very much.
September 7, 2012 at 12:50 pm
Viewing 15 posts - 46 through 60 (of 155 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy