Bulelani M (6/11/2012)

---

This script is on a batch file that is scheduled to run early in the morning before business hours start. It is used to aggregate certain tables for...

Bulelani M (6/11/2012)

---

Hey Jared

I'm using ssms

It worked this time around and still don't know why it didn't work.

I kind of said to myself, its one of those things...

Formatted:

PRINT 'Starting Student Master Table Re-creation'

PRINT 'Dropping temporary tables...'

DROP TABLE #enr_detail

DROP TABLE #demo

DROP TABLE #addr_split

DROP TABLE #reg_detail

DROP TABLE #subj_detail

DROP TABLE #assg_detail

DROP TABLE #assg_dispatch

DROP TABLE #assg_passed

DROP TABLE #assg_submitted

DROP TABLE #Tot_assg_dispatch

DROP TABLE...

Ok, I simplified you original code and took out all of the commented stuff so we can see this a bit easier for testing. What I need is some sample...

Ok, well your SQL is fine. Add a " before the UPDATE.

If it is simply C#, then the problem is that the UPDATE does not have a double quote in front of it. Should be this:

"UPDATE P SET Stock =...

What happens when you run this:

SELECT *

FROM prices P

INNER JOIN #prices T

ON P.Avg = T.Avg

AND P.Colour = T.Colour;

Also, what's with all of your concatenation? Is that also in the...

What does that mean? Same error? Different error? Not expected output?

sqlstud (6/7/2012)

---

Great Jared and Thanks.

I have used the below query. Is it Correct?

YEAR = @MLR_YR

AND (@CODE IS NULL OR CODE='' OR CODE=@CODE)

AND (@BATCH IS NULL OR @BATCH ='' OR BATCH=...

You will have to adjust your SP to accept an empty string ('') for those parameters and handle that. See Gail's blog post here to get the main idea....

sqlfriends (6/6/2012)

---

see my job in the attachment, it is the same job as yours, it is all executed as the user- the domain user that for sql agent service login....

sqlfriends (6/6/2012)

---

I'm not sure that you completely understand yet. The jobs on a schedule will always run under the "service account" which is the NT SERVICE\SQLSERVERAGENT no matter which domain...

Jeff Moden (6/6/2012)

---

Ok... I've gotta go now because some idiots working for LinkedIn didn't know how to protect a couple of million passwords and I have to change mine because...

sqlfriends (6/6/2012)

---

We do use default installation.

also:

You cannot log into the server with the service account and get access to SQL Server, nor can you impersonate the service account and gain...

sqlfriends (6/6/2012)

---

Thanks,

Sorry still confusing:

Quote from SQLKnowitall:

Quote from Jeff:

The service...