Viewing 15 posts - 2,386 through 2,400 (of 3,221 total)
irobertson - hope you do not mind a little plagiarsm
Like your idea of a cross join, and in my example both the table being searched and the table containing the...
October 13, 2009 at 9:39 am
You will have to create a dynamic T-SQL statement and then execute it.
In this case you pass in the id of the string you are searching for, that could be...
October 11, 2009 at 1:12 pm
Go to this site:
http://www.sqlservercentral.com/articles/books/65831/
Down load the free e-book SQL Server Execution Plans by Grant Fritchey
(1st Edition, June 2008) and read how execution plans can help you to decide which...
October 11, 2009 at 11:17 am
This site contains a T-SQL statement that I believe will provide you with what you require ... it was written by Michelle Gutzait and will produce a report in HTML...
October 10, 2009 at 7:53 am
Garadin (10/9/2009)
--------------------------------------------------------------------------------
"pimp my blog". Nice.
Jack Corbett (10/9/2009)
I'm not sure what else to call it when I reference my own blog. I feel kind of dirty doing it, but I...
October 9, 2009 at 1:28 pm
This might help you:
SET @Str = 'James Murphy;#278;#Leslie Owens;#275;#Rita Sallam;#279;#Stephen Powers;#277;#Susan Feldman;#68'
--CHAR(59) is a ; CHAR(35) is #
SET @Str = REPLACE(@Str,CHAR(59) + CHAR(35),',')
WHILE PATINDEX('%[0-9]%',@Str) > 0
BEGIN
SET @Len...
October 9, 2009 at 1:17 pm
jcrawf02
http://www.ecyclingcentral.com/recycler/program_details.php?ID=1885&state=OH
Or
http://www.ecyclingcentral.com/recycler/index.php?state=OH
Try these sites .. the first link is to a non-profit recycler in Canton OH and lists what they will accept. Now how legit they are I can...
October 9, 2009 at 10:56 am
I still like the more community feel to SSC though
Strongly agree with Jack, way back in the beginning it was what drew me back to this site...
October 9, 2009 at 10:18 am
San-847017
Can anyone help me how to go about it.
How to create huge database ? What are the things I can try for testing purpose ?
How can I simulate diff problems..?....
October 9, 2009 at 9:12 am
Compensation
Compensation will be $50,000 - $65,000 based on expertise and experience.
Heh... so despite the laundry list of required expertise and "nice to haves", you really want an entry level programmer....
October 8, 2009 at 7:30 pm
You might want to read:
Adjusting Transaction Isolation Levels
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9dfc3c68-9bf0-4896-b3b6-d2f1a601ead1.htm
And consider adding a BEGIN TRANSACTION - END TRANSACTION for your update statement.
October 8, 2009 at 10:52 am
Read in Books On Line:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/29ddac46-7a0f-4151-bd94-75c1908c89f8.htm
Or using SSMS right click on Databases, in the next menu click on ATTACH complete the information requested in the next displayed window
October 7, 2009 at 4:14 pm
So much depends on what access you have or could have to the companies accounting system.... or any other system that directly or indirectly would impact on the companies financial...
October 6, 2009 at 2:10 pm
Now here is one I don't know wether to laugh, cry or pray for the employees of his company. I'd call it the incidental DBA in the deep end...
October 5, 2009 at 6:56 pm
To get to 2005 start reading here:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm
Then you can proceed to:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/c10eeaa5-3d3c-49b4-a4bd-5dc4fb190142.htm
Go to the TechNet site:
http://technet.microsoft.com/en-us/default.aspx
and input: Backward compatability SQL 2005 for a rather large selection of references.
Repeat at Technet...
October 5, 2009 at 3:53 pm
Viewing 15 posts - 2,386 through 2,400 (of 3,221 total)