Viewing 15 posts - 10,546 through 10,560 (of 39,793 total)
Thanks, but this is falling on dead ears.
We are working to implement some SPAM prevention measures and change some code. Hard to get this to be a priority, though.
September 25, 2014 at 2:40 pm
I couldn't imagine how this would be a problem, but there must be some counting.
I've struggled with developers to fix it, which seems odd to me since it must...
September 25, 2014 at 12:38 pm
Many people think of this as random. I was trying to point out that there can be issues. I wasn't trying to point out all issues, though I'll change the...
September 25, 2014 at 11:09 am
I think you're both napping, Ray.
I was working with the laptop on my legs and the kitty kept attacking my typing fingers. This was about 15 minutes later, she called...
September 25, 2014 at 10:21 am
lshanahan (9/25/2014)
How data is collected is just as important as quantity if not moreso, as...
September 25, 2014 at 10:06 am
There's nothing right or wrong about aliasing. It's preference.
I try to use them often, because I find many queries quickly get complex and it's much harder for me to read:
select...
September 25, 2014 at 9:48 am
edwardwill (9/25/2014)
Can you explain why you aliased the sys.syscolumns table?
SELECT TOP 10RAND( ROW_NUMBER() OVER (ORDER BY id))
FROM sys.syscolumns
is functionally identical, as far as I am aware.
habit
September 25, 2014 at 8:45 am
Andrew G (9/24/2014)
SQL 2000: Error 'Row_Number' is not a recognized function name.SQL 2005 to 2012: 10 distinct rows returned, answer should be C.
you should never expect any of our questions...
September 24, 2014 at 10:23 pm
Arrggg, wrong box checked.
10 is correct. I'll award back points tomorrow.
September 24, 2014 at 10:23 pm
You are NOT going to win. change your avatar now, get one where I'm not smiling.
September 24, 2014 at 9:39 pm
Eirikur Eiriksson (9/23/2014)
jcrawf02 (9/23/2014)
September 24, 2014 at 9:00 am
You'd have to write code that builds this string and passes it in. I'm not sure how you're calling this, but you'd need a wrapper that queries your databases, builds...
September 24, 2014 at 8:22 am
Dan Guzman-481633 (9/23/2014)
September 23, 2014 at 8:53 am
Viewing 15 posts - 10,546 through 10,560 (of 39,793 total)