Hi friends,

That code is working if my expected output is like below what do to

invoiceno   cust_name invoice_docvalu      taxable_value   IGST_value               CGST_value         ...

my expected output is 

invoiceno        cust_name   invoice_docvalu     taxable_value         IGST_value   CGST_value      SGST_value           HSN

Hi Friend,

My Expecting Reply  is

cust no  loc   3yearsNotbilled       2years not billed 1year no billed

Hi Friends,

Without setting a financial year start and end date I wanna get the output

i.e

the user takes a report from '01-jun-2010' and '30-jun-2010' (only input from the...

Hi Friends,

create table test

( Block int, ...

Hi Twin Devil,

Here Some Of the accounts are manually defined in sales and maintenance after the...

Hi Friend

In MSSql2000 wont allow Pivot

Hi Friends ,

i just added my code with rollup

select

fs_locn,

fs_accno,

fs_cost_center,

amount=sum(case when fs_accno like 'E%' and fs_tran_type='Dr' then fs_amount

when fs_accno like 'E%' and fs_tran_type='Cr' then fs_amount * -1

end

)

from...

Hi Friends,

The costcneter account wont be changed always same account and unique

Hi friends,

i need the output like

Accno 205produ 206produ 208produ total

E-SW-2100 15000 ...

Hi Friends

i need out put like

for exmaple :

account no 205prod 206prod total

E-SW-100 10000 ...

Hi friend,

Here one problem is there

my table contains the info authorized date also

i.e

create table expense

(

bill_date datetime,

travel int,

fixed int,

food int,

lodge int

)

insert into expense values('01-04-2014 00:00:00',1200,250,0,0)

('02-04-2014 00:00:00','0',0,500,600)

('0-04-2014 00:00:00','800',300,0,0)...

Hi ,

i m doing web application on google maps depends lat,long ll show marker on map

create table location

(

id int identity,

city varchar(20),

lattitude float,

lontitude float

descn

)

insert into locations values('chennai','13.062','80.641','Welcome to chennai')

so when...