İptal Edildi

Small fix in a Stored procedure for a website developed in ASP.NET,c# and SqlServer

USE [*****]

GO

/****** Object: StoredProcedure [dbo].[dd_admin_tmporder_list_v20120724] Script Date: 04/15/2013 11:47:55 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[dd_admin_tmporder_list_v20120724]

@totalbegin money

,@totalend money

,@perpage int

,@pageno int

AS

declare

@strtotalbegin varchar(30)

,@strtotalend varchar(30)

,@strperpage varchar(10)

,@strpageno varchar(10)

,@strnumrecs varchar(10)

select

@totalbegin = isnull(@totalbegin, $0.0000)

,@totalend = case when isnull(@totalend, 0) = 0 then $922337203685477.5807 else @totalend end

,@perpage = isnull(@perpage, 30)

,@pageno = isnull(@pageno, 0)

;with orderlist as (

select ROW_NUMBER() over (order by [url removed, login to view] desc) as RowNum

,[url removed, login to view]

,[url removed, login to view]

,RTRIM([url removed, login to view]) + ' ' + RTRIM([url removed, login to view]) + [url removed, login to view] as custname

,RTRIM([url removed, login to view]) + ' ' + RTRIM([url removed, login to view]) + [url removed, login to view] as repname

from (

select [url removed, login to view]

,[url removed, login to view]

,[url removed, login to view]

,[url removed, login to view]

,case when isnull([url removed, login to view], '')='' then '' else ' of ' + rtrim([url removed, login to view]) end as bizname

,[url removed, login to view]

,[url removed, login to view]

,case when d1.phonerepid=1 and [url removed, login to view] > 1 then '' else ' (Temp)' end as tempstatus

,[url removed, login to view]

from (

select [url removed, login to view]

,max([url removed, login to view]) as lastadd

,sum([url removed, login to view] * [url removed, login to view]) as total

from [url removed, login to view] toi1 with (NOLOCK)

where [url removed, login to view] > $0.001

group by [url removed, login to view]

) toi

inner join dbo.dd_rm00101 d1 with (NOLOCK) on [url removed, login to view] = [url removed, login to view]

inner join [url removed, login to view] r1 with (NOLOCK) on [url removed, login to view] = [url removed, login to view]

inner join [url removed, login to view] p1 with (NOLOCK) on (([url removed, login to view] = [url removed, login to view] and [url removed, login to view] 1))

where [url removed, login to view] > @totalbegin

and [url removed, login to view] < @totalend

) t

)

select [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]

from orderlist ol

where [url removed, login to view] between (@perpage * @pageno + 1) and (@perpage * (@pageno+1))

order by [url removed, login to view]

GO

Beceriler: .NET, C# Programlama, Yazılım Mimarisi, SQL

Daha fazlasını görün: price for a website, p1 group, c for int, case-net, case net, toi, stored, small fix on, net sql script, website sqlserver, asp small script, sql select order, sql select script, sql int date, website temp, temp website, website sql end, max net, sql script net, posting ads website projects developed asp net, framework creating asp net human resources management website, current website bug fix asp net shopping cart source code, asp net project sample classifleds website, asp net online hotel reservation website coding, asp net online book store website

İşveren Hakkında:
( 4 değerlendirme ) new delhi, India

Proje NO: #4431070

6 freelancer bu iş için ortalamada 44$/saat teklif veriyor

customizedata

Please provide the requirements of what stored procedure should do that it is not doing...

8$ USD / saat
(113 Değerlendirme)
5.7
smartdatasoft

i am ready to do this please start.

12$ USD / saat
(109 Değerlendirme)
5.6
d0tnet12

Hi, i can develop this for [url removed, login to view] will find me on skyp,e : bujhbe

200$ USD / saat
(3 Değerlendirme)
2.5
vasubharadwaj

benchmark in quality..thanks for samples contact me

22$ USD / saat
(0 Değerlendirme)
0.0
jayakumarth

hi, i am ready to work on this,

5$ USD / saat
(0 Değerlendirme)
0.0
jdksl

Please provide deatils.

15$ USD / saat
(0 Değerlendirme)
0.0