Hi,

This code may help you

create table Customer_Bill_Table

(

[CustmoerNO] VARCHAR(3)

, [productname] VARCHAR(15)

, [billeddate ] VARCHAR(15)

)

INSERT INTO Customer_Bill_Table([CustmoerNO],[productname],[billeddate ])

SELECT '50','Milk','10/4/2013' UNION ALL

SELECT '50','Milk','11/4/2013'UNION ALL

SELECT '50','Curd','15/4/2013'UNION ALL

SELECT '50','Curd','15/4/2013'UNION ALL

SELECT '50','Biscuit','14/4/2013'UNION ALL

SELECT '50','Biscuit','16/4/2013'UNION ALL

SELECT...

Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.

Hi,

It is not working for sql server 2000

yes..

i no............

Thanks for your reply sir

SQL 2000

Im getting the error while running the query

Server: Msg 8101, Level 16, State 1, Line 7

An explicit value for the identity column in table '@student' can only be specified when...