yes, i know, this is reason why i edited now 😀

but i found another bug, if i use variable is not function ... why ?

without

with

Hello,

nice , it is good know it, i will try

rebuild for index is every saturday. Before was never 😀

DECLARE @TableName VARCHAR(255)

DECLARE @sql NVARCHAR(500)

DECLARE TableCursor CURSOR FOR

SELECT distinct OBJECT_NAME(OBJECT_ID)

FROM sys.dm_db_index_physical_stats (DB_ID(N'MCS_MESDB'), NULL, NULL, NULL , 'DETAILED')

WHERE...

So you know, we have separate tables, but there is column for line_code, so its good for view or one table ... new table according this view and insert all...

Hello,

I have question what do you think about create view for all tables like I said above, but there is problem that I cannot create index for view with...

so it can be task for future, because I know that dynamic sql is not good way, but there is korean code you know and there are things which are...

opc.three (3/7/2013)

---

tony28 (3/7/2013)

---

opc.three (3/7/2013)

---

Yes, you would merge all the...

opc.three (3/7/2013)

---

Yes, you would merge all the tables with...

Or do you think that I have merge all tables ? and just I will add next column with line code?

is not possible because in master table are about...

Sean Lange

---

Then let me warn you about using the NOLOCK hint. It is not a good way to make your queries go faster. It is however a good way...

opc.three (3/7/2013)

---

I am happy you found a way forward but as a side comment I must say that your code raises several red flags. The dynamic cursor is a close...

I solved this, but I think that is little dirty way..

Here is just select inside cursor, where was problem

I inserted to table variable executed @sqlStr

and then set to @RESULT_COUNT...

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/f3467f88-8657-439f-b422-00e4a0dd14ab

it was just on test DB, if i did this test http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx and after appeared error with FULL

BACKUP LOG and when I wrote command dbcc shrinkdatabase ('Your-Data-Base-Name', TRUNCATEONLY) it...

hmm, but after this I could do again query and etc... at work I will read your link