Bit fields in T-SQL Queries? - social.msdn.microsoft.com
Apr 15, 2015 · Here's my problem--I'd like to make this query more readable by using TRUE or FALSE, instead of 1 or 0. I thought that I had read in BOL that T-SQL can convert the string …
Convert Binary to Ascii - social.msdn.microsoft.com
Dec 12, 2006 · In this case set the field to have a data source of a T-SQL statement. In that statement, perform a select of the field you're interested in, but apply the CONVERT () or …
T-SQL equivalent of Guid.Empty - social.msdn.microsoft.com
Oct 7, 2021 · You asked if there was a T-SQL equivalent of Guid.Empty. Now that your question has become more clear I am sorry to say that I don't know of any other syntax; there may be …
How do I aggregate on more than one column within a PIVOT
Mar 6, 2015 · So if anyone can provide me with the syntax on how to aggregate on more than one column within a pivot that would be great.
Monitoring Replication using T-SQL - social.msdn.microsoft.com
Jan 23, 2008 · Thanks for that. Looks like that might be the place to work from. I have also noticed (in case anyone else has this problem) that it does create a table in the tempdb database. I …
T-SQL Foreach in Foreach or How to achieve this?
Mar 21, 2019 · You could have a look at following code to achieve your needs. Besides, next time, please show the T-SQL code to build your table and insert the sample data as followings …
Microsoft Query cannot run SQL code with a T-SQL variables in it?
Oct 17, 2011 · I am unable to use Microsoft Query to return data from a query that includes T-SQL variables. The weird thing is that Microsoft Query handles the data fine, but then has a …
Get The Last Fiscal Week Minus One - social.msdn.microsoft.com
Jun 6, 2017 · For a given Date (let's assume Today's Date, i.e. GetDate ()), It should take the current Fiscal Week Number and get me the dates that fall under same Fiscal Week -1 in the …
change null field of rollup summary - social.msdn.microsoft.com
Apr 12, 2007 · i m using sql server 2005. i m using rollup query to get total sum and sum with group within single query. it shows me total amount but with null field . i want to change this …
is there any TOOL to convert sql code to SQLCMD
Jan 15, 2012 · Why do you require a converter here?. As far as I know SQLCMD also uses the same T-sql syntax. Can you post one sample query that you want to convert ?