VBA Macro – Create folders from a Excel file

Sub MakeFolders() Dim Rng As Range Dim maxRows, maxCols, r, c As Integer Set Rng = Selection maxRows = Rng.Rows.Count maxCols = Rng.Columns.Count For c = 1 To maxCols r = 1 Do While r <= maxRows…

Web page Shell

  Dashboard @font-face { font-family: myTickerFont; src: url(“SUBWT___.otf”); } html,h1,h2,h3,h5 {font-family: “Helvetica”, sans-serif} body { font-family: “Helvetica&…

Clean Word from Text

CREATE FUNCTION fnDescriptionClean (@strDescription varchar(50)) RETURNS varchar(50) AS BEGIN declare @Return varchar(50) declare @badword varchar(50) set @badword = ‘Front’ set @strDes…

Find all Stored Proc’s calling a Function

USE I3_CMS –CREATE PROCEDURE dbo.Find_Text declare @SearchValue nvarchar(500) –AS SELECT DISTINCT s.name+’.’+o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER J…

Recursive Dependencies

declare @ObjectName varchar(500) = ‘Stored Proc or View Name Here’;     WITH CTE_ReferencedObject as ( select distinct ReferencedObject = isnull(b.Name, d.Name), ReferencedTyp…

Stored Proc and Views Relationships

USE [I3_CMS] GO — ============================================= — Author: — Create date: — Description:

30 OOP interview questions to know

1. What is Object Oriented Programming? OOP is a technique to develop logical modules, such as classes that contains properties, fields and events. OOP provides many concepts such as inheritance, d…

1NF, 2NF, 3NF in database design

1NF is the most basic of normal forms – each cell in a table must contain only one piece of information, and there can be no duplicate rows. 2NF and 3NF are all about being dependent on the p…

AD Member of – VB Script