Member Avatar for Tank50
Tank50 2 Junior Poster

Hi

I wrote simple query like

select Code,CashDeposited,Date from dbo.RDBankingDetails where Code='SE0001'  group by Date,Code,CashDeposited

It generate report like below
TE0001 12000 2005:03:26
TE0001 49150 2005:03.26
TE0001 209000 2005:03.26

I want to generate the report like below
Code Date CashDeposisted1 CashDepostis2 CashDeposists3
TE0001 2005:03:26 120000 49150 209000

In above CashDeoposisted are change,not a same value always

Pls tell me how to do this.

Thanks

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.