Help Slow Query using User Defined Function
May 3, 2011 · In general you should avoid scalar value functions that join to tables simply because if that function is used in a query that returns multiple rows then it's joining those …
Dynamic Sql Pivot- how to sort columns - social.msdn.microsoft.com
Jan 16, 2020 · The problem is the columns are not in chronological order. SO I need to sort them by date. However, if I add an ORDER BY clause like this: DECLARE @DynamicPivotQuery …
Parse SQL Statement with RegEx - social.msdn.microsoft.com
Sep 21, 2010 · I'm trying to parse the expressions in a SQL where clause using RegEx in c#. I control the query so the format will always be the same. Example: select customer_id from xx …
Issues with Power query in SSIS and SSAS 2017 (New Experience …
Aug 5, 2019 · SSIS supports Power Query as a Source, but do not seem to support M code using a function.
How to write IF condition in SSRS Dataset?
Apr 14, 2016 · I would like to write a SQL SELECT statement based on the user input parameter. i.e. I will have a query list box for user to choose which year to query the data.
SSRS Cube Filter by Date Range (Inclusive)
Mar 31, 2017 · In the query designer, I parameterized the Closed Date by checking the two checkboxes. I changed the generated two parameters to be Date/Time type. Also set the …
Pivot by Year+Month - social.msdn.microsoft.com
Aug 24, 2017 · I am working to pivot date variable by Year+Month. I have a medication order table, I need to have one row per patient per medication with flags by month/year saying 'Yes' …
SQL Statement Not Like doesn't work - social.msdn.microsoft.com
Mar 14, 2013 · Maybe there's something wrong with the way Access is now parsing the query to pass it to SQL Server. Try defining the query as a SQL pass-through query, so that Access …
T-SQL 2008 R2 add duration (HH:MM:SS) to date column?
Jul 15, 2011 · I would like to add Duration (HH:MM:SS) column to Orader date and below is query result I am looking for : OrderDate Duration OrderDate_AddedDuration 2011-07-15 08:45:30 …
Can I get a formatted SQL Server Date to sort correctly???
Oct 2, 2013 · Why are you writing 1960's Cobol in T-SQL? SQL has temporal data types. You do not turn the date into a string literal and then wonder why it sorts like a string? In fact, the …