Hi Friends,

as example:

create table Customers

(

companyname varchar(10),

invoice_locn varchar(20),

invoice_no varchar(10),

model_ref varchar(20),

item_type char(20),

item_no int,

invoice_qty int

)

insert Customers values ('VB','chennai ','tn/002/13-14','#','K','6000320','25')

insert Customers values ('VB','chennai','tn/002/13_14','6000320','X','500320','30')

insert Customers values ('VB','chennai','tn/002/13_14','6000320','X','500300','05')

insert Customers values ('VB','chennai','tn/002/13_14','#','I','500340','25')

like i ve...

Hi Freinds,

thanks for ur reply,

if suppose mt table looks like

create table tab

(

Bill_no,

ref_group,

product,

qty

)

insert into tab(BillNo,ref_group,product,qty)

values ('24','Milk Produtcs','Butter','05')

insert into tab(BillNo,ref_group,product,qty)

values ('24','Milk Produtcs','Curd','25')

insert into tab(BillNo,ref_group,product,qty)

values ('24','Dhal...

its correct twin .devil

Hi friends,

as the same table how to separate lowest value only.

Hi dwain.c,

Thanks for ur reply.....

i need the o/p like each item wise (i.e you wrote the code for max item ,

now each item should...

Hi,

Thanks For Sharing Ur Knowledge.Its Working GOOd

How write the same code in sql server 2000

Hey Sri ,

Lets Consider table like

create table Bill_max

(

bill_no int,

cust_det int,

product varchar(20),

Price int,

bill_date datetime

)

insert into bill_max(bill_no, cust_det,product,prize,Bill_date) values('25','ram','Milk','25','01-apr-2013')

insert into bill_max(bill_no, cust_det,product,prize,Bill_date) values('25','ram','Perfume','150','01-apr-2013')

insert into bill_max(bill_no, cust_det,product,prize,Bill_date)...

Thx Friend,

If suppose i m expect EXCEPT o/p in sql server 2000 how to that?

or any other replacements are there for INTERSECT & EXCEPT

i need the output like

for example 2013-04-01 is in table my expectation output is 04-2013 (extract month with year)......

custoproductvalno.of.mon

10Friut 1300 1

10Milk 2900 2

30Milk 6000 2

i wanna calculate...

ChrisM@Work,

can't process ur code becz i ve more than 5 lakh data 's from year wise of '2007 to 2013' date wise bills

here i can such example

create table estr

(

custo int,

product varchar(20),

val int,

billed_date datetime

)

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-04-11','2000')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-04-21','500')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-05-05','100')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-05-11','2000')

insert into estr(custo,product,billed_date,value) values('10','fruits','2013-05-11','500')

insert into estr(custo,product,billed_date,value) values('30','fruits','2013-04-11','2000')

insert into...

hi friends,

thanks for giving the reply to me.

as my scenario is to calculate no.of. months in that table. (for example milk is billed on more than 3 times...

like above my requirement is these procedure correct ah?

alter procedure save_draft

(

@username varchar(20),

@departure datetime,

@request int,

@error Varchar(100)=null output

)

as

begin

declare @userid varchar(20)

select @userid=user_id from users where...