Thursday, February 02, 2012

Burke Bartow - Highlight Videos, Schedule & Roster - Hudl

Burke Bartow - Football Lineman Highlight Videos on Hudl

O Line - Right Guard (protect quarterback from the incoming defensive line and linebackers during pass plays)
D Line - Defensive Tackle (the largest and strongest of the defensive players)

Friday, December 09, 2011

Foreign Language Months and Days syslanguages f

SELECT * FROM sys.syslanguages
GO

DECLARE @langid int = 6 -- Italian

-- use row_number without an order by using (select 0) ...
-- needed for dropdownlist select options where value =id (row_number)

-- create two temporary tables with bogus row numbers as ID then join them together

SELECT row_number() over(order by (select 0)) AS [ID]
, item AS [ShortMonth]
, CAST(N'' AS nvarchar(20)) AS [Month]
INTO #T
FROM [dbo].[CSV2Table]( (SELECT shortmonths
FROM sys.syslanguages
WHERE langid= @langid)
, ',') 

SELECT row_number() over(order by (select 0)) AS [ID]
, item AS [Month]
INTO #T2
FROM dbo.[CSV2Table]( (SELECT months
FROM sys.syslanguages
WHERE langid= @langid)
, ',')

 
-- Perform an INNER JOIN Update based on the bogus IDs

UPDATE #T SET Month = #T2.Month
FROM #T2 INNER JOIN #T ON #T2.ID = #T.ID

SELECT * FROM #T

DROP TABLE #T
DROP TABLE #T2


Follow by Email

Young Roofers

Young Roofers
Men Making

Fly. Be Free.

Fly. Be Free.
Man Ready to Hang ... Glide

Burke

Burke
A Man in the Making - 12 years old

Blackwater

Blackwater
A Man in the Mud

Jules Bartow

My photo

Jules' career spans a gamut of interesting situations: running the Israeli Defense Forces (IDF) initiation trail to the top of Masada overlooking the Dead Sea, cross-country skiing in Russia with Federal Security Service (FSB) at 2:00 am,  processing prisoners in the infamous Abu Guraib  Prison in Iraq, architecting the F-35 Joint Strike Fighter software design, monitoring satellite operations for the NSA and NGA, and researching microwaving tumors.