sql-lover (8/18/2012)

---

Hmmm...

I am not working today, but several GBs ... over of 10 millions rows, off top of my head.

I do not remember the numbers exactly, but it...

how big is "big" ??

row numbers

columns numbers

file size

index size

??

SELECT Id, AVG(Amount)

FROM #TempMid

GROUP BY Id

asranantha (8/16/2012)

---

how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other...

laurie-789651 (8/15/2012)

---

I read it as: the book/page/entry data refers to the original hand-written books, and the data is just required to print on the certificate so it can be referred-back...

priest Ivan Delic (8/13/2012)

---

Hi!

I forgot one thing. In paper-data there is about 30 books with 100 pages in each of them. On each page there is 10 records, so 1,000...

I think I may now understand what you are trying to do....but there again I may well be completely wrong!

You have a "printing application" that requires a table as its...

possibly another way....assuming you want a random image returned.

does this return what you want?

declare @cattyp varchar(3)='cri'

;with cte as

(

SELECT alid ,

imageid ,

...

rVadim (8/12/2012)

---

The OP included Id in the list. So, i thought s/he wants totals by Id, not over all table. So, which is...

suggest you search this site for "concatenate rows", crosstabs / pivots

one method that will do as you ask is by using "FOR XML PATH"

here is an example

with produce (id,fruit,...

try removing the GROUP BY

SELECT TotalCost = SUM( Cost ) ,

Cost0 = SUM( CASE WHEN Code = 0 THEN Cost END )...

Hello sivag

would you care to share the solution you found please?

This may well assist othesr in...

Hello

could you please provide some sample data for each of your tables and also what results you are expecting, based on the sample data, once they are all put into...

just an idea ...anywhere close to what you require?

CREATE TABLE [dbo].[Table_1](

[ID] [int] NULL,

[Val] [varchar](1) NULL

) ON [PRIMARY]

INSERT INTO [dbo].[Table_1]([ID], [Val])

SELECT 1, N'A' UNION ALL

SELECT 2, N'B' UNION ALL

SELECT 3, N'C'...

ashwinrao.k23 (8/10/2012)

---

Here is the scenario please..

For exmaple if i have the fields like below

File Main ...