Thanks Kenneth

I have used GO separator recursion logic for deleting batches/loading dummy data in development test environments in one time tasks. Good reminder to be careful with your...

Wrap the insert inside a try block and inside the catch block insert to a different table with @MID defined as varchar(50). You would at least know what is happening...

Learned something new. Thanks Steve!

John Mitchell-245523 (7/8/2016)

---

Miguel

Get sp_whoisactive and run it when you see the blocking. That'll tell you who or what is doing it, and you can ask or force them to...

So your excel file should be containing the department I guess. The proper way is to import the excel to a table and then you can use it as a...

Hi Kdanaipam,

This is a SQL server forum. However is there any SQL error you are getting? What do you mean by cascade delete? have you created the FK with' on...

+1

As long as the instance not restarted, or someone manually clears using DBCC, or if all your Sps...

Same here 🙂

The query is more confusing now. Are you trying to compare columns between the two queries in the union? This in not possible.

spaghettidba (6/28/2016)

---

I don't see where the "Quantity" column comes from. Is that the actual query you're running or a simplified version?

However, the message indicates that you're comparing the column "Quantity"...

If you provide table definition as something like below, it is easier to help

Create table [dbo].[1]

(

InvoiceNum INt,

customernum INt,

InvoiceDate Datetime

)

Go

Create table [dbo].[2]

(

InvoiceNum INt,

customernum INt,

InvoiceDate Datetime

)

I am assuming your table definition above.

You...

What does the following return?

SELECT

(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,

(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,

(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,

process_physical_memory_low,

process_virtual_memory_low

FROM sys.dm_os_process_memory;

Yup. But it would be a good homework after a training session on string functions.

Error for SQL server, is invalid connection string

\\srv-apps01\BCMMaster

are you trying to connect a named instance? then it should probably be srv-apps01\BCMMaster.

Charlene, in your case this still could be corruption. Did you try DBCC?