Your requirement is not clear. How do you determine which value should you enter?

You should post DDL and sample data in a consumable format so we don't waste time on...

I believe that this article explains better this situation

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

The article is really interesting and worth reading but the conclusion is this:

"Most importantly, NOT...

How about thinking you need the first 11 but you need to discard the first 9. How do you discard rows? EXCEPT, NOT IN, NOT EXISTS, OUTER JOIN?

Really bad attitude.

Something like this?

CREATE TABLE CHG_ITEM(

CHARGE_BATCH_ID int,

CHARGE_ITEM_IDint,

REVENUE_SITE_IDint)

INSERT INTO CHG_ITEM(CHARGE_BATCH_ID, CHARGE_ITEM_ID, REVENUE_SITE_ID)

VALUES

(1, 15929, 1000),

(1, 16930, 1000),

(10, 17186, 2000),

(10, 18187, 5000),

(10, 22188,2000),

(22,...

Assuming you have a Tally table you can try this:

DECLARE @Start_year int, @End_Year int;

SET @Start_Year = 2011 ;

SET @End_Year = 2013;

SELECT STUFF((

SELECT '/' + RIGHT( CAST( N AS varchar(4)),...

Using your examples:

( 'Ab','BC',CD') are non-Unicode strings (char/varchar)

(N'Ab',N'BC',N'CD') are Unicode strings (nchar/nvarchar)

The datatypes are differents and the clearest example of it is that a char(1) uses 1byte and nchar(1) uses...

2 word: Implicit conversion

SQL Server needs to do implicit conversions that may affect the query performance.

That's the same question I ask...

Would it be a problem with leading spaces (instead of trailing spaces)? Maybe hard spaces or tabs.

:O) (12/31/2012)

---

If the point of PIVOT is to help turn row based values into column based values, how do I use it to produce the same results as the approach...

I don't get it. What are your expected results?

Bhuvnesh (12/31/2012)

---

Yes, i have also heard this so many times that RBAR gives the result in much optimal way btu BAD thing is i never got any chance to use...

As others have said, neither CURSORS or WHILE LOOPS are effective. Here's a better solution that might help with this problem. I'm just publishing this to avoid that others would...

Now, that makes sense. 😉