GitHub

GBP_TransportBreakageLeakageClaim_PRINT.sql

select e.DeliveryNote , e.PWSNo , convert(varchar,b.TRNDATE,23) InvoiceDate , f.NAME DistributorName , e.TRANSPORTER TransportName , m.DESCA [Description] , (isnull(c ...
IEEE

Generate Text-to-SQL Queries Based on Sketch Filling

Abstract: The Text-to-SQL task has significant application prospects in automating relational database query interfaces. It can reduce user learning costs and improve data query efficiency. However, ...
GitHub

SQL Server Perf Stats.sql

SELECT @cpu_time_start = cpu_time, @elapsed_time_start = total_elapsed_time FROM sys.dm_exec_sessions WHERE session_id = @@SPID IF OBJECT_ID ('tempdb.dbo.#tmp_requests') IS NOT NULL DROP TABLE ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
Ars Technica

Crystal Report. Multiple if isnull statements

I am trying to format addresses from SAP B1 to Crystal Reports where the default address formatting from SAP B1 is very limited. Problem is I am running into an issue with my code where if I run into ...
TechRepublic

See performance gains by using indexed views in SQL Server

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...
TechRepublic

Learn the differences between Is Null and IsNull() in Access

How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps that ...