You can use a Dynamic Pivot as follows:

--Creating Tables

Create Table Ex

(IDint,

rbNumber int,

rbTypevarchar(20),

rbBookdatevarchar(20),

rbBookTypeChar(1),

rbBookRef varchar(20) )

--Inserting Sample Data

Insert Into Ex

Select 403,7,'Standard Double','02 June 2012','B','447361938'

Union ALL

Select 402,7,'Standard Double','01...

You can do it like this:

Select a.year, a.week, SUM(a.total_savings) From

(Select * From Ex

union

Select * From Ex1) As a

Group By a.year, a.week

Here are a few versions of doing it:

--Creating Table

Create Table Ex

(cusid int,

name varchar(3),

email varchar(20) )

--Inserting Sample Data

Insert Into Ex

Select 111,'abc','abc@xyz.com'

union ALL

Select 222,'aaa','aaa@xyz.com'

union ALL

Select 222,'aaa','aaa1@xyz.com'

union ALL

Select 222,'aaa','aaa2@xyz.com'

union ALL

Select 222,'aaa','aaa3@xyz.com'

union...

In that case you can use any of the ways.

If you use TSQL, you would have to make sure to do it at some time...

Sorry, I fail to understand the logic used for your output. Why isn't "TRU-90-JK" in the output? And why do you have so many rows for "YTH-12-MU"?

Are you using MSSQLServer??.....Doesn't look like it to me

Sorry, one of us is missing out on something. What is the problem???....How do you want your resultset to look like?

If the Database at the Primary Server gets updated every 2 seconds and you want the Db at the Secondary Server also to get updated the may be you should...

I have Office2003. It says File Format Not Recognized when I try to open your attachment.

I'll make this as simple as I can.

You are looking at some tables and some...

Is it a one time Requirement or a Regular thing??....If it is a one time requirement then...

rVadim (6/5/2012)

(S)he probably runs your entire code...

I checked it agaiun...

Like This:

--Creating Tables

Create table Ex

(empno int,

empname varchar(30),

empsalint,

Rownum int )

Create table Ex2

(empno int,

empname varchar(30),

empsalint,

RowNum int )

Create table Ex3

(empno int Identity(300,1), --Create...

Well, I can't see from here what data you have in your tables to know what your query is doing.

For me to give an opinion there needs to be sample...

ankita.vinculum (6/5/2012)

Thanks for ur rep.

Is this ur link - "How to post data/code on a forum to get the best help" - Jeff Moden

I had tried to open this...