Wow, Gianluca.. cool code.. 😎

Again, without seeing your BREED table and K9 table how are we to assume what data is in, where you are going wrong and what we can do for you.

Please...

I din't understand your requirement clearly; But stil, as far as i understood, here is a piece of cdoe that might interest you.

Look at how i am posting the data...

Chris Morris-439714 (5/11/2010)

---

"The bracketing in the calculation looks dangerous to me - I'd check that this is providing you with the results you expect."

Can you post a sample table script...

Subhro,

There is a REPLACE operation followed by the CAST in my code.

REPLACE will replace a set of characters , with a replacement value , on the string in which...

Subhro, you probably have not used my edited code.. please run my code in my prevoius post (i have updated it) and check with your dsired result! THe first image...

Subhro, you need to first strip the occurence "cnt" using string functions like "STUFF" or "REPLACE" or "SUBSTRING" and then type-cast. Here is a code that will produce the result...

Manju, as i promised, here is the script ; U can run this from Query Editor itself

SET NOCOUNT ON;

DECLARE @SCRIPTS TABLE (SCRIPT_NAME_LOCATION VARCHAR(100))

INSERT INTO @SCRIPTS

EXEC master..xp_cmdshell 'dir /b /s...

Manju, replace %LOG% location with something like "C:\Temp\Logfile.log"; This...

Hi, there is something called OSQL utility which allows us to run .sql files from the command prompt. So , what you can do is,

1. Do a "DIR" on...

To add to Mark's reply, you have to use ISNULL with NULLIF to get that replacement of 0 to 1; like

ISNULL( NULLIF(oe_line.unit_price,0) , 1)

Cheers!

Modesty is your virtue!:-)

Nagesh S-432384 (5/7/2010)

---

I am sorry ColdCoffee I pointed my reply to Jeff whereas you are the one who wrote the code... I started participating on this forum frequently which is...

This will get you there!

;WITH CTE AS

(

SELECT ROW_NUMBER() OVER(PARTITION BY SIZE ORDER BY ID) RN , ID, SIZE FROM @table

)

DELETE FROM CTE WHERE RN <> 1

Hope this helps!

Cheers!

Gian's code is fast and furios 🙂 that should do!