Need script to DROP and CREATE user created Statistics
Sep 22, 2016 · We have an script that ALTERs the size and type of several hundred columns. One of out customers has some user created statistics on some of these columns. Pretty easy to get a script …
XML Row By Row in Sql Server - social.msdn.microsoft.com
Apr 9, 2018 · This is not possible using a normal T-SQL query, unless you do a sub query for each row, and collect the results of the subquery into a format suitable to store those multiple results in a single …
Passing XML into a SSRS report from c# - social.msdn.microsoft.com
Dec 6, 2010 · If I understand correctly, you are using XML data source in a server report (a report with extension .rdl, and has been deployed to a Report Server). Now, you want to know, if it is possible to …
Proper Case - am I missing something? - social.msdn.microsoft.com
Aug 23, 2010 · Hi. Recently I have been looking at the proper case/mixed case/camel case issue. This forum has been helpful, and so have the blogs, but I don't want to use FOR XML because of the …
Generate Dynamic column based on SQL output
Dec 24, 2018 · In SSIS, you can use Script Task to concatenate the SQL Command dynamically, according to the package start date. If you can share the table script (data type) and tell us more …
Reading XML Data from another server - social.msdn.microsoft.com
Apr 3, 2008 · You can use an XML source to read data from the XML file and use an OLEDB Destination (or SQL Server Destination in case your target database is local) to upload the data from the XML file …
The xml data type cannot be selected as DISTINCT because it is not ...
if i place distinct before id then I am getting the error The xml data type cannot be selected as DISTINCT because it is not comparable.
Looping through column names and make alias names using CURSOR
Oct 26, 2011 · If the number of tables are such that this calls for a programmatic solution, I would probably have written a Perl script to generate the SQL code. Perl is a more powerful language when …
SSAS security- give access to users present in table
Mar 26, 2014 · Create an xml template from above snippet and insert the <members> node by using a sql select result from your database:
SQL Server 2008 R2 Express service crashes on Windows Server 2012
Aug 21, 2013 · I am trying to deploy our application that uses SQL Server 2008 R2 Express (SP1 I believe) to a Windows Server 2012 Standard virtual machine (using VMWare Workstation 9.0.2). The …