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...

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...

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...

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...

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...

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...

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...

Jack Corbett (10/9/2009)

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...

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..?....

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....

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.

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

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...

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...

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...