add anPLUCode in view MS

Kategorija: Pantheon TSQL

DECLARE @tekst varchar(max)select @tekst = definition FROM sys.sql_modules WHERE object_id = object_id('MS')SET @tekst = REPLACE(@tekst, ', anPLUCode', '') SET @tekst = REPLACE(@tekst, 'create view', ...

Auto PLU Codes

Kategorija: Pantheon

create table #x(id int identity (1,2) not null,ident char (16)) insert into #x (ident)select ident from ms update mset m.anPLUCode = t.id, m.anPLUCode2 = t.id + 1from tHE_SetItem minner join #x t on m...

CHECKCONSTRAINTS

Kategorija: TSQL

This command can be run as follows: DBCC CHECKCONSTRAINTS (TableName) - checks an individual table DBCC CHECKCONSTRAINTS (ConstraintName) - checks an individual constraint DBCC CHECKCONSTRAINTS WITH ...

Rebuild all indexes on all tables (see attachment)

Kategorija: TSQL

DECLARE @Database NVARCHAR(255) DECLARE @Table NVARCHAR(255) DECLARE @cmd NVARCHAR(1000) DECLARE DatabaseCursor CURSOR READ_ONLY FOR SELECT name FROM master.sys.databases WHERE name NOT I...

OFS Procedure

Kategorija: OFS

OFS Procedure 8 ePrintLoop za RDP usere   CREATE TRIGGER trg_tHE_Move_BlockON tHE_MoveAFTER UPDATE, DELETEASBEGINSET NOCOUNT ON;-- U slučaju DELETE ili UPDATE provjeravamo acKeyIF EXISTS (SELECT 1FROM...

Comon TSQL1

Kategorija: Pantheon TSQL

select g.*from tHE_Move ginner join tPA_SetDocType d on g.acDocType = d.acDocType and d.acType = 'P'inner join tHE_MoveItem p on g.acKey = p.acKeyinner join tHE_SetItem m on p.acIdent = m.acIdent