DECLARE @tsql VARCHAR(MAX) if not exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0105a') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN SET @tsql = 'CREATE VIEW vw_Indoo_template_0105a AS SELECT cg, max([0]) as m0, max([1]) as m1, max([2]) as m2, max([3]) as m3 FROM (SELECT id, rownum, (rownum - 1) % 4 AS rg, FLOOR((rownum - 1) / 4) AS cg FROM (SELECT id, ROW_NUMBER() OVER (ORDER BY id) AS rownum FROM Indoo_template_0105) as select1) as select2 PIVOT (max(id) FOR rg IN ([0], [1], [2], [3])) AS pvt group by cg' EXEC (@tsql) END GO DECLARE @tsql VARCHAR(MAX) if not exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0105b') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN SET @tsql = 'create view vw_Indoo_template_0105b as SELECT vw_Indoo_template_0105a.cg AS newID, Indoo_template_0105_1.Title AS Title_1, Indoo_template_0105_1.ID AS ID_1, Indoo_template_0105_1.FileContent AS FileContent_1, Indoo_template_0105_1.FileMimeType AS FileFileMimeType_1, Indoo_template_0105_2.Title AS Title_2, Indoo_template_0105_2.ID AS ID_2, Indoo_template_0105_2.FileContent AS FileContent_2, Indoo_template_0105_2.FileMimeType AS FileFileMimeType_2, Indoo_template_0105_3.Title AS Title_3, Indoo_template_0105_3.ID AS ID_3, Indoo_template_0105_3.FileContent AS FileContent_3, Indoo_template_0105_3.FileMimeType AS FileFileMimeType_3, Indoo_template_0105_4.Title AS Title_4, Indoo_template_0105_4.ID AS ID_4, Indoo_template_0105_4.FileContent AS FileContent_4, Indoo_template_0105_4.FileMimeType AS FileFileMimeType_4 FROM vw_Indoo_template_0105a LEFT OUTER JOIN Indoo_template_0105 AS Indoo_template_0105_1 ON vw_Indoo_template_0105a.m0 = Indoo_template_0105_1.ID LEFT OUTER JOIN Indoo_template_0105 AS Indoo_template_0105_2 ON vw_Indoo_template_0105a.m1 = Indoo_template_0105_2.ID LEFT OUTER JOIN Indoo_template_0105 AS Indoo_template_0105_3 ON vw_Indoo_template_0105a.m2 = Indoo_template_0105_3.ID LEFT OUTER JOIN Indoo_template_0105 AS Indoo_template_0105_4 ON vw_Indoo_template_0105a.m3 = Indoo_template_0105_4.ID' EXEC (@tsql) END tablename vw_Indoo_template_0105b binaryData.fileSytemDBPath notSkipSqlOnImport on gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tableKeyColumn newId gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 1 gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader [setObject:viewPage.gridView.txt_filter=Filter rows] moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord addcreatestatement createKeyColumn gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.columnName Title_1 gridViewColumn.0.caption Title gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn Title_2,Title_3,Title_4 gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther 0 gridViewColumn.0.isBinary on gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 0 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.columnName Title_2 gridViewColumn.1.caption gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary on gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.binaryData.columnName FileContent_2 gridViewColumn.1.binaryData.showType 2 gridViewColumn.1.binaryData.FilenameSource 1 gridViewColumn.1.binaryData.mimeTypeSource 2 gridviewcolumn.1.binarydata.isforcedownload gridViewColumn.1.binaryData.allowExport gridViewColumn.1.binaryData.allowImport gridViewColumn.1.binaryData.target _blank gridViewColumn.1.binaryData.mimeTypeColumnName FileFileMimeType_2 gridViewColumn.1.binaryData.Filename gridViewColumn.1.binaryData.defaultImageUrl gridViewColumn.0.binaryData.columnName FileContent_1 gridViewColumn.0.binaryData.showType 2 gridViewColumn.0.binaryData.FilenameSource 1 gridViewColumn.0.binaryData.mimeTypeSource 2 gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.0.binaryData.allowExport gridViewColumn.0.binaryData.allowImport gridViewColumn.0.binaryData.target _blank gridViewColumn.0.binaryData.mimeTypeColumnName FileFileMimeType_1 gridViewColumn.0.binaryData.Filename gridViewColumn.0.binaryData.defaultImageUrl gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 0 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.columnName Title_3 gridViewColumn.2.caption gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary on gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.2.binaryData.columnName FileContent_3 gridViewColumn.2.binaryData.showType 2 gridViewColumn.2.binaryData.FilenameSource 1 gridViewColumn.2.binaryData.mimeTypeSource 2 gridviewcolumn.2.binarydata.isforcedownload gridViewColumn.2.binaryData.allowExport gridViewColumn.2.binaryData.allowImport gridViewColumn.2.binaryData.target _blank gridViewColumn.2.binaryData.mimeTypeColumnName FileFileMimeType_3 gridViewColumn.2.binaryData.Filename gridViewColumn.2.binaryData.defaultImageUrl gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 0 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.columnName Title_4 gridViewColumn.3.caption gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary on gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes gridViewColumn.3.binaryData.columnName FileContent_4 gridViewColumn.3.binaryData.showType 2 gridViewColumn.3.binaryData.FilenameSource 1 gridViewColumn.3.binaryData.mimeTypeSource 2 gridviewcolumn.3.binarydata.isforcedownload gridViewColumn.3.binaryData.allowExport gridViewColumn.3.binaryData.allowImport gridViewColumn.3.binaryData.target _blank gridViewColumn.3.binaryData.thumbnailWidth gridViewColumn.3.binaryData.thumbnailHeight gridViewColumn.3.binaryData.mimeTypeColumnName FileFileMimeType_3 gridViewColumn.3.binaryData.Filename gridViewColumn.3.binaryData.defaultImageUrl gridViewColumn.0.binaryData.thumbnailWidth gridViewColumn.0.binaryData.thumbnailHeight gridViewColumn.1.binaryData.thumbnailWidth gridViewColumn.1.binaryData.thumbnailHeight gridViewColumn.2.binaryData.thumbnailWidth gridViewColumn.2.binaryData.thumbnailHeight showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord gridViewColumn.0.binaryData.isBinaryIdFromColumn gridViewColumn.0.regExClient on gridViewColumn.1.regExClient on gridViewColumn.2.regExClient on gridViewColumn.3.regExClient on alternateTablename alternateConnectionString tablename vw_Indoo_template_0105b binaryData.fileSytemDBPath |DataDirectory|indooGrid\ notSkipSqlOnImport on gridView.recordcount 1 gridView.inlineEdit version 01.05.00 connectionType 0 connectionString tableKeyColumn newId gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 1 gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary on networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader [setObject:viewPage.gridView.txt_filter=Filter rows] moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord addcreatestatement createKeyColumn gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.columnName Title_1 gridViewColumn.0.caption Title gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn Title_2,Title_3,Title_4 gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther 0 gridViewColumn.0.isBinary on gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 0 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.columnName Title_2 gridViewColumn.1.caption gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary on gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.binaryData.columnName FileContent_2 gridViewColumn.1.binaryData.showType 2 gridViewColumn.1.binaryData.FilenameSource 1 gridViewColumn.1.binaryData.mimeTypeSource 2 gridviewcolumn.1.binarydata.isforcedownload gridViewColumn.1.binaryData.allowExport gridViewColumn.1.binaryData.allowImport gridViewColumn.1.binaryData.target _blank gridViewColumn.1.binaryData.mimeTypeColumnName FileFileMimeType_2 gridViewColumn.1.binaryData.Filename gridViewColumn.1.binaryData.defaultImageUrl gridViewColumn.0.binaryData.columnName FileContent_1 gridViewColumn.0.binaryData.showType 2 gridViewColumn.0.binaryData.FilenameSource 1 gridViewColumn.0.binaryData.mimeTypeSource 2 gridviewcolumn.0.binarydata.isforcedownload gridViewColumn.0.binaryData.allowExport gridViewColumn.0.binaryData.allowImport gridViewColumn.0.binaryData.target _blank gridViewColumn.0.binaryData.mimeTypeColumnName FileFileMimeType_1 gridViewColumn.0.binaryData.Filename gridViewColumn.0.binaryData.defaultImageUrl gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 0 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.columnName Title_3 gridViewColumn.2.caption gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary on gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.2.binaryData.columnName FileContent_3 gridViewColumn.2.binaryData.showType 2 gridViewColumn.2.binaryData.FilenameSource 1 gridViewColumn.2.binaryData.mimeTypeSource 2 gridviewcolumn.2.binarydata.isforcedownload gridViewColumn.2.binaryData.allowExport gridViewColumn.2.binaryData.allowImport gridViewColumn.2.binaryData.target _blank gridViewColumn.2.binaryData.mimeTypeColumnName FileFileMimeType_3 gridViewColumn.2.binaryData.Filename gridViewColumn.2.binaryData.defaultImageUrl gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 0 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.columnName Title_4 gridViewColumn.3.caption gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther 0 gridViewColumn.3.isBinary on gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes gridViewColumn.3.binaryData.columnName FileContent_4 gridViewColumn.3.binaryData.showType 2 gridViewColumn.3.binaryData.FilenameSource 1 gridViewColumn.3.binaryData.mimeTypeSource 2 gridviewcolumn.3.binarydata.isforcedownload gridViewColumn.3.binaryData.allowExport gridViewColumn.3.binaryData.allowImport gridViewColumn.3.binaryData.target _blank gridViewColumn.3.binaryData.thumbnailWidth gridViewColumn.3.binaryData.thumbnailHeight gridViewColumn.3.binaryData.mimeTypeColumnName FileFileMimeType_3 gridViewColumn.3.binaryData.Filename gridViewColumn.3.binaryData.defaultImageUrl gridViewColumn.0.binaryData.thumbnailWidth gridViewColumn.0.binaryData.thumbnailHeight gridViewColumn.1.binaryData.thumbnailWidth gridViewColumn.1.binaryData.thumbnailHeight gridViewColumn.2.binaryData.thumbnailWidth gridViewColumn.2.binaryData.thumbnailHeight showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord gridViewColumn.0.binaryData.isBinaryIdFromColumn gridViewColumn.0.regExClient on gridViewColumn.1.regExClient on gridViewColumn.2.regExClient on gridViewColumn.3.regExClient on alternateTablename alternateConnectionString