David Kranes (7/3/2008)

---

Yes you are correct. But this works fine.

DECLARE

@DBName VARCHAR(100),

@sql NVARCHAR(4000),

SELECT @sql = N'use...

Heh... It's the helmet, Barry... ya gotta remember to plug in the O₂ 😛 Can't do it all on just coffee, ya know? :w00t:

New Commer (7/3/2008)

---

Hi There!

i have a query like this,

Select Distinct Table1.name, Table1.Code, Table2.Place, Table2.Marks From Table1 inner join Table2 on Table1.code = Table2.code

which results,

Name1/N1/Nagpur/114

Name1/N1/Nagpur/154

Name1/N1/Nagpur/123

i want it to display as

Name1/N1/Nagpur/114

...

I agree that formatting for display should, indeed, be done in the GUI.... BUT, gosh, you really need to be sure...

Heh... yeaup... we've all been there.

My problem is that I end up double and triple checking my query, find out that it's spot on, and that someone really did screw...

My personal feeling is that Tony just doesn't like writing stored...

That's a great thing to say... but, even...

rbarryyoung (7/3/2008)

---

Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).

As for...

Maybe THAT'S where you should use a cursor! 😀

GilaMonster (7/3/2008)

---

Phil Factor (7/3/2008)

---

Gail,

I'm so pleased you got the recognition. I'm a great fan of your forum entries. I was trying to find my favourite one of all, in which...

... and we STILL need to know how often the data in the hierarchy will change... 😉

Yep... that's what I use...

There are several ways and some depend on the condition of the data. The way with the most performance is Bulk Insert... I recommend you take a look at...

Jeff Moden (7/3/2008)

---

Nah... I'd get it wrong... I think I...

JJ B (7/3/2008)

---

Jeff: You comments about using the wait has me thinking. (Always dangerous.) I understood why one would break up a delete of a lot of...