help me Calling Sql Experts, Urgent Help

[4Vikram]

are you me ?

guess we both are in same page 

[pandugadu999]

create proc    spname

@startdate   as datetime,

@enddate   as  datetime,

@region as  varchar (20)

 as

begin

 

 

end

 

 

aa  begin end madyalo nee query petti..execute chey

 

default values ki vere query raasko like

for stardate

select CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101)

 

for enddate

select CONVERT (VARCHAR(25),GETDATE() -1 ,101)

 

for region

select region from regiontable

 

[4Vikram]

 

create proc    spname

@startdate   as datetime,

@enddate   as  datetime,

@region as  varchar (20)

 as

begin

 

 

end

 

 

aa  begin end madyalo nee query petti..execute chey

 

default values ki vere query raasko like

for stardate

select CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101)

 

for enddate

select CONVERT (VARCHAR(25),GETDATE() -1 ,101)

 

for region

select region from regiontable

 

bhaiyya friend gadu idi chepindu chesina kani kncham miss aindi ekado

 

 

 

 

CREATE FUNCTION [DBO].[2LS_LIST2TABLE](

@LIST VARCHAR(MAX),

@SEPARATOR VARCHAR(250)

) RETURNS @TABLE TABLE ( ID INT IDENTITY(1,1), ELEMENT VARCHAR(MAX) )

AS

BEGIN

SET @LIST = CASE RIGHT(@LIST, LEN(@SEPARATOR) ) WHEN @SEPARATOR THEN @LIST ELSE @LIST+@SEPARATOR END

 

WHILE LEN(RTRIM(@LIST))>0

BEGIN

INSERT INTO @TABLE( ELEMENT )

VALUES( LEFT(@LIST, CHARINDEX(@SEPARATOR,@LIST)-LEN(@SEPARATOR) )  )

SET @LIST = RTRIM(SUBSTRING(@LIST+' ', CHARINDEX(@SEPARATOR, @LIST)+1,  LEN(@LIST) )) 

END

RETURN

END

 

 

 

 

 

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

 

 

 

 

 

-- for testing comment below create statement

 

ALTER PROCEDURE [DBO].[ACTUALSBYREGION](

@STARTDATE DATETIME,

@ENDDATE DATETIME

@SAR_ID VARCHAR(MAX)

)AS

/*

 

--for testing uncomment and use this 

 

--DECLARE @StartDate DATETIME = '8/7/2015''

--DECLARE @EndDate DATETIME = GetDate()-1

DECLARE @SAR_ID VARCHAR(MAX) = ''--''--

 

--DECLARE @iStartDate DATETIME; 

--DECLARE @iEndDate DATETIME; 

*/

 

BEGIN

 

--- temp table for region paramete

IF NOT OBJECT_ID( 'TEMPDB..#REGS' ) IS NULL DROP TABLE #REGS

 

 

-- multi vaue select drop down para meter

SELECT *

INTO #REGS

FROM DBO.[2LS_LIST2TABLE]( @SAR_ID, ',' )

IF @SAR_ID=''

INSERT INTO #REGS( ELEMENT )

SELECT DISTINCT RC.REGION

FROM  RC.REGION RC -- ADD 

 

 

 --your script start 

 

 

/* 

Select RL.CLNUM AS LoanNumber

      ,RB.B_NAME_LAST AS BorrowerLastName 

      ,RB.B_NAME_FIRST AS BorrowerFirstName 

      ,RA.ORIG_LOAN_AMOUNT AS LoanAmount 

      ,RD.APPLICATION_DATE AS ApplicationDate

      ,RL.LOAN_STATUS AS CurrentLoanStatus

      ,RC.REGION AS Region

      ,RC.BRANCH AS Branch

      ,RC.ORIGINATOR AS NameofOrginator

      ,RC.PROCESSOR NameofProcessor

From WG_RPT_LOAN RL

 

LEFT JOIN WG_RPT_BORROWER RB

            ON RB.LNUM = RL.LNUM

 

LEFT JOIN WG_RPT_AMOUNTS RA 

        ON RL.LNUM = RA.LNUM

 

LEFT JOIN WG_RPT_DATES RD 

            ON RL.LNUM = RD.LNUM 

    

LEFT JOIN WG_RPT_CMS RC       

    JOIN WG_RPT_CMS_CONTACTS RCC 

        ON  RC.BRANCH_CID = RCC.CID

        ON  RL.LNUM = RC.LNUM

        

WHERE

 

RD.APPLICATION_DATE BETWEEN @iStartDate and @iEndDate and Region=@iRegion 

*/

 

 

END--PROCEDURE

[4Vikram]

ltt

[pandugadu999]

indulo  nee query lo still @region parameter  use chesinav..,but mee frnd edo  function create chesadu for region filter dropdown values ki with @SAR_ID..anduke work avvatledu anukunta,,

 

 

 

bhaiyya friend gadu idi chepindu chesina kani kncham miss aindi ekado

 

 

 

 

CREATE FUNCTION [DBO].[2LS_LIST2TABLE](

@LIST VARCHAR(MAX),

@SEPARATOR VARCHAR(250)

) RETURNS @TABLE TABLE ( ID INT IDENTITY(1,1), ELEMENT VARCHAR(MAX) )

AS

BEGIN

SET @LIST = CASE RIGHT(@LIST, LEN(@SEPARATOR) ) WHEN @SEPARATOR THEN @LIST ELSE @LIST+@SEPARATOR END

 

WHILE LEN(RTRIM(@LIST))>0

BEGIN

INSERT INTO @TABLE( ELEMENT )

VALUES( LEFT(@LIST, CHARINDEX(@SEPARATOR,@LIST)-LEN(@SEPARATOR) )  )

SET @LIST = RTRIM(SUBSTRING(@LIST+' ', CHARINDEX(@SEPARATOR, @LIST)+1,  LEN(@LIST) )) 

END

RETURN

END

 

 

 

 

 

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

 

 

 

 

 

-- for testing comment below create statement

 

ALTER PROCEDURE [DBO].[ACTUALSBYREGION](

@STARTDATE DATETIME,

@ENDDATE DATETIME

@SAR_ID VARCHAR(MAX)

)AS

/*

 

--for testing uncomment and use this 

 

--DECLARE @StartDate DATETIME = '8/7/2015''

--DECLARE @EndDate DATETIME = GetDate()-1

DECLARE @SAR_ID VARCHAR(MAX) = ''--''--

 

--DECLARE @iStartDate DATETIME; 

--DECLARE @iEndDate DATETIME; 

*/

 

BEGIN

 

--- temp table for region paramete

IF NOT OBJECT_ID( 'TEMPDB..#REGS' ) IS NULL DROP TABLE #REGS

 

 

-- multi vaue select drop down para meter

SELECT *

INTO #REGS

FROM DBO.[2LS_LIST2TABLE]( @SAR_ID, ',' )

IF @SAR_ID=''

INSERT INTO #REGS( ELEMENT )

SELECT DISTINCT RC.REGION

FROM  RC.REGION RC -- ADD 

 

 

 --your script start 

 

 

/* 

Select RL.CLNUM AS LoanNumber

      ,RB.B_NAME_LAST AS BorrowerLastName 

      ,RB.B_NAME_FIRST AS BorrowerFirstName 

      ,RA.ORIG_LOAN_AMOUNT AS LoanAmount 

      ,RD.APPLICATION_DATE AS ApplicationDate

      ,RL.LOAN_STATUS AS CurrentLoanStatus

      ,RC.REGION AS Region

      ,RC.BRANCH AS Branch

      ,RC.ORIGINATOR AS NameofOrginator

      ,RC.PROCESSOR NameofProcessor

From WG_RPT_LOAN RL

 

LEFT JOIN WG_RPT_BORROWER RB

            ON RB.LNUM = RL.LNUM

 

LEFT JOIN WG_RPT_AMOUNTS RA 

        ON RL.LNUM = RA.LNUM

 

LEFT JOIN WG_RPT_DATES RD 

            ON RL.LNUM = RD.LNUM 

    

LEFT JOIN WG_RPT_CMS RC       

    JOIN WG_RPT_CMS_CONTACTS RCC 

        ON  RC.BRANCH_CID = RCC.CID

        ON  RL.LNUM = RC.LNUM

        

WHERE

 

RD.APPLICATION_DATE BETWEEN @iStartDate and @iEndDate and Region=@iRegion 

*/

 

 

END--PROCEDURE

 

 

[4Vikram]

indulo  nee query lo still @region parameter  use chesinav..,but mee frnd edo  function create chesadu for region filter dropdown values ki with @SAR_ID..anduke work avvatledu anukunta,,

ohh okay 

[loveindia]

Aipoindaaa inka unda man isssue???

[Raja123]

Aipoindaaa inka unda man isssue???

[loveindia]

R u Kathar hithar man...

[Raja123]

R u Kathar hithar man...

[4Vikram]

Aipoindaaa inka unda man isssue???

 

 

R u Kathar hithar man...

vuncle man ochinava inka undi issue... 

[4Vikram]

LTT for Love vuncle 

[4Vikram]

Ltt 

[4Vikram]

[loveindia]

Oka query undi and you want to plug it into an ssrs report... and it is not giving you any output antenaaa man nee issue??? Or emanna errors vastunnayaaa..??