Forum Replies Created
Viewing 15 posts - 991 through 1,005 (of 4,080 total)
-
RE: Are the posted questions getting worse?
I think I have 4 renditions of the movie based on that novel plus the novel (unabridged) dans sa langue maternelle.
You surprised me with that Jason. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
or breaking the window to steal a loaf of bread a la Jean val Jean
You know nothing of Javert, 24601 !
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
coerced nonetheless by the need for protection
I'm afraid I'll have to card you for that one.
Look up the definition of coercion and it is generally defined as forcing or pressuring...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: How to guesstimate # of recursions?
No, the anchor query in a recursive CTE does not count towards the MAXRECURSION limit.
As you can see for yourself in the following example, setting MAXRECURSION to 2 doesn't stop...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Left Join issues
I confess to being curious whether or not all the grouping will be faster than the joins we're trying to avoid.
Just for fun, here's another way of looking at it....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
I was about to spend a bit of time and effort joining into the debate. But I find that my views are summed up quite nicely here:
http://www.youtube.com/watch?v=dOOTKA0aGI0
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Departing briefly from the fascinating debate in progress, I would like to invite others to consider the coding problem here. I started out trying to help the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Dynamic CTE?
You are welcome, for what my help was worth, but I am going to have to bow out at this point. While it is possible to write...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Dynamic CTE?
Understood. But that is not really suitable for a set-based solution in SQL. Which is why I advised you to get some front-end coding done...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: probem with declare
Glad it's working, but a null value in the table wouldn't cause the error below:
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@_type".
A word of advice:...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Dynamic CTE?
It's more complicated than that, Gus. Take a look at the original question and the solution I gave him (with warnings). The problem is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: probem with declare
The last code you posted (which is repeated below) works on fine for me. Are you posting ALL the code you're executing. Are you sure...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Need Help with Logic
My possible result sets(o/p) from joining two tables are
Possible o/p 1:
col1 col2 col3
1 1 a
1 1 b
Possible o/p 2:
col1 col2 col3
1 1 a
1 2 a
1 1 b
1 2...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: insert into problem
Please don't double post. This is essentially the same question I answered here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: probem with declare
carlos cachulo-318532 (7/13/2011)
if i runSELECT max(turno)+1 INTO@_type FROM u_contadores;
i get the desired value
I beg to differ. The statement:
select @max(turno)+1 into @_type from u_contadores
is not valid...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 991 through 1,005 (of 4,080 total)