• Home
  • Knowledge Base
  • Blog
  • Latest comments
  • Tools and resources
    • Password generator
    • What is my IP?
    • Who is – domain name info
    • Screen colour picker
    • How to convert to MP4 and compress videos
    • WCAG Colour Contrast Analyser
  • About

IT Support Guides

  1. Home
  2. Knowledge Base
  3. SQL

SQL – How to select current year from lookup table

    How to install SQL Management Studio 2008 R2

    • 6

    SQL – How to convert datetime to formatted date string dd-mm-yyyy

      How to generate SQL create table script using phpMyAdmin

        SQL – How to concatenate/combine column values into comma separated text string

          Crystal Reports – Display unique records only

            How to use a REGEX in an SQL SELECT query

              SQL Query – Find invalid email addresses

                SQL – How to decode HTML entities when using FOR XML PATH

                  WordPress – How to use LIKE in WPDB PREPARE SQL statements

                    SQL – How to count unique values in database

                      WordPress – How to use IN in WPDB PREPARE SQL statements

                        SQL – How to remove spaces before and after database values

                          T-SQL – How to use where filter with column alias

                            SQL – How to get current financial year using SQL

                              SQL – How to select current financial year from lookup table

                                SQL – Quick and easy way to performance test SQL statements

                                  MS SQL Server 2008 – How to update value using SELECT results

                                    SQL – How to search with accented characters

                                      SQL – How to convert line separated text to comma separated

                                        Latest Articles

                                        • Excel – How to calculate the difference between two dates
                                        • Windows 10 – How to disable start menu on multiple screens
                                        • Windows 10 – How to tell which version of Windows 10 installed
                                        • Windows 10 – Moving windows between dual monitors get stuck in corner
                                        • How to change decimal precision using Notepad++

                                        Recommended

                                        Knowledge Base Categories

                                        • WordPress
                                        • Windows XP Tips
                                        • Windows 8
                                        • Windows 7
                                        • Windows 10
                                        • Website Tips
                                        • VBS Scripts
                                        • Uncategorized
                                        • Ubuntu
                                        • Technology Tips & Tricks
                                        • SQL Server
                                        • Server stuff
                                        • Server Side Tips
                                        • QGIS
                                        • Online marketing
                                        • Office 2016
                                        • Office 2013
                                        • Notepad-plus-plus
                                        • MySource Matrix
                                        • Microsoft Office 2010

                                        Tags

                                        Adobe Acrobat Adobe Reader CMD ConfigMgr Crystal reports Excel 2013 Excel 2016 Facebook File Explorer Firefox Google Google Chrome Gravity Forms htaccess iPad iPhone iPod jQuery Microsoft Office 2010 Office 2013 Outlook 2010 Outlook 2013 Outlook 2016 PDF PHP phpMyAdmin SCCM Search Silent install SQL SQL Management Studio SQL Server T-SQL TinyMCE TSQL Twitter Ubuntu VLC Media Player Windows 7 Windows 8 Windows 10 Word 2013 Word 2016 WordPress

                                        Latest comments

                                        • Jay Did you meanwhile get this solved?

                                          VBS Script – Get Monitor Serial Number Remotely  ·  17 hours ago

                                        • Jay Hello and thanks a lot for the great script! Unfortunately all clients are shown as OFFLINE in the created Excel file. Windows 7 and Windows 10, Firewall is already turned off. Where I am stumbling...

                                          VBS Script – Get Monitor Serial Number Remotely  ·  yesterday

                                        • Mathias Tøgersen Make sure if you have a newer PC, that the little cover function isn't blocking the camera. Made me do alot of unnecessary tries!

                                          [SOLVED] Lenovo – Built-in webcam camera not working (Windows 10) ·  yesterday

                                        • vivek kumar thanku so much to save my time

                                          How to generate SQL create table script using phpMyAdmin ·  4 days ago

                                        • John Perfect solution thanks

                                          How to bulk remove twitter likes ·  6 days ago

                                        Recent Posts

                                        • 3 reasons to switch to 1.1.1.1 DNS
                                        • 5 ways swim lane workflow diagrams fail
                                        • Blocked folder names in Windows 10
                                        • How to secure your LastPass account and passwords
                                        • Facebook HEARS everything?
                                        • About
                                        • Donate
                                        • Privacy policy
                                        • Copyright
                                        © Copyright IT Support Guides