Delete syntax not working - hi, Here is the delete syntax but it is not working even though all the conditions satisfy. What is the issue? DELETE...
Get the SSIS Package names from database - Dear all, Can you please let me know how can I get the names of all the SSIS packages that I...
The cluster IP address is already in use error while installing SQL 2016 Failover Cluster - We have 2 nodes, both were running SQL 2014 cluster. We had to upgrade the windows OS to 2016, the...
Very challenging TSQL Query - Hi Experts, I have a table (test) with the following data :
T-SQL Help on same table join - Hi SQL View SELECT a.Name , Q0.Value, Q.1.Value,Q2.Value FROM A with (nolock) Left Outer join B AS Q0 ON Q0.FK_ID = A.ID AND Q0.Type...
Integration Services Catalogue (SSISDB) - Cannot return free space to operating system. - We have the SSISDB database which stores log information of jobs that are run. It was initially set to retain...
Why is my T-SQL code so slow with its output? - Select Invoice_Exceptions.Invoice_Number as Invoice#, FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy') as Void_Date, Invoice_Exceptions.ItemNum as Item_#_Removed, Inventory.ItemName, '$'+CONVERT(varchar(10), CAST(Invoice_Exceptions.Amount as money)) as Amount, CONVERT(varchar(10),...
could some one help me with the query below - ExecuteSql"(varchar(max),"USE MASTER declare @isql varchar(2000), @dbname varchar(64), @logfile varchar(128) declare c1 cursor for SELECT d.name, mf.name as logfile--, physical_name AS current_file_location, size FROM sys.maste
TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO - Hi guys, i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than executing these commands separately ? Conditions: recovery...
Using a case statement to determine join - I have a query that uses several left outer joins. I am attempting to alter the join to include a...
SQL server service account is locking out - Hi, we are seeing one of our service account getting locked out for every fifteen minutes, we have two domains(ex. A and...
Local Variable table Update values not coming correct while passing two Name in the query - Hi Experts I am trying to use local variable table , the code works fine , if the NAME IN ( 'NAME1') is only...
Query Help - I have been look at this all day and need some other eyes, when I run the query below I...
Help with Trigger - I need to create a Trigger that creates a new quote no everytime a new opportunity is created. The quote no...
Unable to access Reporting services reports from application - We have configured the reporting services to view the application reports. Report server is hosted in one system and application...
Incremental load solution to track the changes - Loading the data 70 Million records from IBM DB2 to SQL Server Problem – 1. Need to have incremental data solution 2. ...
Script Task to check file existance is OK in Visual Studio but fails when Deployed - Hi, Within a Foreach loop, I have a simple Script Task to check if a file exists. If it exists, then FTP...
Writing Test Cases for T-SQL Code - I'd love some articles that look at a piece of code you've written (query/batch/proc) and then what test cases or...
Identify the Column for 'String or binary data would be truncated' - Hi, Has anyone got a way to identify which column is to blame when encountering error 'String or binary data would...
Project Plan - I'm looking for a decent Project Plan (in any format) for moving from SQL Server 2000 to a SQL Server...