See this link for Catch-All queries

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Here's an interesting ,well thought out question.

http://www.sqlservercentral.com/Forums/FindPost819872.aspx

Then its subtly different

Declare @Test xml

Select @Test ='<Elem><Child>One</Child><Child>Two</Child><Child>Three</Child></Elem>'

select t.col.value ('.', 'varchar(50)') as Child

from @Test.nodes ('Elem/Child') AS t(col)

Its essentially the offset of the element required

Declare @test-2 xml

Select @test-2 ='<Elem><Child>One</Child><Child>Two</Child><Child>Three</Child></Elem>'

select t.col.value ('Child[1]', 'varchar(50)')as Child1,

t.col.value ('Child[2]','varchar(50)') as Child2,

...

That'll be XML Processing

Declare @test-2 xml

Select @test-2 = '<Candidate><FullName>Neil Vicente</FullName><Email>email1@email.com</Email><Random1>jXzcfm^[[X</Random1><Random2>BGCYNxusZj</Random2><Random3>VHjMjnGZCi</Random3></Candidate>'

select t.col.value ('FullName[1]', 'varchar(50)')as FullName,

t.col.value ('Email[1]','varchar(255)')...

I think that you will run into a myriad of performance issues further down the line

But something like , ive broken it down to show the working but you should...

You seem to of answered your own question, charindex would suit your needs.

This link describes the uses of both Charindex and patindex

http://www.databasejournal.com/features/mssql/article.php/3071531/Using-SQL-Servers-CHARINDEX-and-PATINDEX.htm

BUT if you have XML why are you...

So , is the SQLBits SSC party a Table for one 🙂

Migrate from what or to what ?

Either way, i very much doubt it.

Try this link

http://jetlounge.net/blogs/teched/archive/2007/12/17/common-ssrs-url-commands.aspx

Hi ,

you havent really give us much to go on.

All you have said is that you call a SP and it performs poorly.

No matter how 'simple' it is there is...

As eddy has suggested above, have you tried using full text searching ?

Thats a habit im trying to pick up , but obviously failing 🙂

Ummm, you have given no details so this is a complete guess

Create procedure DeleteProc

as

Delete top 10000

from <yourtable>

go

And create a job to execute it in sqlagent

This is exactly why transactions are needed.

Google is your friend (1st result from "VB.NET sqlserver transaction")

http://articles.techrepublic.com.com/5100-10878_11-5766653.html