Database

/*
Extracts the file name from the file path. If file path is D:\myFolder\new1.txt, then it returns
new1.txt. not in original SQLite.
*/
const char* extractFileName(const char* s){
  while( *s != '\0' ) ++s;
  while( *s != '\\') --s;
  ++s;
  return s;
}

/*
Extracts the file name from the file path. If file path is D:\myFolder\new1.txt, then it returns
new1.txt. not in original SQLite.
*/
static void extractFileNameFunc(sqlite3_context *context, int argc, sqlite3_value **argv){
  const char *z;

  assert( argc==1);

  if( SQLITE_NULL==sqlite3_value_type(argv[0]) ){
    sqlite3_result_null(context);
    return;
  }
  z = sqlite3_value_text(argv[0]);
  sqlite3_result_text(context, extractFileName(z), -1, SQLITE_TRANSIENT); 
}

declare @DBName varchar(20)
declare @Str varchar(100)

set @DBName = databasename
set @Str = 'use ' + @DBName
exec (@Str)

declare @DBName varchar(20)
declare @Str varchar(100)

set @DBName = 'OUTLOG_PACE'
set @Str = 'use ' + @DBName
exec (@Str)

select * from dbo.OUT_tbl_Request

ALTER PROC [dbo].[sp_Get_Staff_Cycles]  
(
@Subject_Descr varchar(30)
)
AS
--Check if the table Exists 
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FINAL]'))
drop table [FINAL]
--Get the Cycle template description
Declare @CycletemplateTerm varchar(60)
set @CycletemplateTerm = (  select top 1 t.descr from MTM_ACTV_STAFF mtn
							inner join tbl_actv a on a.id  = MTN.actv
							inner join tbl_cntc cc on a.cntcID = cc.id
							inner join tbl_modl m on m.id = cc.modlid
							inner join tbl_term t on a.term = t.id 
							LEFT OUTER JOIN MTM_ACTV_STAFF_CYCLE C
							ON C.IDL = MTN.ID
							WHERE M.DESCR = @Subject_Descr
						)
 
SELECT [ID] = IDENTITY (int,1,1),A.DESCR AS [ACTIVITY], S.DESCR,
CASE
WHEN MTN.CYCLETEMPLATE IS NULL THEN  C.CYCLES
WHEN MTN.CYCLETEMPLATE IS NOT NULL THEN @CycletemplateTerm 
END AS CYCLETEMPLATE
INTO FINAL FROM TBL_STAFF S
INNER JOIN MTM_ACTV_STAFF MTN ON
S.ID = MTN.STAFF
inner join tbl_actv a on a.id  = MTN.actv
inner join tbl_cntc cc on a.cntcID = cc.id
inner join tbl_modl m on m.id = cc.modlid
LEFT OUTER JOIN MTM_ACTV_STAFF_CYCLE C
ON C.IDL = MTN.ID
WHERE M.DESCR = @Subject_Descr

SELECT * 
  FROM [table]
 WHERE [number] <> -1
    OR [number] IS NULL

I are troll