forums.sqlteam.com

• charset: utf-8
• name: description content: SQL Server forums
• name: discourse_theme_id content: 1
• name: discourse_current_homepage content: latest
• name: generator content: Discourse 2026.1.4 - https://github.com/discourse/discourse version ec5d54b3291729ec201615c64d954545000896b9
• name: theme-color media: all content: #fff
• name: color-scheme content: light
• name: viewport content: width=device-width, initial-scale=1.0, minimum-scale=1.0, viewport-fit=cover, interactive-widget=resizes-content
• name: fragment content: !
• id: data-ga-universal-analytics code: UA-222470-11 json: {"cookieDomain":"auto"} domains:
• property: og:site_name content: SQLTeam.com Forums
• property: og:type content: website
• name: twitter:card content: summary
• name: twitter:image content: https://forums.sqlteam.com/uploads/db8100/original/2X/8/8f9454bac5f9d252bb083c9b4ac532c2926d45e4.jpeg
• property: og:image content: https://forums.sqlteam.com/uploads/db8100/original/2X/8/8f9454bac5f9d252bb083c9b4ac532c2926d45e4.jpeg
• property: og:url content: https://forums.sqlteam.com/
• name: twitter:url content: https://forums.sqlteam.com/
• property: og:title content: SQLTeam.com Forums
• name: twitter:title content: SQLTeam.com Forums
• property: og:description content: SQL Server forums
• name: twitter:description content: SQL Server forums
• id: -1 url: service-worker.js uri: environment: production version: bb8405373cd784f57a5ac278cc3ee87c locale: en css: false path: /svg-sprite/forums.sqlteam.com/svg-1-792151f273e754491fbcd070070756e96f35f538.js bundle: /assets/chunk.d3eca2420fc946046ce7.d41d8cd9.js dark: false
• name: discourse/config/environment content: %7B%22modulePrefix%22%3A%22discourse%22%2C%22environment%22%3A%22production%22%2C%22rootURL%22%3A%22%22%2C%22locationType%22%3A%22history%22%2C%22EmberENV%22%3A%7B%22FEATURES%22%3A%7B%7D%2C%22EXTEND_PROTOTYPES%22%3Afalse%7D%2C%22APP%22%3A%7B%22name%22%3A%22discourse%22%2C%22version%22%3A%222026.1.4%20ec5d54b3291729ec201615c64d954545000896b9%22%7D%7D
• equiv: origin-trial content: AlK2UR5SkAlj8jjdEc9p3F3xuFYlF6LYjAML3EOqw1g26eCwWPjdmecULvBH5MVPoqKYrOfPhYVL71xAXI1IBQoAAAB8eyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: Amm8/NmvvQfhwCib6I7ZsmUxiSCfOxWxHayJwyU1r3gRIItzr7bNQid6O8ZYaE1GSQTa69WwhPC9flq/oYkRBwsAAACCeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: A9nrunKdU5m96PSN1XsSGr3qOP0lvPFUB2AiAylCDlN5DTl17uDFkpQuHj1AFtgWLxpLaiBZuhrtb2WOu7ofHwEAAACKeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A93bovR+QVXNx2/38qDbmeYYf1wdte9EO37K9eMq3r+541qo0byhYU899BhPB7Cv9QqD7wIbR1B6OAc9kEfYCA4AAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A1S5fojrAunSDrFbD8OfGmFHdRFZymSM/1ss3G+NEttCLfHkXvlcF6LGLH8Mo5PakLO1sCASXU1/gQf6XGuTBgwAAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9

• Forums
• Skip to main content
• http://forums.sqlteam.com/
• http://forums.sqlteam.com/latest
• http://forums.sqlteam.com/hot
• http://forums.sqlteam.com/categories
• http://forums.sqlteam.com/t/welcome-to-the-microsoft-sql-server-forums-at-sqlteam-com/8
• http://forums.sqlteam.com/u/system
• http://forums.sqlteam.com/u/robert_volk
• http://forums.sqlteam.com/u/kristen
• http://forums.sqlteam.com/u/waterduck
• http://forums.sqlteam.com/u/joy78946
• http://forums.sqlteam.com/t/welcome-to-the-microsoft-sql-server-forums-at-sqlteam-com/8/1
• http://forums.sqlteam.com/t/welcome-to-the-microsoft-sql-server-forums-at-sqlteam-com/8/79
• DT_IMAGE, which is not supported. Use DT_TEXT or DT_NTEXT instead
• http://forums.sqlteam.com/c/ssis-and-import-export/14
• sql2008r2
• http://forums.sqlteam.com/u/quattrodave
• http://forums.sqlteam.com/u/harishgg1
• http://forums.sqlteam.com/u/ifor
• http://forums.sqlteam.com/t/dt-image-which-is-not-supported-use-dt-text-or-dt-ntext-instead/27786/1
• http://forums.sqlteam.com/t/dt-image-which-is-not-supported-use-dt-text-or-dt-ntext-instead/27786/10
• Using Logic of Inaccessible Function
• http://forums.sqlteam.com/c/t-sql/12
• http://forums.sqlteam.com/u/mahm
• http://forums.sqlteam.com/t/using-logic-of-inaccessible-function/27788/1
• http://forums.sqlteam.com/t/using-logic-of-inaccessible-function/27788/2
• Extract pattern from a string?
• http://forums.sqlteam.com/u/yankleber
• http://forums.sqlteam.com/u/jeffmoden
• http://forums.sqlteam.com/u/jamesk
• http://forums.sqlteam.com/t/extract-pattern-from-a-string/6444/1
• http://forums.sqlteam.com/t/extract-pattern-from-a-string/6444/9
• Rollup or summary for derived column doesnt produce a grand total
• http://forums.sqlteam.com/u/sql2017
• http://forums.sqlteam.com/u/scottpletcher
• http://forums.sqlteam.com/u/memilee
• http://forums.sqlteam.com/u/henrywilson2278
• http://forums.sqlteam.com/t/rollup-or-summary-for-derived-column-doesnt-produce-a-grand-total/9878/1
• http://forums.sqlteam.com/t/rollup-or-summary-for-derived-column-doesnt-produce-a-grand-total/9878/10
• Extract string between 2nd set of repeating characters
• http://forums.sqlteam.com/u/frank43
• http://forums.sqlteam.com/u/yosiasz
• http://forums.sqlteam.com/t/extract-string-between-2nd-set-of-repeating-characters/21530/1
• http://forums.sqlteam.com/t/extract-string-between-2nd-set-of-repeating-characters/21530/8
• Payroll System database with ledger system
• http://forums.sqlteam.com/u/redrose4u293
• http://forums.sqlteam.com/u/thinkingbridge
• http://forums.sqlteam.com/t/payroll-system-database-with-ledger-system/24101/1
• http://forums.sqlteam.com/t/payroll-system-database-with-ledger-system/24101/2
• Sql top list
• http://forums.sqlteam.com/u/apy
• http://forums.sqlteam.com/u/ahmeds08
• http://forums.sqlteam.com/u/gbritton
• http://forums.sqlteam.com/t/sql-top-list/12006/1
• http://forums.sqlteam.com/t/sql-top-list/12006/10
• Join based on the maximum letter match from other Table
• http://forums.sqlteam.com/u/chit
• http://forums.sqlteam.com/t/join-based-on-the-maximum-letter-match-from-other-table/21447/1
• http://forums.sqlteam.com/t/join-based-on-the-maximum-letter-match-from-other-table/21447/9
• Not able to get the exact count from 2 table join
• sql2012
• http://forums.sqlteam.com/u/balajis2021
• http://forums.sqlteam.com/t/not-able-to-get-the-exact-count-from-2-table-join/21604/1
• http://forums.sqlteam.com/t/not-able-to-get-the-exact-count-from-2-table-join/21604/12
• To Decide timein timeout roster after an employees actual incoming time. A case of difficult order by
• http://forums.sqlteam.com/u/mateen
• http://forums.sqlteam.com/t/to-decide-timein-timeout-roster-after-an-employees-actual-incoming-time-a-case-of-difficult-order-by/19352/1
• http://forums.sqlteam.com/t/to-decide-timein-timeout-roster-after-an-employees-actual-incoming-time-a-case-of-difficult-order-by/19352/4
• Very very difficult query
• http://forums.sqlteam.com/t/very-very-difficult-query/23554/1
• http://forums.sqlteam.com/t/very-very-difficult-query/23554/11
• SQL - Purchase Order and Invoice duplicate amount
• http://forums.sqlteam.com/u/mike_2025
• http://forums.sqlteam.com/u/rogierpronk
• http://forums.sqlteam.com/t/sql-purchase-order-and-invoice-duplicate-amount/27686/1
• http://forums.sqlteam.com/t/sql-purchase-order-and-invoice-duplicate-amount/27686/13
• Pivot Tables in SQL
• http://forums.sqlteam.com/u/riaan
• http://forums.sqlteam.com/u/mike01
• http://forums.sqlteam.com/u/carlwalk
• http://forums.sqlteam.com/t/pivot-tables-in-sql/27709/1
• http://forums.sqlteam.com/t/pivot-tables-in-sql/27709/7
• Getting a sum for date ranges of 7 days when there are missing dates
• http://forums.sqlteam.com/u/titan
• http://forums.sqlteam.com/t/getting-a-sum-for-date-ranges-of-7-days-when-there-are-missing-dates/27658/1
• http://forums.sqlteam.com/t/getting-a-sum-for-date-ranges-of-7-days-when-there-are-missing-dates/27658/8
• Matching test dates to first entrance date
• http://forums.sqlteam.com/u/grifter
• http://forums.sqlteam.com/u/khtan
• http://forums.sqlteam.com/t/matching-test-dates-to-first-entrance-date/27762/1
• http://forums.sqlteam.com/t/matching-test-dates-to-first-entrance-date/27762/6
• SUBSTRING Functions
• http://forums.sqlteam.com/u/sqlhippo
• http://forums.sqlteam.com/t/substring-functions/27690/1
• http://forums.sqlteam.com/t/substring-functions/27690/7
• Get the lowest of 3 column values greater than zero
• http://forums.sqlteam.com/u/wembleybear
• http://forums.sqlteam.com/t/get-the-lowest-of-3-column-values-greater-than-zero/24432/1
• http://forums.sqlteam.com/t/get-the-lowest-of-3-column-values-greater-than-zero/24432/6
• Adding a new column to existing table
• http://forums.sqlteam.com/u/pmj
• http://forums.sqlteam.com/t/adding-a-new-column-to-existing-table/27781/1
• http://forums.sqlteam.com/t/adding-a-new-column-to-existing-table/27781/15
• Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508
• http://forums.sqlteam.com/t/need-to-generate-shift-rotation-weekwise-rather-7-day-wise-for-the-yearmonth-202508/27735/1
• http://forums.sqlteam.com/t/need-to-generate-shift-rotation-weekwise-rather-7-day-wise-for-the-yearmonth-202508/27735/13
• Missing month
• http://forums.sqlteam.com/t/missing-month/18939/1
• http://forums.sqlteam.com/t/missing-month/18939/24
• To find sandwich holidays
• http://forums.sqlteam.com/t/to-find-sandwich-holidays/18475/1
• http://forums.sqlteam.com/t/to-find-sandwich-holidays/18475/11
• How do I order a list with entries like x.xy.z?
• http://forums.sqlteam.com/u/barnabeck
• http://forums.sqlteam.com/t/how-do-i-order-a-list-with-entries-like-x-xy-z/16342/1
• http://forums.sqlteam.com/t/how-do-i-order-a-list-with-entries-like-x-xy-z/16342/12
• Putting a sum and a count into a pivot?
• http://forums.sqlteam.com/t/putting-a-sum-and-a-count-into-a-pivot/27664/1
• http://forums.sqlteam.com/t/putting-a-sum-and-a-count-into-a-pivot/27664/7
• Query almost perfect but brings wrong record
• http://forums.sqlteam.com/u/pk400i
• http://forums.sqlteam.com/t/query-almost-perfect-but-brings-wrong-record/27578/1
• http://forums.sqlteam.com/t/query-almost-perfect-but-brings-wrong-record/27578/6
• High Availability Connection problem
• http://forums.sqlteam.com/u/denis_the_thief
• http://forums.sqlteam.com/t/high-availability-connection-problem/27779/1
• http://forums.sqlteam.com/t/high-availability-connection-problem/27779/3
• Full outer join on every row (scaffolding)
• http://forums.sqlteam.com/u/uganda
• http://forums.sqlteam.com/t/full-outer-join-on-every-row-scaffolding/27780/1
• http://forums.sqlteam.com/t/full-outer-join-on-every-row-scaffolding/27780/3
• Designing SQL Database for Museum Membership System .NET Facing Issues with Visitor Data
• http://forums.sqlteam.com/c/other-sql-server-topics/18
• http://forums.sqlteam.com/u/wohokas
• http://forums.sqlteam.com/t/designing-sql-database-for-museum-membership-system-net-facing-issues-with-visitor-data/27775/1
• http://forums.sqlteam.com/t/designing-sql-database-for-museum-membership-system-net-facing-issues-with-visitor-data/27775/2
• Reverting or rollback on an Availability Group upgrade to new nodes
• http://forums.sqlteam.com/c/high-availability/16
• http://forums.sqlteam.com/u/graz
• http://forums.sqlteam.com/t/reverting-or-rollback-on-an-availability-group-upgrade-to-new-nodes/27751/1
• http://forums.sqlteam.com/t/reverting-or-rollback-on-an-availability-group-upgrade-to-new-nodes/27751/3
• Error 1204 every 13-15 minutes
• http://forums.sqlteam.com/c/sql-server-administration/13
• http://forums.sqlteam.com/u/johnny_lude
• http://forums.sqlteam.com/t/error-1204-every-13-15-minutes/27749/1
• http://forums.sqlteam.com/t/error-1204-every-13-15-minutes/27749/2

• SQLTeam.com
• Weblogs

            Domain Name: SQLTEAM.COM
Registrar: Tucows Domains Inc.
Domain Status: client transfer prohibited
Domain Status: client update prohibited
Creation Date: 2000-06-22T01:13:32Z
Registry Expiry Date: 2027-06-22T01:13:32Z
Updated Date: 2026-06-21T08:35:37Z
Name Server: NS1.HOVER.COM
Name Server: NS2.HOVER.COM
REGISTRAR Contact: Tucows Domains Inc.
>>> Last update of RDAP database: 2026-06-22T01:23:31Z         

			# See https://datatracker.ietf.org/doc/rfc9309 for documentation on how to use the robots.txt file
# Google uses the same format as the standard above. More info at https://developers.google.com/search/docs/crawling-indexing/robots/robots_txt

#
User-agent: mauibot
Disallow: /


User-agent: semrushbot
Disallow: /


User-agent: ahrefsbot
Disallow: /


User-agent: blexbot
Disallow: /


User-agent: YandexBox
Disallow: /


User-agent: bingbot
Disallow: /


User-agent: baiduspider
Disallow: /


User-agent: MegaIndex.ru
Disallow: /


User-agent: VelenPublicWebCrawler
Disallow: /


User-agent: Clickagy
Disallow: /


User-agent: *
Disallow: /admin/
Disallow: /auth/
Disallow: /assets/browser-update*.js
Disallow: /email/
Disallow: /session
Disallow: /user-api-key
Disallow: /*?api_key*
Disallow: /*?*api_key*
Disallow: /badges
Disallow: /my
Disallow: /search
Disallow: /tag/*/l
Disallow: /g
Disallow: /t/*/*.rss
Disallow: /c/*.rss


User-agent: Googlebot
Disallow: /admin/
Disallow: /auth/
Disallow: /assets/browser-update*.js
Disallow: /email/
Disallow: /session
Disallow: /user-api-key
Disallow: /*?api_key*
Disallow: /*?*api_key*



Sitemap: https://forums.sqlteam.com/sitemap.xml


        

Technical SEO

On-Page SEO

Content and UX