Viewing 15 posts - 1,516 through 1,530 (of 7,636 total)
It's not my area, but I do know that it is very dependent on what is running on your Webserver, especially if it connects to your SQL Server. Also,...
September 28, 2009 at 3:45 pm
Try this:
SELECT *
FROM YourTable t1
WHERE EXISTS(
SELECT *
FROM YourTable t2
WHERE t1.[Member id] = t2.[Member id]
...
September 28, 2009 at 3:27 pm
Matt Whitfield (9/28/2009)
RBarryYoung (9/28/2009)
Matt Whitfield (9/28/2009)
RBarryYoung (9/28/2009)
Matt Whitfield (9/27/2009)
But don't come in and say 'your test case is a stupid example'...
I didn't say anything like that, Matt. Please don't...
September 28, 2009 at 1:19 pm
Silverfox (9/28/2009)
http://www.sqlservercentral.com/Forums/Topic793172-9-1.aspx
What is the point of answering a question with something that needs...
September 28, 2009 at 11:39 am
Matt Whitfield (9/28/2009)
RBarryYoung (9/28/2009)
I didn't say anything like that, Matt. Please don't try to put words in my mouth, that's not right.
'unprofessional drek' roughly equates to 'stupid example' in...
September 28, 2009 at 11:31 am
Matt Whitfield (9/27/2009)
BarryThat's a test case.
Yep. And I supplied the SOP solution to a case like that. I am not going to spend my time trying to...
September 28, 2009 at 10:27 am
Matt Whitfield (9/27/2009)
WILLIAM MITCHELL (9/27/2009)
That of course is a ridiculous example.
No, it's just a test that covers a few edge cases, and breaks every code sample you've posted.
If you've never...
September 27, 2009 at 3:12 pm
Garadin (9/27/2009)
September 27, 2009 at 3:01 pm
markjvernon (9/25/2009)
Self-generating code is not a good thing. Non-ecsaped string data will cause you pain and maintaining the code will be terrible.
Sorry, but I would have to disagree with...
September 25, 2009 at 9:36 am
Jeff Moden (9/23/2009)
RBarryYoung (9/23/2009)
Great article, Lynn! I might finally be ready to stop cross-joining master..syscolumns. 🙂I already quit... heh... I use Master.sys.All_Columns now. 😛
Heh. I try to...
September 23, 2009 at 4:42 pm
Bhavesh-1094084 (9/23/2009)
RBarryYoung (9/23/2009)
Bhavesh-1094084 (9/23/2009)
Using Exists is must better...
September 23, 2009 at 2:20 pm
Great article, Lynn! I might finally be ready to stop cross-joining master..syscolumns. 🙂
September 23, 2009 at 1:42 pm
Bhavesh-1094084 (9/23/2009)
Using Exists is must better approach against...
September 23, 2009 at 1:11 pm
RBarryYoung (9/23/2009)
Matt Whitfield (9/23/2009)
I can create this on my 2000, 2005 and 2008 instances. Not invalid syntax at all. Of course - i did replace the 'schema'...
September 23, 2009 at 1:05 pm
Viewing 15 posts - 1,516 through 1,530 (of 7,636 total)