http://www.mzan.com/list/tsql/ 2018-01-24 always 1 http://www.mzan.com/article/48420882-refreshing-ssrs-subscriptions-subquestion-how-to-access-report-execution-tim.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48420033-how-to-store-a-result-from-a-table-in-a-variable.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48419480-split-comma-separated-list-and-explode-down-on-condition.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48419082-execute-a-query-at-once-on-several-databases.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48418772-how-to-compare-wheter-a-value-exists-in-a-table.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48418643-azure-stream-analytics-how-to-use-two-azure-machine-learning-function.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48415715-azure-stream-analytics-query-cast-string-to-datetime.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48415660-how-to-select-titles-by-sales-where-sales-less-than-n.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48415523-sql-select-if-that-user-group-combination-has-an-attribute-of-x-dont-return.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48414962-union-all-and-with-statements.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48413707-multiple-inserts-with-the-id-coming-from-scope-identity.shtml 2018-01-24 always 0.9 http://www.mzan.com/article/48412799-join-on-partial-column-to-compare-erp-crm-codes.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48412158-tsql-what-am-i-doing-wrong-with-my-partition-by.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48412009-executing-a-proc-which-saves-tran-in-a-transaction-got-error-of-mismatching-num.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48411273-default-constraint-for-datetime-column-is-not-getting-the-correct-time.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48411240-how-to-update-a-table-based-on-criteria-from-that-same-table.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48410448-sql-server-stored-procedure-filter-table-on-one-to-many-relationships.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48410302-sql-server-query-make-column-not-computable-when-running-a-query.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48410070-list-records-after-recursivity.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48409191-is-it-possible-to-create-a-notification-trigger-for-any-change-or-update-to-all.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48406742-delete-duplicate-rows-in-sql.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48405191-computed-column-vs-updates-in-sql-server.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48404826-delete-bak-files-from-unc-share-paths-by-using-stored-procedure.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48404688-selecting-maxdate-from-table-that-has-multiple-rows-with-similar-information.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48403929-how-to-store-a-value-from-scalar-function-in-a-variable.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48400539-sql-where-clause-only-returning-one-of-the-results-when-there-is-2-expected-resu.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48400432-optimize-triangular-join-in-large-data.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48400206-query-sql-statistics-without-set-parameter.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48398399-how-to-calculate-average-value-using-functions.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48395652-inserting-multiple-rows-to-a-table-which-references-itself.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48395407-replacing-part-of-the-string-in-sql-with-different-patterns.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48394462-how-do-you-read-json-data-sent-by-sql-server-in-c.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48394140-within-where-clause-nested-case-when-statement-to-return-result-with-or.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48394002-select-columns-but-group-by-two-specific-columns-in-sql.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48393692-entity-framework-6-code-first-udt.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48393464-there-is-already-an-object-named-t1-in-the-database.shtml 2018-01-23 always 0.9 http://www.mzan.com/article/48391561-sql-getting-around-having-to-do-bitshift-on-binary-column.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48391298-identify-all-holiday-dates-by-year-using-tsql.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48391031-sql-server-transact-sql-find-time-conflicts-in-reservations.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48389388-week-number-to-date-sql.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48389326-rolling-up-records-in-triplicate-nested-case-statement-or-loops.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48389279-xp-cmdshell-user-is-not-listing-newly-created-user-customuserx.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48389136-sql-convert-columns-to-rows.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48386263-pivot-table-in-sql-column-results-to-rows.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48386151-bulk-insert-csv-trouble.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48385959-using-an-isnull-in-a-left-join-with-cast-stuff-and-patindex-to-change-the-join.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48385836-if-else-statement-in-stored-procedure.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48385812-stored-procedure-inside-cursor-not-updating-local-variable-from-output-parameter.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48385303-merge-2-doublet-records-together-before-deleting-the-doublet-record.shtml 2018-01-22 always 0.9 http://www.mzan.com/article/48384397-finding-deltas-between-two-tables.shtml 2018-01-22 always 0.9