You can only update one table in an UPDATE statement, but the answer to your question is yes -

EXEC my_stored_procedure_which_updates_800_tables

Lynn Pettis (2/19/2009)

---

First, I don't claim to know everything about SQL, but I do feel that I know a little about most of it (Jack of all trades, master of...

1. What happens when you compare like with like?

-- Keeping dupes:

SELECT t.EMP_ID, t.EMPLOYEE_NAME

FROM dbo.IREP_V_DAILY_COUNTS_TERRITORY t

WHERE t.EMP_ID IS NOT NULL

AND t.WORK_DATE BETWEEN '01/01/2009' AND '01/31/2009'

ORDER BY t.EMPLOYEE_NAME

--...

Looks like Ramesh has this sussed, but what do you get for this, as a matter of interest (I don't have 2k5 to play with right now)...

DECLARE @MyEnormousBelly VARCHAR(max)

SET @MyEnormousBelly...

Sure...read this[/url] and this[/url].

These two articles will show you exactly how it's done and you will almost certainly learn other useful tricks along the way.

If you post the sproc, Karthik, there's a chance that someone might figure out why it takes so long to run...

karthikeyan (2/17/2009)

---

Thanks Chris and sqlmaster!

I am facing a starnge problem while executing the below query. if i execute it seperate it took just 1 second to complete the execution. If...

-- If the number of dots is never greater than 3, then this will work:

DECLARE @String varchar(20)

SET @String = '123.45.678.90'

SELECT REPLACE(@String+'~', PARSENAME(@String+'~',1), '')

Result:

123.45.678.

DROP TABLE #TableA

CREATE TABLE #TableA (Item INT, Value VARCHAR(1))

INSERT INTO #TableA (Item, Value)

SELECT 1, 'A' UNION ALL

SELECT 1, 'A' UNION ALL

SELECT 1, 'B' UNION ALL

SELECT 2, 'A' UNION ALL

SELECT 2,...

What's the result of running the highlighted part?

select A.fldA, A.fldB from tableA A where A.fldKey IN

(

select AA.fldKey from tableA AA inner join tableB B ON

AA.fldKey =...

You don't need tableA bulking up the two subselects:

select A.fldA, A.fldB

from tableA A

where A.fldKey IN

(

select B.fldKey

from tableB B

inner join tableC C ON B.fldChild =...

Here's the old-fashioned way:

DROP TABLE #Table

CREATE TABLE #Table (ObjectID INT, ObjectStateID INT, [DateTime] DATETIME)

INSERT INTO #Table (ObjectID, ObjectStateID, [DateTime])

SELECT 1, 1, '2009-02-17 12:10:47.000' UNION ALL -- waiting

SELECT 1, 2, '2009-02-17...

The shiftcode of user 100 is s1, and of user 103 is s2.

Without knowing what...

LEFT JOIN:

SELECT f.sec_id, f.symbol

FROM fund f

LEFT JOIN exception e ON e.symbol = f.symbol AND err_cd IN (20,30)

WHERE e.symbol IS NULL

Karthik, please can you post your queries for

Cheers

ChrisM