ChrisM@Work (4/9/2013)

---

Thanks.

DROP TABLE #Sampledata

CREATE TABLE #Sampledata (NAME VARCHAR(25), PAYMENT_TYPE VARCHAR(10), PAYMENT DECIMAL(5,2))

INSERT INTO #Sampledata (NAME, PAYMENT_TYPE, PAYMENT)

SELECT 'SUDHIR', 'SAL', 30.3 UNION ALL

SELECT 'SUDHIR', 'ADV', 10.3 UNION...

You're Welcome. 🙂

Arjun Sivadasan (4/4/2013)

---

Hey, I'm not querying any user tables to post DDL. You can run the queries I posted on any database.

Edit: I guess you didn't know that information_schema.routines...

Hi Arjun,

It is good that you are posting such stuff....people can learn from this.

But a lot of people who are here won't be able to understand things just...

ps_vbdev (4/3/2013)

---

Expected reply.

Not a smart arse, just tired off people with misplaced self-worth.

below is an answer from a forum member for the same post

"you can apply an UPDATE based on...

You've always...

ps_vbdev (4/3/2013)

---

stated in my post "When i bulk insert the csv i was using a case statement to apply a points based on the position field".

the logic behind how the...

You can do it using Dynamic sql as follows:

--Setting up Sample Data

Create Table Ex

(

ProductId Int,

name Varchar(20),

familyName Varchar(20),

listPrice Int,

price1 Int,

price2 Int,

price3 Int,...

How do you decide the points??....What's the logic behind it?

Here is a good article with examples about the differences between Intersect and Inner Join.

difference-between-intersect-and-inner-join[/url]

Have posted a reply here :

http://www.sqlservercentral.com/Forums/Topic1435217-392-1.aspx

You might find it useful.

If you have 100 rows to pivot and are not sure about addition...

Is there a relationship between the "Attend" table with the "Terms" table??.....

By what you have shown in the Expected Output it sure seems there is but its not visible in...

You'r welcome Prassh......You are always welcome to post on SSC and learn from here...like we all...

Mark-101232 (4/2/2013)

---

Another one to try

WITH Numbers(N) AS (

SELECT N

FROM ( VALUES(1),(2),(3),(4) ) Numbers(N)),

Recur(N,Combination) AS (

SELECT N, CAST(N AS VARCHAR(1000))

FROM Numbers

UNION ALL

SELECT n.N,CAST(r.Combination + ',' + CAST(n.N AS VARCHAR(10)) AS...