Viewing 15 posts - 2,731 through 2,745 (of 5,590 total)
Senthil T (10/25/2010)
I have this query where I build the where clause dyncamically based on user criteria selection, and return the total number of matches.
SELECT count(*) FROM tblGeneralInfo T1
INNER...
October 25, 2010 at 3:17 pm
rmechaber (10/25/2010)
WayneS (10/24/2010)
October 25, 2010 at 3:12 pm
Jeff Moden (10/24/2010)
WayneS (10/13/2010)
bhushan.bagul (10/13/2010)
thanks for your reply!!!Glad to be of help. Does it work right for you?
Heh... don'cha just love it?
Exercising my brain: yes.
Lack of feedback: no.
October 24, 2010 at 8:29 pm
Does anyone know how to expand a VMWare virtual disk, and have it properly show up in an XP guest OS? If so, please help me out here.
Thanks!
October 24, 2010 at 11:43 am
gmrose (10/23/2010)
Out of curiosity, how many records are you processing? And did you try out the script that I posted?
Wayne
Thank you (and all of the others) for your suggestions....
October 23, 2010 at 5:51 pm
Oksana March (10/23/2010)
And could someone please explain what you mean by "parameter sniffing"? Thanks!
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/[/url]
October 23, 2010 at 3:07 pm
Tom.Thomson (10/22/2010)
WayneS (10/22/2010)
Alvin Ramard (10/22/2010)
October 23, 2010 at 5:38 am
Chandu-212374 (10/23/2010)
Normally on a default instance of SQLServer, to create login from command prompt i use:
USE master
GO
CREATE LOGIN [domainname\uname] FROM WINDOWS WITH DEFAULT DATABASE=master.
But from command prompt I want to...
October 23, 2010 at 5:33 am
Craig Farrell (10/22/2010)
WayneS (10/21/2010)
Here is the latest version of the Delimited Split FunctionDelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
You're...
October 23, 2010 at 5:17 am
CELKO (10/22/2010)
Shameless plug for my SQL Puzzles & Answers bookhttp://www.elsevierdirect.com/product.jsp?isbn=9780123735966
Joe,
I actually went to this site to check out what was in the book. The TOC gives a high-level by...
October 22, 2010 at 3:27 pm
Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
I...
October 22, 2010 at 3:20 pm
wardy (10/22/2010)
October 22, 2010 at 10:55 am
Sacheen (10/21/2010)
Instead of handling this in report using expression, if you are not using this dataset anywhere in report then why don't you handle it on sql part only.
Assuming you're...
October 21, 2010 at 9:41 pm
Simon-413722 (10/21/2010)
Hi,I'm just wondering if you could register and take MCITP exam and skip MCTS?
October 21, 2010 at 9:38 pm
Jeff Moden (10/21/2010)
Paul White NZ (10/19/2010)
Jeff Moden (10/19/2010)
October 21, 2010 at 9:29 pm
Viewing 15 posts - 2,731 through 2,745 (of 5,590 total)