In order, from school, college to present day. Probably missed a few too.

Commodore PET Basic
ZX Spectrum Basic
Z80 Assembler
Pascal
COBOL
Forth
C
FORTRAN (4 and 77)

Try this

WITH CTE AS (
SELECT UserID, FormID, Answers,
   ROW_NUMBER() OVER(PARTITION BY FormID ORDER BY NEWID()) AS rn
FROM #RankUsers)
SELECT FormID,
   MAX(CASE WHEN rn =...

select

COUNT(CASE WHEN [status] = 'a' THEN 1 END) as [TotalA],

sum(case when [status] = 'a' then price end) as [TotalpriceA],

COUNT(CASE WHEN [status] = 'b' THEN 1 END) as [TotalB],

sum(case...

See if this helps

DECLARE @t TABLE(Name VARCHAR(10) NOT NULL PRIMARY KEY,

Value1 INT NOT...

See if this helps

DECLARE @myTable TABLE(Office VARCHAR(10), yr INT, recruited int, applied INT)

INSERT INTO @myTable(Office, yr, recruited, applied)

VALUES('Pune', 2015, 10, 15),

('Pune', 2016, 7, 20),

('Mumbai', 2015, 10, 23),

('Mumbai',...

> we have a series of total 7 digits and requirment is to find and mark those numbers which contains 6 same digits either in xyyyyyy or yyyxyyy format.

See if...

You'll need to join to a numbers table

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E a, E b

),

E4(n) AS(

...

Looks like a typo, change SPECIALHOURS to SPECIALEVENT

Not really clear what you're asking, maybe this?

SELECT ROW_NUMBER() OVER(PARTITION BY x1.r1 ORDER BY x2.r2) AS [ID],

x2.r2.value('./text()[1]','VARCHAR(30)') AS [DESCRIPTION],

...

Try this

WITH CTE AS (

SELECT Division,

ParentDivision,

ManagerEmail,

FinanceEmail,

...

This is based on the packing interval query by Itzik Ben-Gan, I don't have the URL to hand though

DECLARE @TestTable TABLE(start_date DATETIME, end_date DATETIME);

INSERT INTO @TestTable(start_date, end_date)

VALUES('2016-1-1 10:00:00','2016-1-1 15:00:00'),

...

SELECT Id ,

XmlCol.query('./fullname').value('.', 'nvarchar(max)') AS 'fullname'

FROM @t t

CROSS APPLY t.XmlData.nodes('/News//Photos/Photo')...

Using the splitter here http://www.sqlservercentral.com/articles/Tally+Table/72993/

SELECT t.CONTINENTID,

s1.Item AS COUNTRY,

s3.Item AS CITY

FROM @T t

CROSS APPLY dbo.DelimitedSplit8K(t.COUNTRIES,',') s1

CROSS...