You don't need dynamic SQL to overcomplicate this, or a cursor to make it run slowly:

DECLARE @CurrentRowCount INT

SELECT @CurrentRowCount = COUNT(*)

FROM [DB_admin1].[dbo].[tblRenewals]

INSERT INTO rept.tblSubscribedSystems

([systemNum]

,[dtuStart]

,[dtuEnd]

,[total])

SELECT

REN.[SystemNum]

,REN.[Date] AS SubStart

,x.SubEnd

,rn = @CurrentRowCount...

mamzy.rahman (4/11/2013)

---

problem is tho were i have put 1 2 3 and z there jus examples the actual data is completely different and would be impossible for me to do...

In the little query I wrote above, change #Sample to aims.

Just this query, not the sample data generator:

-- solution

SELECT COUNT(L01)

FROM #Sample s

WHERE NOT EXISTS (

SELECT 1

FROM #Sample si

WHERE...

What is the name of the table you are using?

-- create some sample data to...

-- create some sample data to test against

DROP TABLE #Sample

CREATE TABLE #Sample (L01 INT, a09 CHAR(1))

INSERT INTO #Sample (L01, a09)

SELECT 123, '1' UNION ALL

SELECT 123, '2' UNION ALL

SELECT 123, 'z'...

-- Here's the last change.

USE [Build1]

SELECT

td.TYPE_NAME

,i.DOC_NAME

,i.DOC

,i.SEC

,i.VER

,r.JUSTIFICATION

FROM TBL_INSTANCES i

INNER JOIN TBL_TYPE_DEF td

ON i.TYPE_ID = td.TYPE_ID

LEFT JOIN TBL_RELATIONSHIPS r

ON i.DOC = r.PARENT_DOC

AND i.SEC = r.PARENT_SEC

AND i.VER =...

Thanks to Lynn & Sean for the formatted query:

-- code rewrites are iterative in nature. You make a change or two,

-- test thoroughly, amend if necessary, then make another change.

--...

Kurtman (4/10/2013)

---

Thanks for the idea. I did use try...catch blocks with transactions and tested for the transaction state, but I crashed into DTC with so many linked servers. ...

-- Query 2

SELECT

TOP 100 comp_id,

sup_code,

sup_name,

sup_ac_code,(

...

adonetok (4/10/2013)

---

In ServerA, I created a linked server to ServerB.

In ServerA, there is a query like below.

select * from [ServerB].order.dbo.allorder where city='london'

Question:

Which server will process data?

1) processing...

T.Ashish (4/10/2013)

---

Hard coded value is coming from SITE_AC table. Now it is not there because I had removed some rows from script to reduce the size of attachment. you can...

Same as any other index:

SELECT DB_NAME(database_id) AS [Database Name], OBJECT_NAME(ps.OBJECT_ID) AS [Object Name],

i.name AS [Index Name], ps.index_id, index_type_desc,

avg_fragmentation_in_percent, fragment_count, page_count

FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL ,N'LIMITED') AS ps

INNER JOIN sys.indexes...

Default trace[/url] could provide most of what you're looking for.

sqldba_newbie (4/10/2013)

---

ChrisM@Work (4/10/2013)

---

sqldba_newbie (4/9/2013)

---

In below query , in the exec plan i see nested loop join on TBFE table. This is executed for 25,000 times. I could force a hash...