There must be some process blocking ur query to run this report probably, what does sp_who2 or sysprocesses looks like on this SPID when the slowness happens? What SPID does...

iklektic, copy paste the code I had written initially, with two changes:

1) I mistyped "createdon" date column in the query by create_on

2) in This part of the query, I am...

How r u trying to connect to ur Sql instances? Through Management studio or through ur application?

If its application, u need to have different port numbers for both the instances.

DATEDIFF(m,

***WHAT THE HECK DO I PUT HERE??? ***

, InnerWorkOrder.CreatedOn) <= 13

ORDER BY Invoice.InvoiceDate ASC

)

DATEDIFF(m,(select created_on from

(

select CreatedOn , row_number() over (order by Invoice.InvoiceDate ASC) AS Row_Numbers

from InnerWorkOrder) t...

U can use variable name, but the thing is u will have to use execute statement to run that SQL.

DECLARE @ServerNamevarchar(20)

DECLARE @sqlvarchar(300)

SET @Servername = 'YourServerName'

SET @sql = 'select * from...

I apologise for missing that, thanks for taking out time and really appreciate your work. Thanks for sharing :-).

Hi Ramesh, I was trying to learn effectiveness from your well written query, In ur query you have been sorting all "Preference" categories by Ascending, but in original query ObtainedMarks...

Post the script of your stored procedure and attach the execution plan to start with.

DECLARE @symbol table (id int, alpha varchar(5))

INSERT INTO @symbol

SELECT 1,'ABK' UNION

SELECT 2,'UYG'UNION

SELECT 3,'AIG' UNION

SELECT 4,'SKF'

select * from @symbol;

U do have to use table variables, and then retrieve the...

arup_kc (5/26/2009)

---

Hi Adi,

Your query workls perfectly.

Hi mayank,

This is not working. It only insetts 1 for every row but not incrementing.

Hi markus,

I should admit that still I have not faced any...

Just to make sure, the "IDCOL" which u have on both the tables, is it "Identity" type column (that autoincrements by itself) or just an integer column.

Is the replication issue with the same database?

Is ur database set in replication(If yes then what kind)?

[Code]

set identity_insert emp on

insert into emp(id)

values(1)

set identity_insert emp off

[/Code]

GilaMonster (5/26/2009)

---

george sibbald (5/26/2009)

---

excuse me posting this here, but this currently appears to be my only route into SSC.I am getting routed to another page saying 'zoneEdit DNs services for...

I would just run the S.P in ur management studio or Query analyzer window with taking off create S.P from ur query and assigning the @year value to check if...