You're missing the begin and a different set of begin...end. You're also missing the commit transaction. You're also using the slow option.

BEGIN TRANSACTION;

IF EXISTS(SELECT * FROM db1.dbo.Jobs where status in...

There are 2 other ways that might possibly help you.

One is to use the window functions capabilities introduced in SQL Server 2012: http://sqlmag.com/sql-server-2012/how-use-microsoft-sql-server-2012s-window-functions-part-1

The second one is to use the Quirky...

Anandkumar-SQL_Developer (7/25/2016)

---

--input code :

CREATE TABLE SumPositiveNegative

(

ID INT

)

GO

INSERT INTO SumPositiveNegative VALUES

(1),

(-1),

(2),

(-1),

(3),

(-3)

GO

select * from SumPositiveNegative

-- Expected_output :

SumIgnoring-ve_symbolsTotalSum+VeSum-VeSum

11 ...

Yes, that's why we have column alias. Remove the star(*) and explicitly list the columns and add alias as needed.

It seems that you're not managing the log adequately, as previously stated. You can either change the recovery mode to simple and lose the benefits of minimal data-loss or you...

Anandkumar-SQL_Developer (7/25/2016)

---

Hi this code also work :

SELECT Value

FROM

#first_nonzero

WHERE %%PhysLoc%% >=

...

+1

Brandie Tarvin (7/22/2016)

---

jasona.work (7/22/2016)

---

So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...

Crafting up some easy-to-use backup reports that the...

Ahem...

leprechaun

Blue

ben.brugman (7/22/2016)

---

This is a bit 'short' I would guess:

SELECT DATEADD(month,12*(YEAR('20160401')-1902)+3,0) -- Result 2014-04-01 00:00:00.000

SELECT DATEADD(month,12*(YEAR('20160331')-1902)+3,0) --...

Have you tried printing the statements before executing them? Maybe a null is giving you problems.

I would suggest that you follow twin devil's recommendations. I disagree on the reason for...

Just add the column to your first query. Here's a shorter version.

SELECT h.server

, j.name

, h.run_date

,...

CELKO (7/21/2016)

---

SQL is what I would call a "predicate language"; instead of looking for assembly language style flags in the data like we did in the 1960's, we use predicates...