I Have this Complex Stored Procedural

5 New Member

I Have This this Query
---------------------------------

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER proc [dbo].[spVoIPCalldetai lMeraPartitione d]
@userId int=null, -- filter: user id. overrides custid when supplied
@custId int=null, -- filter: customer id
@vcsId int=null, -- filter: status
@vdsId int=null, -- filter: destination id
@beginDt datetime=null, -- filter: begin date of call
@endDt datetime=null, -- filter: end date of call
@srchFor nvarchar(100)=n ull, -- filter: searches all result fields for given text
@sortBy varchar(200)=nu ll, -- order by comma-seperated sort fields
@qryMode int=1, -- 0=details 1=grandtotal 2=accountcode 3=DialCode 4:carrier 5=Country+Break out 6=callmonth 7=calldate 8=dayofweek 9=hour 10=vendor 11=Country 12=Country & Mobile Carrier
@detailMode int=null, -- one of above qryMode values for which detail is requested
@detailFilter nvarchar(500)=n ull, -- grouping filter for detail view
@vendor varchar(10)=nul l, -- grouping filter for detail view
@vendorUserId varchar(10)=nul l, -- grouping filter for detail view
@systemid varchar(3)=null -- grouping filter for detail view
as

-- set local variables
declare @q varchar(4200) -- query
declare @f varchar(3100) -- filter
declare @s varchar(250) -- search string
declare @c nvarchar(2) set @c=char(13) -- carriage return
declare @b nvarchar(25) -- begin date
declare @e nvarchar(25) -- end date

declare @dd nvarchar(100) set @dd='Sunday Monday Tuesday Wednesday Thursday Friday Saturday'
declare @mm nvarchar(100) set @mm='January February March April May June July August September October November December'

declare @t nvarchar(900) -- filter name for summary
declare @g nvarchar(600) -- group name for summary
declare @g1 nvarchar(15) set @g1='''All Calls'''
declare @g2 nvarchar(25) set @g2='cdr.cdrAcc ountCode'
declare @g3 nvarchar(200) set @g3='isNull(ds. vdsName + isnull('' - ''+ds.vdsType,' ''') + isnull('' - ''+ds.vdsMobile Carrier,'''') + isnull('' - ''+ds.vdsDescri ption,'''') + '' - '' + ds.vdsDialcode, ''Unknown - System Default'')'
declare @g4 nvarchar(55) set @g4='isnull(ds. vdsDescription, ''Unknown'')'
declare @g5 nvarchar(200) set @g5=' isNull(ds.vdsNa me + isnull('' - ''+ds.vdsType,' ''') + isnull('' - ''+ds.vdsMobile Carrier,'''') + isnull('' - ''+ds.vdsDescri ption,''''), ''Unknown - System Default'') '
declare @g6 nvarchar(95) set @g6=' mm.value + '', '' + right(year(cdr. cdrCallDate),4) '
declare @g7 nvarchar(250) set @g7=' ltrim(year(cdr. cdrCallDate))+r ight(''0''+ltri m(day(mm.idx+1) ),2)+right(''0' '+ltrim(day(cdr .cdrCallDate)), 2)+'' - '' + mm.value + '' '' + right(''0''+ltr im(day(cdr.cdrC allDate)),2) + '', '' + ltrim(year(cdr. cdrCallDate)) '
declare @g8 nvarchar(85) set @g8=' ltrim(dd.idx+1) +'' - ''+dd.value '
declare @g9 nvarchar(250) set @g9=' CONVERT(datetim e, (CONVERT(varcha r, datepart(mm,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(dd,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(yyyy,c dr.cdrCallDate) ))) , datepart(hh,cdr .cdrCallDate) '
declare @g10 nvarchar(350) set @g10=' ISNULL(gateways .[description], ISNULL(cdr.vrUs erName, ''Unknown - System Default'' )) '
declare @g11 nvarchar(200) set @g11='isNull(ds .vdsName + isnull('' - ''+ds.vdsType,' '''), ''Unknown - System Default'') '
declare @g12 nvarchar(200) set @g12='isNull(ds .vdsName + isnull('' - ''+ds.vdsType,' ''') + isnull('' - ''+ds.vdsMobile Carrier,''''), ''Unknown - System Default'') '

print @systemid
print @sortBy
-- fix qryMode & detailMode
if @qryMode<0 or @qryMode>12 set @qryMode=1
if @detailMode<0 or @detailMode>12 set @detailMode=nul l

-- fix requested IDs
if @userId>0 set @custId=null if @custId>0 set @userId=null

-- fix requested dates
if len(@beginDt)>0 or len(@endDt)>0
begin
set @beginDt=isnull (@beginDt,'jan 01, 2000') set @endDt=isnull(@ endDt,getdate() +1)
if @beginDt>@endDt set @endDt=@beginDt
set @b=cast(month(@ beginDt) as varchar)+'/'+cast(day(@beg inDt) as varchar)+'/'+cast(year(@be ginDt) as varchar)+' '+cast(datepart (hh,@beginDt) as varchar)+':'+ca st(datepart(n,@ beginDt) as varchar)+':00.0 1'
set @e=cast(month(@ endDt) as varchar)+'/'+cast(day(@end Dt) as varchar)+'/'+cast(year(@en dDt) as varchar)+' '+cast(datepart (hh,@endDt) as varchar)+':'+ca st(datepart(n,@ endDt) as varchar)+':59.5 9' -- construct date filter
set @f='where cdr.cdrCallDate between '''+@b+''' and '''+@e+''' '+@c
end

-- fix requested search strings
set @s=replace(repl ace(replace(ltr im(rtrim(@srchF or)),'''',''''' '),'_','[_]'),'%','[%]')
if len(@detailFilt er)>0 set @detailFilter=r eplace(replace( replace(ltrim(r trim(@detailFil ter)),'''','''' ''),'_','_'),'% ','[%]')

-- assign data grouping based on request mode
if @qryMode=0
begin
if @detailMode=1 begin set @t=@g1 end
else if @detailMode=2 begin set @t=@g2 end
else if @detailMode=3 begin set @t=@g3 end
else if @detailMode=4 begin set @t=@g4 end
else if @detailMode=5 begin set @t=@g5 end
else if @detailMode=6 begin set @t=@g6 end
else if @detailMode=7 begin set @t=@g7 end
else if @detailMode=8 begin set @t=@g8 end
else if @detailMode=9 begin set @t= ' CONVERT(datetim e, (CONVERT(varcha r, datepart(mm,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(dd,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(yyyy,c dr.cdrCallDate) )) + '' '' + convert(varchar ,datepart(hh,cd r.cdrCallDate)) + '':00'') >= convert(datetim e, '''+@detailFilt er+''' + '':00'') AND CONVERT(datetim e, (CONVERT(varcha r, datepart(mm,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(dd,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(yyyy,c dr.cdrCallDate) )) + '' '' + convert(varchar ,datepart(hh,cd r.cdrCallDate)) + '':00'') <= convert(datetim e, '''+@detailFilt er+''' + '':59:59'') ' end
else if @detailMode=10 begin set @t=@g10 end
else if @detailMode=11 begin set @t=@g11 end
else if @detailMode=12 begin set @t=@g12 end

end
else if @qryMode=1 begin set @g=@g1 end
else if @qryMode=2 begin set @g=@g2 end
else if @qryMode=3 begin set @g=@g3 end
else if @qryMode=4 begin set @g=@g4 end
else if @qryMode=5 begin set @g=@g5 end
else if @qryMode=6 begin set @g=@g6 end
else if @qryMode=7 begin set @g=@g7 end
else if @qryMode=8 begin set @g=@g8 end
else if @qryMode=9 begin set @g=@g9 end
else if @qryMode=10 begin set @g=@g10 end
else if @qryMode=11 begin set @g=@g11 end
else if @qryMode=12 begin set @g=@g12 end
-- construct search filter
if len(@s)>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' (u.userFN like ''%'+@s+'%'' or u.userLN like ''%'+@s+'%'' or u.userUnixName like ''%'+@s+'%'' '+@c
set @f=@f +' or cdr.cdrSrcNum like ''%'+@s+'%'' or cdr.cdrSrcChann el like ''%'+@s+'%'' or cdr.cdrDstNum like ''%'+@s+'%'' '+@c
set @f=@f +' or ''1007'' like ''%'+@s+'%'' or ds.vdsName like ''%'+@s+'%'' or s.vcsName like ''%'+@s+'%'' )'+@c
end

-- construct detail filter
if @qryMode=0 and @detailMode>0 and @detailMode<=12 and len(@detailFilt er)>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
if @detailMode=3 set @f=@f +'cdr.vdsId = '''+@detailFilt er+''' ' +@c
else set @f=@f +@t +' = '''+@detailFilt er+''' ' +@c
end
else if @qryMode=0 and @detailMode=9 and len(@detailFilt er)>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
if @detailMode=3 set @f=@f +'cdr.vdsId = '''+@detailFilt er+''' ' +@c
else set @f=@f +@t +@c
end

-- get fields from calls table
set @q='select '+@c
if @qryMode=0 -- detail mode
begin
set @q=@q +'c.custId, u.userId, u.userUnixName, u.userUnixName AS callSummaryName , u.userFN+'' ''+left(u.userL N,1)+''.'' userShortname, '+@c
set @q=@q +'cdr.cdrCallDa te AS vcdStartDt, cdr.cdrSrcNum, cdr.cdrSrcChann el, cdr.cdrAccountC ode, cdr.cdrDstChann el, ''1007'' As vcdDstPrefix, cdr.cdrDstNum, isNull(ds.vdsNa me + isnull('' - ''+ds.vdsType,' ''') + isnull('' - ''+ds.vdsMobile Carrier,'''') + isnull('' - ''+ds.vdsDescri ption,'''') , ''Unknown - System Default'') AS vdsName, cdr.cdrCallGK, cdr.vrUserName, '+@c
set @q=@q + ' (CONVERT(varcha r, datepart(mm,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(dd,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(yyyy,c dr.cdrCallDate) )) AS CallDate, '
set @q=@q +'s.vcsName, s.vcsColor, '+@c
set @q=@q +' q.dcqId, q.dcqDescriptio n, q.dcqNote, '+@c
set @q=@q +'cdr.cdrBillSe c, ''0'' AS callRate, ''0'' AS callAdjRate, ''0'' AS callCost, cdr.vdsId AS vdsId, cdr.meraRouteRe tries, cdr.meraPDDTime '+@c
end -- summary modes: add specific output fields
else if @qryMode=3 begin set @q=@q +' cdr.vdsId, ' end
if @qryMode>0 -- summary modes: add counts
begin
set @q=@q + @g +' callSummaryName , '+@c
set @q=@q +'min(cdr.cdrCa llDate) callMinDt, '+@c
set @q=@q +'max(cdr.cdrCa llDate) callMaxDt, '+@c
set @q=@q +'count(*) callTotalCount, '+@c
set @q=@q + ' min((CONVERT(va rchar, datepart(mm,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(dd,cdr .cdrCallDate)) + ''/'' + CONVERT(varchar , datepart(yyyy,c dr.cdrCallDate) ))) AS CallDate, '
set @q=@q +'isnull(sum(ca se cdr.vcsId when 2 then 1 else 0 end),0) callTotalAnswer ed, '+@c
set @q=@q +'isnull(sum(ca se cdr.vcsId when 2 then 1 else 0 end),0)*100/(case count(*) when 0 then 1 else count(*) end) callTotalASR, '+@c
set @q=@q +'isnull(sum(cd r.cdrBillSec),0 )/(case isnull(sum(case cdr.vcsId when 2 then 1 else 0 end),0) when 0 then 1 else isnull(sum(case cdr.vcsId when 2 then 1 else 0 end),0) end) callTotalACD, '+@c
set @q=@q +'isnull(sum(cd rBillSec),0) callTotalSec, '+@c
set @q=@q +' AVG(CAST(IsNull (cdr1.NumberOfR etries, 0) AS Numeric)) averageRouteRet ries, '+@c
set @q=@q +' AVG(IsNull(cdr. meraPDDTime, 0)) averagePDD, '+@c
set @q=@q + ' isnull(sum(CASE WHEN (cdr.cdrBillSec = 0) THEN (0) WHEN isnull(cdr.cdrB illSec,0) <= (6) THEN (6) ELSE ((( CASE WHEN (isnull(cdr.cdr BillSec,0)%(6)) =0 then (isnull(cdr.cdr BillSec,0)%(6)) Else 6-(isnull(cdr.cdr BillSec,0)%(6)) End))+(isnull(c dr.cdrBillSec, 0)))END),0) callTotalFinal, ' + @c
set @q=@q + ' isnull(sum(CASE WHEN (cdr.cdrBillSec = 0) THEN (0) WHEN isnull(cdr.cdrB illSec,0) <= (30) THEN (30) ELSE ((( CASE WHEN (isnull(cdr.cdr BillSec,0)%(6)) =0 then (isnull(cdr.cdr BillSec,0)%(6)) Else 6-(isnull(cdr.cdr BillSec,0)%(6)) End ))+(isnull(cdr. cdrBillSec,0))) END),0) callTotalFinal2 ,' + @c
set @q=@q + ' isnull(sum(CASE WHEN (cdr.cdrBillSec = 0) THEN (0) WHEN isnull(cdr.cdrB illSec,0) <= (30) THEN (30) ELSE isnull(cdr.cdrB illSec,0) END),0) callTotalFinal3 , ' + @c
set @q=@q + ' isnull(sum(CASE WHEN (cdr.cdrBillSec = 0) THEN (0) WHEN isnull(cdr.cdrB illSec,0) <= (60) THEN (60) ELSE ((( CASE WHEN (isnull(cdr.cdr BillSec,0)%(60) )=0 then (isnull(cdr.cdr BillSec,0)%(60) ) Else 60-(isnull(cdr.cdr BillSec,0)%(60) ) End))+(isnull(c dr.cdrBillSec, 0)))END),0) callTotalFinal4 , ' + @c
set @q=@q +' 0 AS callTotalCost , MAX(cdr.vdsId) AS vdsId, '+@c
set @q=@q + ' SUM(case meraDisconnectC odeQ931 when 16 then
1 else 0 end) AS NCC,
SUM(case meraDisconnectC odeQ931 when 1 then
1
when 28 then
1 else 0 end) AS WN,
SUM(case meraDisconnectC odeQ931
when 34 then
1
when 17 then
1 else 0 end) AS Busy,
SUM(case
when (meraDisconnect CodeQ931<>1) AND (meraDisconnect CodeQ931<>28) AND (meraDisconnect CodeQ931<>34) AND (meraDisconnect CodeQ931<>17) AND (meraDisconnect CodeQ931<>16) then
1 else 0 end) AS Other '
end

-- get cdr table
If @qryMode=0
begin
set @q=@q +' from tblVoIPCDRs cdr WITH (NOLOCK) left join tblUser u on (cdr.cdrUserNam e=u.userUnixNam e) left JOIN tblCustomer c on (u.CustId = c.CustId) Left join X1Customer x on (c.x1CustId = x.Id) left Join tblVoIPDestinat ion ds on (cdr.vdsId = ds.vdsId) left join tblVoIPCallStat us s on (cdr.vcsId=s.vc sId) left outer join tblVoIPDisconne ctCodeQ931 q on (cdr.meraDiscon nectCodeQ931 = q.dcqId) left join tblUser uu on (cdr.vrUserName =uu.userUnixNam e) left JOIN tblCustomer cc on (uu.CustId = cc.CustId) ' + @c
end
Else
begin
set @q=@q +' from (Select MAX(cddr.cdrNat iveId) AS cdrNativeId, count(*) AS NumberOfRetries from tblVoIPCDRs cddr where cddr.cdrCallDat e between '''+@b+''' and '''+@e+''' group by cddr.meraRecord Id) AS cdr1 join tblvoipcdrs AS cdr WITH (NOLOCK) on (cdr1.cdrNative Id = cdr.cdrNativeId ) left join tblUser u on (cdr.cdrUserNam e=u.userUnixNam e) left JOIN tblCustomer c on (u.CustId = c.CustId) Left join X1Customer x on (c.x1CustId = x.Id) left Join tblVoIPDestinat ion ds on (cdr.vdsId = ds.vdsId) left join tblVoIPCallStat us s on (cdr.vcsId=s.vc sId) left join tblUser uu on (cdr.vrUserName =uu.userUnixNam e) left JOIN tblCustomer cc on (uu.CustId = cc.CustId) ' + @c
end

if @qryMode=10 OR @detailMode=10
begin
set @q=@q +' left outer JOIN (SELECT * FROM openquery(routi ng, ''SELECT * FROM gateways'') ) gateways ON gateways.[Name] = (case when patindex(''sip/%'',lower(cdr.c drDstChannel)) > 0 then (substring(cdr. cdrDstChannel, 5, (len(cdr.cdrDst Channel)-4) - patindex(''%-%'',reverse(cdr .cdrDstChannel) ))) end) ' +@c
end

--if @qryMode=10 begin set @q=@q + ' join tblCustomer cust on (vv.custID = c.custId) join X1Customer x1c on (c.x1CustId = x.ID) '+@c end

-- join user table
--set @q=@q +'join tblUser u on u.userId=cd.use rId '

-- join status, destination tables
--set @q=@q +'join tblVoIPCallstat us cs on cs.vcsId=cd.vcs Id '
if @vcsId>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' cdr.vcsId='+cas t(@vcsId as varchar)+' '+@c
end
else
begin
set @f=@f +@c
end

--if @userId>0 set @q=@q +'and u.userId='+cast (@userId as varchar)+' '
--if @custId>0 set @q=@q +'and u.custId='+cast (@custId as varchar)+' '+@c else set @q=@q +@c

if @userId>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' u.userId='+cast (@userId as varchar)+' '+@c
end
else
begin
set @f=@f +@c
end

if @custId>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' c.custId='+cast (@custId as varchar)+' '+@c
end
else
begin
set @f=@f +@c
end

--set @q=@q +' join tblVoIPRate vr on ((vr.vtrID = cd.vtrID) AND (vr.vvdId = cd.vvdId) AND (vr.vdsID = cd.vdsID)) ' --- Join voipRATE table
--set @q=@q + ' join tblVoIPBillingS tructure vbs on (vbs.vbsID = vr.vbsID) ' --- Join voipBillingStru cture table

if @vdsId>0
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' ds.vdsId='+cast (@vdsId as varchar)+' '+@c
end
else
begin
set @f=@f +@c
end

if len(@f)>0 set @f=@f +' and ' else set @f='where '
if @systemid='1' set @f=@f +' ( '
set @f=@f +' uu.systemid=''' +(@systemid)+'' ' '+@c
if @systemid='1' set @f=@f +' OR uu.systemid IS NULL ) '+@c

if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' cdrActive=1'+@c

if len(@vendor)>1
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' cc.x1CustId=''' +(@vendor)+''' '+@c
end

if len(@vendorUser Id)>1
begin
if len(@f)>0 set @f=@f +' and ' else set @f='where '
set @f=@f +' uu.userId='''+( @vendorUserId)+ ''' '+@c
end

-- join month and day soft tables
--if @qryMode=6 OR @qryMode=7 OR @qryMode=8 OR @qryMode=9
--Begin
set @q=@q +'join fnSplit('''+@mm +''','' '') mm on mm.idx=month(cd r.cdrCallDate)-1 ' +@c
set @q=@q +'join fnSplit('''+@dd +''','' '') dd on dd.idx=datepart (dw,cdr.cdrCall Date)-1 ' +@c
--End

-- add filter
if len(@f)>0 set @q=@q +@f

-- add grouping for summary modes
if @qryMode=1 set @q=@q +'' +@c
else if @qryMode=3 begin set @q=@q +'group by cdr.vdsId, '+@g+' ' +@c end
else if @qryMode in (2,4,5,6,7,8,9, 10,11,12) begin set @q=@q +'group by '+@g+' ' +@c end

-- add sorting to detail mode
if len(@sortBy)>0 and @qryMode<>1 set @q=@q +'order by ' +@sortBy +@c

-- exec
print @q
exec(@q)

could any one tell me what the ouput of this query

and i want to optimized this query by removing joins and make Temp Table that hold all required data

Jul 3 '07 #1

Subscribe Reply

1333

SkinHead

New Member

You're Having A Laugh !

What Do You Think It Does ?

What Do You Want It To Do ?

A Little More Information & Effort On Your Part Would Be Appreciated.

You Need To Help Us, So We Can Help You !

Jul 3 '07 #2

mgsn

New Member

this SP is to create query string depend on the passing variable that cam from ASP page

as u see there ara many joins and average number of records in tables 34,000,000 record

i want to create Temp table taht hold all data

Jul 4 '07 #3

Similar topics

1644

stored procedures and other...

by: Ante Perkovic | last post by:

Hi, Sorry for completely newbie questions :) * Can you recomend me internet resources on MS SQL Server stored procedures? * Can MS SQL Server's stored procedures do the same things as Oracle's (I was programing with PL/SQL briefly few years ago)

Microsoft SQL Server

2244

Determine closedate depending on a metatable and this closedate will be used in a query

by: Hennie de Nooijer | last post by:

Hi, This is a diffcult issue to explain. I hope to make my problem clear to you. SITUATION I'm building A SLA Query for a customer. This customer has an awkward way to determine the SLA results ;-) Depending on a category which is stored in a headertable (Requests) a field and logic is determined how to get a proper Close_Date. This Close_date can be the closedate of the request. It is also possible that the close_date is a certain...

Microsoft SQL Server

1503

debugging stored procedures

by: Little PussyCat | last post by:

Hello, I am doing a lot of work with stored procedures at work now and am wondering if there is a way that I can step through the code line by line and set breakpoints on it like I do in VB/VBA to test variables/parameters. Regards, Jayne

Microsoft SQL Server

1251

Why is it called Stored Procedure instead of Stored Sets?

by: NickName | last post by:

Since RDMBS and its language SQL is set-based would it make more sense to call a given stored process "Stored Sets" instead of current theorically misleading Stored Procedure, as a measure to prod programmers to think along the line of sets instead of procedure?

Microsoft SQL Server

7346

Need Help Converting MS SQL Server Stored Procedures to DB2

by: Adam Greifer | last post by:

Hi! I'm a newbie at DB2 but have 13 years of SQL Server. I need to convert over 100 SQL Server procs to DB2. I haven't had much luck with the IBM Integration Toolkit and want to avoid ER/win templates. Any suggestions. Thanks. Adam

DB2 Database

2831

Is this a good application Design?

by: Jay Balapa | last post by:

Hello, Currently my application has three tiers- 1. Presentation Layer (Asp.Net / Win Forms/ Pocket PC UI.) This predominantly contains User Controls, Custom Controls and Win/Web Forms. I have one base form and I inherit from that form. All validation is done in this tier. There is zero Data Access code in this tier. This tier exclusively gets DataViews/ Arays/Lists as input. Outputs

C# / C Sharp

1604

Procedural ["bare ASP.NET"] versus OOPy ASP.NET

by: parley | last post by:

After several years of programming WWW applications in ASP.NET (and several other frameworks) our division has come to what might seem a counterintiutive conclusion: Writing ASP.NET code in a "procedural" manner (without webcontrols and without utilizing OOP concepts in general) produces code that is remarkably faster and more scalable. In general a "bare ASP.NET" application outruns it's OOPy counterpart by factors of 2 to 10. ...

ASP.NET

2776

Converting procedural type code to OO code

by: Mohitz | last post by:

Any pointers as to how one should go about porting procedural type code into object oriented code?? --- Mohit

C / C++

5736

how to declare the cursors in a stored procedural function

by: san1014 | last post by:

Hi I have few questions. Pleae give me the answers. 1) In postgreSQL, how to declare and call the cursors in a stored procedural function? Ex: I want to display all the columns in a table in one cursor and also how to see the output. 2) tell me , the analytic functions in oracle connect by prior, sys_connect_by_path are existed in postgreSQL? 3)how to call the stored procedural function which was written in postgres in java?

PostgreSQL Database

8831

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9374

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8244

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6076

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4607

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4876

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3315

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2787

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2215

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General