No, I am serious. I end up creating a new one because I don't believe it either and I don't want to spend time to investigate it. I am fed...

I am sorry this post should not be closed yet, after some data verification, it turns out the query might need some amendment:

In MANY records showing "Table 1 is missing",...

Thanks to all replies, much appreciated.

Thanks.

Why adding ROW_NUMBER() OVER (ORDER BY Q1.Code ASC) AS 'Row Number' gives me Row Number starting 900 and not in order?

Phil Parkin (3/14/2012)

---

Is there a way to quickly search some freetext in all sp/fn within the database? I often need to search for a sp but just couldn't find it,...

I don't...

halifaxdal (3/14/2012)

---

CREATE TABLE [dbo].[infosysnew](

[ID] [int] IDENTITY(1,1) NOT NULL,

[SysID] [int] NOT NULL CONSTRAINT...

It throws error before it reaches the table, although the table has more columns than the cursor, I don't think that should be a problem.

CREATE TABLE [dbo].[infosysnew](

[ID] [int] IDENTITY(1,1) NOT NULL,

[SysID] [int] NOT NULL CONSTRAINT [DF_infosysnew_SysID]...

I am blind now. I converted the cursor into table, and still getting similar error saying columns number does not match.:hehe:

Eugene Elutin (3/8/2012)

---

Dear halifaxdal, I cannot believe, that with visiting SQLServerCentral over 1000 times and accumulating almost 600 points you have never seen the aricle about posting questions... There is...

This is my code and it picks up right records, but I don't really like my code, looks cumbersome and not neat to me, maybe someone can rewrite it for...

OK, here are the records in the table:

Name ...

I would really love to post the data here but I just can't, simple due to the security sensitivity of the data

Thanks. but the query returns only a few redundant names, most of the results are not the same [name]/description with different code