Its Solved i use temp table

Thanks

it take 20 seconds and  results get after

can any one provide me a query

thanks for the help

hi,

i try count function + datename function and also datediff function but no use.

i cant merge same dates

please help me out

thanks for the help

select cast(c.evs_OrderIDid as UNIQUEIDENTIFIER) , cast(b.ORdernumber as UNIQUEIDENTIFIER) from evs_ccagentCodes c

left join [salesorder] b on c.evs_OrderIDid = b.ORdernumber

still giving m error

sorry

code-----name-----a.evs_CodeUsed

ACT------199------------1

CDF------198------------2

DNC------199------------1

FAI-------197------------3

FNC------198------------2

thanks 4 the help.

i fix it

and i just want that if i didnt give date parameter and i use voucher no parameter then result gives me result from voucher number

ALTER procedure [dbo].[vocuher]

@VoucherNo...

my data is like this

1st table VoucherMaster

VoucherTypeCode---VoucherNo-----VoucherDate----Narration

JV----------------13140001------2013-03-26-----Sale Summary Closed.

JV----------------13140002------2013-03-26-----Sale Summary Closed.

JV----------------13140003------2013-03-28-----Stock Transfer

JV----------------13140004------2013-03-28-----Sale Summary Closed.

----------------------------------

2nd table VoucherDetail

VoucherTypeCode----VoucherNo

PU-----------------13140001

PU-----------------13140001

PU-----------------13140001

PU-----------------13140002

PU-----------------13140002

------------------------------------

3rd table VoucherType

VoucherTypeCode-----VoucherType

JV------------------ADVANCE VOUCHER

BP------------------BANK PAYEMENT VOUCHER

JV------------------BANK RECEIVED VOUCHER

PU------------------Client Order

CP------------------CASH PAYMENT VOUCHER

thanks for the help

i am searching but its give me manually database backup actullay

please provide me the script i have sql server 2005

and this is the info

Microsoft SQL Server Management Studio Express-----------9.00.2047.00

Microsoft Data Access Components (MDAC)-----------------2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML------------------------------------------2.6 3.0 4.0 5.0...

YES , we r making this type of software your jugement is right,and we make 75% software complete.can u help me out on this one

Thanks

ok but is only sa user name and password is enough protected by hackers.

means can any one hack my sa password

thanks for the suggestion

is there any way to protect your table or your stored procedures ?