İptal Edildi

Small fix in a Stored procedure for a website developed in [url removed, login to view],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, $[url removed, login to view])

,@totalend = case when isnull(@totalend, 0) = 0 then $[url removed, login to view] 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] > $[url removed, login to view]

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: p1 group, case net, toi, stored, small fix, 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, fix money order, script sql asp, stored procedure script sql, startdate, sql procedure, case sum, max fix, set sql asp, sum price total

İş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 you.You 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