2K doesn't like the db_id...

Few things to improve, firstly you must cast the @IdEmployee to a varchar

cast(@IdEmployee as varchar(12))

Next is the @Name, has to enclosed with apostrophe/single quote

char(39) + char(39) + @Name + char(39)...

This is most likely because the compatibility level for the database is less than 2005(90), nothing wrong with this code.

😎

No need to complicate things, the only thing needed here is correct window specification for the row_number function.

😎

;WITH HISTORY_BASE AS

(

SELECT

...

The Dixie Flatline (7/8/2014)

---

Wolfkill needs to know if there are tanks in EVE Online, as well as bombers.

Tanks are very important. ...

Simple things like snapshot isolation could do wonders in this kind of situation:-D

😎

Francis S. Mazeika (7/8/2014)

---

I ran the query, the attachement data is truncated at 65k, no attachement size is larger than that.

I run the same query\jobs using sp_send_dbmail in 2008 and...

jarid.lawson (7/8/2014)

---

I should have already posted my "solution". The issue was another job was running that used many of the same packages stored in the SSIS Catalog. They hit the...

sgmunson (7/8/2014)

---

Some of the runtime symptoms of the below suggested causes could be: 1.) sudden CPU usage spikes for however long this runs before it fails, or even 2.) a...

Grant Fritchey (7/8/2014)

---

So you're going to an underpowered machine (8gb is half the memory my laptop has) and you're running a very large aggregation query and returning 1.7 million rows....

GilaMonster (7/7/2014)

---

For anyone that gets frustrated with our posters here, here's a quote from a poster over on a gaming forum...

I was thinking about reactivating my bomber but it occurred...

You can use SQL*Net Easy Configurator:w00t:

ouch

😎

Luis Cazares (7/7/2014)

---

I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the knowledge can be transferred easily between tools, but I'm just...

asiaindian (7/7/2014)

---

Thank you for the response. I am sorry for not giving out the SQL box specifications. It has 256 GB RAM, of which 200 GB is dedicated to SQL...

asiaindian (7/7/2014)

---

Hello,

Environment:

I have a remote server with SQL server 2014 instance on it. There is nothing else running on the SQL Server box(dedicated SQL box). There is only one instance...