2012-06-26 (first published: 2012-06-07)
1,430 reads
2012-01-20 (first published: 2011-12-16)
1,007 reads
Return CSV column in separate rows
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,528 reads
2011-12-08 (first published: 2011-11-23)
1,127 reads
2011-08-04 (first published: 2011-07-25)
3,132 reads
2011-07-12 (first published: 2011-07-01)
1,124 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,308 reads
2011-04-27 (first published: 2011-04-21)
2,735 reads
Query to get tables with no clustered indexes
Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)
2011-02-14 (first published: 2011-01-28)
1,831 reads
2011-01-17 (first published: 2011-01-05)
7,076 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Reducing the Cycle Time
Comments posted to this topic are about the item Reducing the Cycle Time
SQL Server migration using replication
I've set up replication in my SQL 2019 environment in attempt to migrate SQL...
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers