Look at BOL: http://msdn.microsoft.com/en-us/library/ms188001(v=sql.105).aspx

Does the first example on that page do what you want?

If not, perhaps I'm misunderstanding.

rhythmk (8/17/2012)

---

raghuldrag (8/17/2012)

---

hi friends,

create table emp(ename varchar(34),job char(33),sal varchar(22))

insert into emp values('sa','sales','400')

insert into emp values('ka','manager','4000')

insert into emp values('sam','Markting','2500')

insert into emp values('sabu','system','3900')

in these table model i ve a report now...

SomewhereSomehow (8/17/2012)

---

If we speak for performance aspect, I think it is not parse name, rather it is replace impact,...

Here's another way that is a bit faster than using PARSENAME.

SET NOCOUNT ON;

--== SOME SAMPLE DATA ==--

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

CREATE TABLE #testEnvironment

...

The quality of the hires will be roughly proportional to the quality...

ChrisM@Work (8/16/2012)

---

Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

Not sure of the name though. Symba is a bit silly, it’s a misspelling of...

As a great Jedi once said: "Do, or do not, there is no try..."

SET NOCOUNT ON;

--== SOME SAMPLE DATA ==--

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

--1,000,000...

rajawat.niranjan (8/15/2012)

---

Thanks dwain.c

I have following queries regarding this:

1. Here I don't have all parameters compulsory except city, so if i use this single query every time I will be join...

Eugene Elutin (8/15/2012)

---

First thing I would do is de-noodling the code so it can be readable:

a.) Format with proper indenting of code between BEGIN and END

b.) Remove the hoard of...

I have and I can't account for why it happens, just that it does:

http://www.sqlservercentral.com/Forums/Topic1338934-3122-3.aspx

Lynn Pettis (8/15/2012)

---

Jeff Moden (8/15/2012)

---

If it were a prerequisite for speaking, I'd...

I even remembered to use MAXDOP...

Don't think for...

SET @strCountry = 'Sweden,Portugal'

(@strCountry = '' OR (co.CountryDefaultName IN (SELECT Item FROM dbo.DelimitedSplit8K(@strCountry, ',')) and co.CountryStatusID = 1))

DelimitedSplit8K can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

I find that these XML questions are never as easy as they first seem to be.

DECLARE @xml XML

SELECT @xml =

'<row id="VFAL.2312" xml:space="preserve">

<c1>DETAIL</c1>

<c2>VFAL.2312</c2>

<c2 m="2">272101-01</c2>

<c2 m="3">AIR DLG-DOUBTFUL LOAN...