011. Flood One Column Into Another
012. Building data up by columns
013. Looping
014. Cursors
015. Difference between putting criteria in “And” in a table join, and putting criteria in “Where”
017. Union and Union to Table
018. Like
019. Case
020. If Then Else
021. Creating Steps to Next Rows
022. Manual Transposing
023. SSIS email
024. SSIS Dynamic Filename Output
025. CTEs (Common Table Expressions)
026. E-book SQL Toolkit
027. In-Line Select
028. Into new_table
029. Where and Order By
030. Group By
031. Union [All]
032. Top N [Percent]
033. Logical Operators: And, Or, Not, In, Like, Between, Greater Than Less Than, Exists
034. Order By
035. Having
036. Correlated Subqueries
037. Inner Joins, Outer Joins
038. Table and Column Aliasing
039. Return, WaitFor, GoTo
040. Cross Joins, Self Joins
041. Cross-Server Queries
042. Derived Tables
043. Insert
044. IsDate, IsNull, IsNumeric
045. Deterministic versus Non-Deterministic Functions
046. SubQueries
047. Cursors
048. Control-of-Flow Keywords
049. GetDate(), Day, Month, Year, Time
050. Square Brackets
051. Update … Set
052. Left, Right, Len, Lower, Upper, LTrim, RTrim
053. Replace, Reverse
054. Delete, Truncate
055. Script used for DeleteNonActiveUsers
056. Round, Avg, Count
057. Exp, Power, Rand
058. DateAdd, DateDiff, DateName, DatePart
059. SubString
061. Cast, Convert
062. Using Temp Tables as Filters
063. The Art of SubQuerying in the From
064. Coalesce
065. NewID(), @@RowCount
066. Case
067. Ceiling, Floor
068. @@Error, @@Identity, Identity
069. Finding Duplicates
070. Datetime, some time in the past or in the future, only with date and without time
071. Convert date to and from text
072. Calculate Moving Average
073. In the Zone
074. Do any data manipulation in SQL
075. Answer a series of Questions
076. Use of CTE to build up Joining Filtering of Data
077. Concatenate Output to be ReRun
078. Truncating a Log File
079. Blank out a column
080. Flood One Column Into Another
081. Use part of an string as part of partition to do Row By
082. Updatable Views
083. List SPs in DB
084. Calculate Moving Gradient of Slope and Intersection
085. Use SQL Server as a Calculator
086. Select Column Names in Table(s) or Database
087. Copy on table into another
088. Counting Groups Of, Using GROUP BY
089. Column names containing ‘%something%’ of any tables in a database
090. SQL_List_Server_Jobs
091. Begin Transaction – Rollback – Commit
092. Cross Apply
093. SQL Server Profiler
094. SSRS
095. Select XLS from Query Analyser
096. Restore BAK with set of TRN
097. Bringing it together, Corp Vols Mig example
098. Bringing it together, SunDB Rec example
099. Bringing it together, Programmes BIS example
100. Bringing it together, Avoid Lm24 example
101. Bringing it together, LMS Trans Data example
102. Bringing it together, Business Mentor Last Contact
103. Bringing it together, Sulco Matt MIS CSV example
104. Bringing it together, Justin All Reg Loans example
105. Bringing it together, Loan Rpt Manchester example
106. Bringing it together, Local Outcomes Tracking example
107. Bread and Butter Queries, YBSCRMDEreports example
108. Bread and Butter Queries, BusinessClientsOneToOne example
109. Bread and Butter Queries, Secondments_Dept_Reports example
110. Bread and Butter Queries, SessionsDeliveryPartnersAddresses example
111. Bringing it together, EnquiriesQueriesLast30Days example
112. Database design, PTLanguagesDB example
113. An easy frontend to SQL Server DB backend
114. Well-formed code
115. Using Visual Studio ASP.NET MVC 5 to Create a Database Web Application
116. Using Visual Studio to Create a Mobile Database App
117. Get Sample Databases
118. SET IDENTITY_INSERT
119. Check for current version of SQL server installation
120. Second to last row, and one rows
121. Heavy use of CTE
122. CTE example: Subtotalling, Last row, Flattening multiple rows
123. RowCount function Example 1
124. Rowcounts examples 2
125. Adding to existing, lining two datasets side by side
126. Relational-Column-Row data
127. Technology for Easy and Accurate Data Entry (TEADE)
128. Faking data using Unions
129. No SQL
130. More on Simplified MDM
131. More on Data Science
132. More on Integration
133. More on New SQL
134. More on No SQL
135. Cloud SQL
136. More on SQL
137. More on SQL Home Website
138. Presentation on Database Application (Overview and Basics)
139. Presentation on Databases (Detailed)
140. Presentation on Database Applications (Detailed)
141. Guided Forms]
142. Using Visual Studio ASP.NET Core MVC to Create a Database Web Application
143. MoviesDB Example
144. CountriesDB Example
145. PersonnelDB Example
146. QualificationsDB Example
147. LanguagesDB Example
148. PersonalFinanceDB Example
149. Re-Seed the Identity Column
150. Azure databases
151. Model View Controller (MVC)
152. Amazon Web Services (AWS)
153. Getting Trading Data from the Infinity AT Trading Platform, and Loading it Into SQL Server for Analysis
154. Inner Join in SQL with Contains condition
155. Infinitely New
156. [Doing Writing] Branching to a New Subset
157. Chop Chunk and Chew
158. Experts in Power-Data-Manipulation-Tools
159. Accurate Data Entry
160. Data Query and Calculation Challenges
161. Why Permanent Tables, used Temporarily?
162. Configuring SSRS, Security Issues, 2008 to 2014
163. Query files in a Folder
164. Run the results of a Stored Procedure into a table, iterated in a loop
165. Randomly link to a pick-list
166. Backup and Restore manually in SQL Server
167. Range Day and Month of Any Year
168. First day of next month or nth day of next month
169. Row Number Without Ordering Any Columns
dataprediction.wordpress.com 