domingo.sqlservercentral (3/26/2014)

---

... and I need this rows concatenated as below:

2014-03-25 12:31:00.000StationIDAnnie LennoxDave StewartEurythmicsDave StewartEMI1IDshortinfo

2014-03-25 13:33:00.000TrafficBob Dylan, Louis ArmstrongPaul McCartney, Bob DylanGlenn Miller, Pet Shop BoysWarner2TRAFFICshortinfo

2014-03-25 14:38:00.000CarpetPaul McCartney, Bob Dylan, Mike...

Sean Lange (4/4/2014)

---

Well you gave us a bunch of data and said "here is my results". Results of what? Presumably a query.

The problem is that...

what is your definition of "managing".....??

Glad to hear you solved the issue.

for...

have you looked at the T-SQL CASE statement....this may provide what you require

would help if you could provide DDL...(do you know how to do this?.....create table statement / insert data statement)

what is the significance of the "TYPE" code...you provide "A","B","P"...does this mean...

are your billed amounts and payment amounts/adjustments in separate tables?

can you provide more details on the table structure (DDL create statememts)

ivar_SQL (3/23/2014)

---

Thanks for the response...

Here Michael has total 26 Business points for his total trips and based on that he should get 6 promotional points for the first 20...

a proof of concept on 1 million rows of test data

USE [tempdb]

GO

/*Drop and Create a test table */

IF OBJECT_ID('tempdb..tblRedeems_TST', 'U') IS NOT NULL ...

ivar_SQL (3/23/2014)

---

Hi,

I am working on a rewards program and I have a table whenever customer completes a trip, his total fare,business points earned for that particular trip and respective...

for clarification...are you asking for an update on business/promo points on the entire table or are you expecting that points will be automatically calculated on a new row being...

food for thought.......note index

SELECT TOP 5000000

TranID = IDENTITY(INT, 1, 1)

INTO Table1

FROM ...

sample data would help us help you....do you know how to provide this?

SELECT house_no

FROM <yourtable>

ORDER BY REPLACE(house_no, '-', '')

you have asked this question numerous times......can you please explain why the solutions provided have...

have we been here before ???

http://www.sqlservercentral.com/Forums/Topic1520462-3077-1.aspx