If statement within a select statement - social.msdn.microsoft.com
Apr 15, 2012 · Code Snippet select ProductID, ProductName = [Name], PremiumListPrice = case Color when 'Blue' then ListPrice * 1.1 when 'Silver' then ListPrice * 1.2 when NULL then 0.0 when 'Yellow' …
How to select a case sensitive value in SQL with C#
Mar 29, 2017 · In order to get the case senstive to work, go inside SQL 2005 and right click the column and choose modify. Under neith the table designer field click the Collation button which will bring you …
Unable to access SSIS package - social.msdn.microsoft.com
Sep 4, 2007 · I'm able to execute the package using the Execute Package Utility on my local version of SQL Server 2005, and the text file is written correctly. It just doesn't happen using the Web Services …
Index rebuild job Failed, need solution.
Apr 10, 2017 · However, I would recommend that prior to openning case you check that you are on the latest service pack (you could post the output of SELECT @@version and we can tell you), and if …
RDLC LocalReport Render with SubReports and nested subreports
Oct 18, 2012 · The first problem report is a job list - jobs between dates with staff and the equipment they need for the job. In SSRS the old system has a report "jobs", with "staff" sub-report and inside …
Want to pass list in sql query - social.msdn.microsoft.com
Dec 3, 2015 · Danyal, put a breakpoint on the line where you actually execute the code. Get the value of 'query' which is what is being sent to SQL. Paste that query into SQL and confirm that you're getting …
AdentureWorks 2005 or 2008????? - social.msdn.microsoft.com
Oct 17, 2009 · It is set to 10 _ If in the name of the database, you have not 2008, it is a database foreseen to be installed on a SQL Server instance 2005 ( but you may install it on a SQL Server …
SSIS Pre Execute Delay - social.msdn.microsoft.com
Feb 15, 2017 · ID and type = 'DM Remark' and ID in (select ActionID from dbo. WH_ActionAttribute where value = 'Deceased notification') order by date asc), 103), '') as 'Date Notified of Death', case …
SQL Server 2000 - Availability whilst restoring logs
Aug 1, 2006 · I am therefore assuming that there is no way to keep a system 'live' for select queries whilst updating it in SQL 2000? I am currently providing views on some tables held in a SQL 2000 …
SQL server remote connection using FQDN - social.msdn.microsoft.com
Jul 6, 2010 · In this case, when connecting SQL Server by using IP, it might be using TCP/IP. When connecting SQL Server through FQDN, Named Pipes might be used. To narrow down the issue, you …