Jeff, I guess you didnt make a post. Myschif you should read up on the article. It is wonderfully written and explains the potentials pitfalls, in solving a problem...

Jeff I see that you are in the post. I was about to plug your article on the update method. 😀

Now I guess you can do that ;).

Using Jeff's...

Ok. Let me back up then. What I am saying is when you use a group by clause to group a set of aggregate data. Your data...

Internal fragmentation is not as bad as external fragmentation. Actually, internal fragmentation is expected to happen. Internal fragmentation occurs when you have data in the table and a...

I cant see you image post. But one way to do this is to take the MAX of the class and remove class from the group by. Another...

Your going to have to create dynamic sql for this. Something like this would work.

declare @sql nvarchar(4000),

@columns nvarchar(100),

@categorytext nvarchar(1000)

set @sql = N'

SELECT *

FROM tenders

WHERE ' +...

Logical Scan Fragmentation and Extent Scan Fragmentation only calculate external fragmentation, which means your pages are logically out of order. It does not factor in internal fragmentation, which means...

Are you setting this to a variable?

I dont get this... These will always...

You could do something like this:

declare @cmd nvarchar(4000),

@server nvarchar(50),

@database nvarchar(50),

@table nvarchar (50),

@username nvarchar(50),

@Password nvarchar(50),

@Columns nvarchar(500),

@filter nvarchar(500)

SET @server = N'MYDBSERVER'

SET @database = N'DBName'

SET @table = N'TableName'

--If you do not supply a...

You would have to do a left join. The left join would return all records from the left table where they do not exist in the right table. ...

Except returns DISTINCT rows. Try running this query over warehouse32.dbo.tmt_dimension. This should return 785 rows.

select distinct

[HYP_CLEARANCE] ,

[HYP_COUNTRY] ,

[HYP_EMP_TYPE],

[HYP_EMPNO] ,

[HYP_ORG],

[HYP_STATUS],

[HYP_DATE] ,

[HYP_ACTION] ,

[HYP_COUNTER]

from warehouse32.dbo.tmt_dimension

LOL. Yeah my pack is getting kinda low too.

You cant remove the where because you need it for the update. What he is saying is you can do is either put the variable in the update like:...

You dont need an if for the rollback. ...

You might get better responses if you post this in the 2000 forums. Currently this is posted in the SQL 2005 TSQL forums.