How can I know if LOCK_ESCALATION for a table or database is set to which value in SQL Server 2012?
What is the best method to import database from an old Microsoft SQL version 2000 to our SQL 2014
First of all, I'm sorry I am not SQL expert, but I have to do this tomorrow, so I need a quick starting code to do what I want.
There are 2000 tables I need to update statistics, but last time, it f…
I had this question after viewing Following an example - removing duplicate strings (https://www.experts-exchange.com/questions/28977910/Following-an-example-removing-duplicate-strings.html).
I found this example
To remove duplicate strings. Mine is not comma delimited.…
I have a trigger on a table (like an audit trigger) that updates a backup table whenever the main table is updated. If someone updates the main table "Client", all the changes are captured along with …
Hi Experts ,
Lot of Internet solutions are trying to create a Data table first and map the column SQL bulk instances and try to import the CSV . What if i have 30 to 40 columns . Do i need to all t…
Below is my code. After it is a screenshot.
I want only rows 10 - 18. As you can see, the difference between these rows and the others is that you have more than one "DocumentNumber". …
I get the following error when trying to upgrade SQL 2005 to 2008R2 express. 2005 SQL Express is currently running on a Windows 2008 R2 server which is also a DC.
This can't be that hard but I have 2 tables and data like this
This is SQl 2014
I want to delete from #tempremark the rows that don't exist in #newremark. I don't have an Id field to …
i have a table with these columns
I need a query that pulls the first row for each customerID that has 2 columns, the one column would be the first…
I was thinking to perform some multiple update with sql job, which to set them disabled at specific time and again set it again enable, here is my query, does anyone here have better than a q…
I have a for each look container using folder and filename variables. The initial dataflow task in the for each loop container does a conditional split on the file name (2 different file names) and i…
SQL Express installed on our server ServerA and instance name is SqlExpress which is working fine on the local server, recently we activated windows server after trial expired... then on…
In SQL server default isolation level is readcommitted.
Which isolation level you will suggest to client to change from the readcommitted?
So I have a table setup like this:
DECLARE @temp TABLE(....)
How can I get the column names from this table?
This is SQL 2014
I have this SQL statement but users want the rows to be displayed in specific order
This is the output
I need to order the output in a specific order of "Remark…
How is the collection of the number of males and females in the report the number of c # and sql server
I did the install and enabled TCP in the SQL server manager, The IP or port 1433 does not show up in netstat. What am I missing??
The query needs to return refno:
The refno in table should begin with 1 in a table every year.
If refno 1 is present then give the next value.
Hello Experts Exchange
I have a SQL Agent job that has just ran and ran for its schedule run yesterday.
I want to have a new SQL Agent Job that checks how long the first job has ran for and stop i…
I have a query I use frequently that someone helped me write several years ago, which I often create variations on. I thought I understood exactly what it does, but I am finding a discrepancy with the…
The first block of code below is code that I have embedded in a CTE. That CTE is the second block of code, below.
The first block of code is "cte3" in the CTE code.
As you can see fro…
The source table and Pivot query code are below. The query executes perfectly with 28 WrkCtr columns. However when I add data to the source table that requires the 29th I receive the following error. …
This is SQL 2014
1. I'm using sum to add up a column of values. The column is decimal(18,5)
I run this SQL
select invoicenumber, sum(commission)