Search - Joel Lipman .Com

21. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' ...; Created on 03 August 2011
22. SSRS / MDX Date Queries: / SQL Server Reporting Services /; ... my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d", ...; Created on 03 August 2011
23. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes ...; Created on 19 July 2011
24. Inserting incremental weeks in MySQL: / MySQL /; ... in with a normal calendar date and returns an academic week number and the week commencing date. Problem? The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer ...; Created on 15 April 2011
25. MySQL: Find records in one table that are not in another.: / MySQL /; ... 4367 rows returned. ApprovalID ArticleID DateSigned ---------------- ------------------ --------------------- 17 1144 2010-06-18 12:25:22 The How ...; Created on 25 February 2011
26. Returned a data type that is not valid: / Transact-SQL /; ... (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare in SQL Server Reporting Services and that all data types should be kept in their original state ...; Created on 06 January 2011
27. SQL Queries for Statistics: / MySQL /; ... ID, a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT ...; Created on 13 December 2010
28. The Sandpit: / Graphic Design /; ... just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day in the life of New York City". More Information can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html ...; Created on 26 September 2010
29. Joe's Unduplicater (JUD: / Product Documentation /; ... (12/07/2010) - Added option to ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - ...; Created on 12 July 2010
30. Web Browsers Release Year: / Web-Development /; ... Flock 2, Chrome 1, Amaya 11.0 1565 2009 Internet Explorer 8, Chrome 2, Safari 4, Opera 10, Chrome 3, SeaMonkey 2, Camino 2, Firefox 3.5 1734 2010 ...; Created on 18 May 2010
31. Windows 7 Aero Features: / Windows OS /; ... Aero Flip 3D to a shortcut command: Visit http://www.paraesthesia.com/archive/2010/04/16/fun-with-windows-aero-flip-3d.aspx as this was not my idea but quite ingenious and worth a mention. ...; Created on 27 April 2010
32. Remove write-protect from USB pen in Windows: / Windows OS /; ... then search for “AH128 Handy Steno Repair Tool” released in 2010 and should be about 3.57Mb). I have tried other rescue programs which caused even more errors (had to return the pen for another and ...; Created on 13 April 2010
33. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; ... licenses Unlimited RokTools 224 €* ($300) Support Thu 22:00 April 2010 Established ...; Created on 08 April 2010
34. Windows 7 and Google Chrome incognito mode by default: / Google /; Basically if you've just started using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All ...; Created on 24 March 2010
35. Timeline: Created on 08 April 2017