Do you have the primary key(s) of the table you want to update in the view??

I know that the inserts generator is made by vyaskn, but I don't know if he's the author of the primary link. Sorry to burst your bubble.

I was just kidding... I kind of figured out the definition by the name. Still, thanx for the info .

Not really about perf tuning but a good start for you :

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

Also you...

"As mentioned by rqR'us ??????????!!!!!!!(R*m*)"

rgR'us - A fitting nickname

And the whole process looks like what???

So what does that mean ??

What's OCR?

What page??

The link (Help us help you) I provide is not from me!!!

You don't get what I said .

DON'T FÛQUYNG DO THAT!!!!!!!!!

Unless you want your server a prime suspect for hacking.

The Curse and Blessings of Dynamic...

You don't :

CREATE PROCEDURE dbo.Test @StatusID AS INT = 0

AS

SET NOCOUNT ON

Select List, The, ColNames, Here from dbo.tblStatus where fldStats = @StatusID

SET NOCOUNT OFF

This will take a few modifications but the basic is there :

for the server objects

IF Object_id('ListTableColumns_NotNulls') > 0

DROP FUNCTION dbo.ListTableColumns_NotNulls

GO

IF Object_id('TablesColumnsNulls') > 0

DROP TABLE dbo.TablesColumnsNulls

GO

IF Object_id('TablesColumnsNulls_Insert') > 0

DROP PROCEDURE...

Check this out (from the Books online) :

SET DATEFORMAT mdy

GO

DECLARE @datevar datetime

SET @datevar = '12/31/98'

SELECT @datevar

GO

SET DATEFORMAT ydm

GO

DECLARE @datevar datetime

SET @datevar = '98/31/12'

SELECT @datevar

GO

SET DATEFORMAT ymd

GO

DECLARE @datevar datetime

SET @datevar =...

HTH.

I said it would be better to present it horizontally as we always do, and that to make it happen vertically you'd have to use dynamic sql... please also note...