Viewing 15 posts - 5,191 through 5,205 (of 7,484 total)
Dev (11/14/2011)
My ONLY argument is this.Dev (11/11/2011)
ID
---
2|4|6
It's bad design. If you have control on database schema, re-design it.
Well, yes, it's usually a good idea to normalise...
November 14, 2011 at 2:17 am
Dev (11/11/2011)
Peter Brinkhaus (11/11/2011)
SELECT
*
FROM
(
SELECT '2|4|6' -- '3|24|4'
) SampleTable(ID)
WHERE
'|' + ID + '|'...
November 14, 2011 at 2:04 am
david.wright-948385 (11/13/2011)
djackson 22568 (11/12/2011)
david.wright-948385 (11/12/2011)
Those last two replies (djackson 22568 and SQLRNNR) are what I mean. .
Excuse me, but maybe you need to take some time and think about what...
November 14, 2011 at 1:55 am
michael.french 172 (11/9/2011)
Apparently I am a Pediatric Dentist. My kids will be thrilled to find that out.
And apparently I'm a dead painter. That would startle my wife and kids.
November 14, 2011 at 12:39 am
btio_3000 (11/11/2011)
Any way of accomplishing this with CTE(s) w/o getting into infinite looping/ max recursion thing?Thanks in advance
Provided there is no loop in the table (ie there isn't a...
November 14, 2011 at 12:22 am
This is not quite back to the original topic, but a variation: "Are OP's mgetting worse at understanding the ansers they get to their original questions?" See the thread...
November 13, 2011 at 5:01 pm
Graham-1036457 (11/13/2011)
Thank you for your esponse. I guess the answer is No, there is no Naming Convention, other than the prefix of sp_ for Stored Procs which I...
November 13, 2011 at 4:57 pm
SQL Kiwi (11/13/2011)
I really liked this question. Not least because I didn't have to read past answer possibility #1 to get my two points 🙂
Well, I'm glad you liked...
November 13, 2011 at 3:38 pm
SQL Kiwi (11/13/2011)
It rather depends on whether you write the dumbest possible recursive solution or not:
OK, going to 1000 yours has 67% of the logical (row) reads that the naive...
November 13, 2011 at 5:32 am
Jeff Moden (11/12/2011)
November 13, 2011 at 4:54 am
bitbucket-25253 (11/12/2011)
Now a general question for yourself .... in your experiences, around the world, what would you say are...
November 13, 2011 at 3:34 am
So, anything that touches rows more than once is RBAR? I think we have to use a reductio ad absurdum argument to convince you that this is a silly...
November 12, 2011 at 2:52 am
I'm against it too.
It's shocking that nonsense answers like this are left unchanged to mislead people for five years after the nonsense has been pointed out.
The web page referenced...
November 11, 2011 at 7:32 am
Surely the correct answer is "It depends on whether the subreport is placed in a data region (when it is repreated for every row/group) or in the main body (it...
November 11, 2011 at 6:15 am
Good question.
51% got it right so far, so it's a bit easier than some recent questions. I'm surprised that 16% ticked DBCC CHECKIDENT, though, anyone who did that they...
November 11, 2011 at 2:17 am
Viewing 15 posts - 5,191 through 5,205 (of 7,484 total)