Viewing 15 posts - 26,491 through 26,505 (of 59,102 total)
Mnishar (7/4/2013)
Hi you can achieve this by XMLCheck this out
http://www.sqlblogspot.com/2013/04/convert-rows-into-comma-separated.html
Hi Nnishar,
Consider using GROUP BY instead of DISTINCT. Here's your code with the WHERE clause removed to try...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2013 at 10:03 am
Here's another decent one.
http://msdn.microsoft.com/en-us/library/ff649591.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 6:20 pm
The following MS link should help start you on your way.
http://technet.microsoft.com/en-us/library/ms151196.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 6:15 pm
rajluves (7/3/2013)
Hie,can any one help me what are the steps to b take when database is running slow?
This is a huge subject and runs the full gambit from which hardware...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 6:04 pm
jasona.work (7/2/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 5:39 pm
DBA12345 (7/3/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 4:20 pm
sqlpanther (7/3/2013)
we have issue in our environment where temp db grows very large in 6-8 hrs, the settings are fine and as per standards such as temp db...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 3:53 pm
Ohhhh, be careful, folks. This looks like a trick question that I might write as an "ace breaker" on an example. If you read the original question, it...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 3:22 pm
Welcome aboard, Mr. Sommarskog. Very nice to have you here.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 3:12 pm
manikanta1207 (7/2/2013)
when do we take tail-log backup? and how can we take? wt cmds to be used
This sounds like a series of interview questions. My recommendation is that Gail's...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 3:09 pm
river1 (7/12/2010)
Hi,i am trying to create a xp_cmdshell to execute the DBCC checkDB comand and same the output to a txt file. Can someone help, please?
Thank you.
Please see...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 2:59 pm
Thank you for the coded example. Much appreciated. That's kind of what I thought it was going to be but haven't touched VB since 2002 and didn't want...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 2:53 pm
Steve Jones - SSC Editor (7/3/2013)
We shouldn't have...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 2:40 pm
chauhanparixit (7/3/2013)
use SQLCMD or something.
How do you do that from VB?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 7:56 am
Tara Kizer (7/13/2010)
If you are using a VB application, then there is no need to use xp_cmdshell for this.
Since I'm no VB expert but still very curious, how would you...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2013 at 7:53 am
Viewing 15 posts - 26,491 through 26,505 (of 59,102 total)