Using SQL2012, you have the TABLEDIFF option. I'd look into that. Each table would need a PK though. You tell it which is the source database/table and the...

Basic Problem Solving Skills checklist:

1. post issue on SQL Server Central without examples or all the details

2. if you don't get...

While probable not quite accurate...the way to think about is this way...when using a single # think of it as being owned by the schema that made it:

Conn1.temp01

Conn2.temp01

When using a...

JALLYKAMOZE (8/30/2016)

---

Hello,

I have a problem where i want to get the diffrence in minutes between two times, my datatype is TIME, i have also used the function below

ABS(DATEDIFF (MINUTE,...

A couple of suggested Error messages:

--If the parameter is NULL return:

Parameter is not supplied. This stored procedure requires one parameter.

--If no data is found return:

Data not found based on supplied...

Matt Miller (#4) (8/25/2016)

---

Eric M Russell (8/25/2016)

---

Matt Miller (#4) (8/25/2016)

---

SQLBill (8/25/2016)

---

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up...

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original government IT contractors. When...

Debby

Debby

But isn't your results from two different weeks (week 26 and week 27)? Why would you be combining them into one week? Shouldn't it be the first two...

Another option is to create a job. One of the schedule options for jobs is "Start Automatically when SQL Agent starts".

-SQLBill

Heck with floppies...my first computer used a cassette tape.

-SQLBill

Here's an example of using BCP:

use info

go

declare @sql varchar(2000), @command varchar(2000)

set @sql = '

SELECT ID,Type,Value, GETDATE() FROm info.dbo.temp'

set @command = 'bcp "'+@sql + '" queryout \\servername\drive:\info_temp.data -T -c -b10000'

print @command

--exec...

Not that I'm aware of, however, you could add a trigger that would stop them from doing the insert or whatever (INSTEAD OF trigger) and instead of doing the work,...

Maybe that job title/experience is too narrow and not needed at most companies. One issue I've heard as a problem...