Hi, I had a feeling that I had forgotten something important about the XML method...then I remembered...

My revised code (suitable for the test harness):

PRINT 'XML (Mister Magoo)'

SET STATISTICS TIME ON

SELECT...

murthyvs (12/16/2012)

---

Hi - this a nice method. didnt know this before.

I have created this function and using it in a stored proc..

Function call in the stored proc: select * from...

Thanks for the kind words Jeff, and thanks for spotting my mistake.

I am not sure that col6...

Here's a way that uses XML, which you could generate in the web application before passing the data to SQL, or even just convert to XML and pump straight into...

A bit late to the party, but this cries out for a bit of "bad practice"...(SELECT *)

-- drop the temporary table if it already exists

if object_id('tempdb..#sample') is not null...

As you don't mention exactly what you are trying to achieve, it is hard to give a definite answer, but my guess from your desire to see the date as...

SELECT * FROM @T WHERE NAME IN('XYZ','AAA','PQR')

ORDER BY CHARINDEX(NAME, '.XYZ.AAA.PQR.') ...

eidjazparwaz (12/7/2012)

---

Hi mister.magoo,

I see you have been quite busy with developing. This add-in looks really (:w00t:) nice and really handy. If you need some volunteers to test this add-in i...

Hi there, sorry for the long delay,...

And another...but it does involve two tables scans, so I wouldn't recommend it...

SELECT currencypair

, ccy1

, ccy2

FROM

currency

, off_currency_pair

WHERE charindex(ccy1, currencypair) * charindex(ccy2, currencypair) = 4

As is becoming a habit, I would like to offer up my Identity Hack - rCTE replacement...

It performs quite nicely and doesn't suffer from the dupes problem I have...

Hi Paul,

I think there...

You are welcome.

Because you don't care which are deleted, you can use a CTE with a row number:

Something like this:

;WITH dupefinder AS

(

SELECT

OwnerID,

TimeAccountID,

ROW_NUMBER() OVER(PARTITION...

Yes, use an IF in the expression as I said...

=IIF( Weekday( Today(), FirstDayOfWeek.Monday ) = 1,

Dateadd( "d", -2, Today() ), Dateadd( "d", -1,...