ChrisM@home (6/3/2015)

---

The OP is confused by the location of the ON clauses. Since there are only INNER joins, I don't think...

You should step thru the script and see what the value of filename when you try to assign it to the SSIS variable. Look like the error message it's...

Can you connect to other instances? If so, it's not likely to be a SSMS issue.

Lowell (6/3/2015)

---

same thing then, right?

if he is a local admin on the PC in question, he can run the script and take over the SQL instance(s).

if he had 3...

Can't you use a WHERE clause for the UPDATE to only update the rows that need updating, without going the EXCEPT route?

If I remember expressions correctly, try using IIF to check if the denominator is zero. If it is, return NA, else return the division.

Lowell (6/3/2015)

---

if you can rdp or login directly to the server, then you could stop and start the service in sinlge user mode, regardless of whether you are a sysadmin...

jshahan (6/3/2015)

---

If someone suggested this previously, I missed it. But go ahead and spring for the Developer's Edition of SQL Server which has all the functionality of the Enterprise...

Eirikur Eiriksson (6/3/2015)

---

Luis Cazares (6/3/2015)

---

Eirikur Eiriksson (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Ed Wagner (6/3/2015)

---

SQLRNNR (6/3/2015)

---

Actually,...

yusufm 48726 (6/3/2015)

---

Hi,

I have compiled a report where in SQL query I have used Order By DateEntered, Value DESC but somehow when I check all the lines it does not...

Something much stronger is needed here.

GilaMonster (6/3/2015)

---

Alvin Ramard (6/3/2015)

---

I think I'm ready for a new thread. I'm seeing way too many responses to questions that not really related to the question asked. ...

oops

patelxx (6/3/2015)

---

declare @StartTime nvarchar(10)= '12:00'

declare @EndTime nvarchar(10)= '12:45'

declare @Diff time(1) = cast(@EndTime as datetime) - cast(@StartTime as datetime)

How to I use Column names instead of Hard coding variables - e.g....

Sorry, in a dream world I was. :hehe: