Database

soniasan wrote:

This is giving me error near where .

<br />
(select voucher_id from confirm_detail where .....)

UPDATE A SET
    vou_id = REPLACE(B.voucher_id, 'con', 'dom')
  FROM @lia_table1 A
  INNER JOIN confirm_detail B
    ON B.bkng_no = A.bkng_no
    AND B.voucher_no = (
      SELECT MAX(voucher_no) FROM confirm_detail C
      WHERE C.bkng_no = A.bkng_no)
  WHERE A.ids = @minsum + 1

Pete O`Hanlon wrote:

not keen on the blatant attempts to get MVP status

OS GIKEN wrote:

UPDATE,DELETE,INSERT,GET

OS GIKEN wrote:

UPDATE,DELETE,INSERT

SELECT DISTINCT
    LTRIM(RTRIM(opp_name))
FROM
    tblOpps

<br />
<br />
SELECT DISTINCT   <br />
 LTRIM(RTRIM(opp_name)),<br />
 len(opp_name),<br />
 len(LTRIM(RTRIM(opp_name)))<br />
FROM    tblOpps<br />
<br />

SELECT dbo.RPT_GetPeriod(@PeriodName, CreateDate) AS Period,
    COUNT(*) AS IssuesReceived,
    SUM(dbo.RPT_IsInquiryCompleted(CurrentStatusID)) AS IssuesClosed
FROM Ms_threads
WHERE CreateDate BETWEEN @BeginningDate and @EndDate
GROUP BY CreateDate
ORDER BY CreateDate

SELECT dbo.RPT_GetPeriod(@PeriodName, A.PeriodDate) AS Period,
    SUM(A.IssueReceived) AS IssuesReceived,
    SUM(A.IssueClosed) AS IssuesClosed
FROM (
  SELECT CreateDate AS PeriodDate,
      1 AS IssueReceived,
      0 AS IssueClosed
    FROM Ms_threads
    WHERE CreateDate BETWEEN @BeginningDate and @EndDate
  UNION ALL
  SELECT StatusDate AS PeriodDate,
      0 AS IssueReceived,
      dbo.RPT_IsInquiryCompleted(CurrentStatusID) AS IssueClosed
    FROM Ms_threads
    WHERE StatusDate BETWEEN @BeginningDate and @EndDate
) A
GROUP BY A.PeriodDate
ORDER BY A.PeriodDate

SELECT * FROM Table1<br />
UNION<br />
SELECT * FROM Table2