What special functionality does this assembly give you? Perhaps there's been a change in assembly name.

First things first: protect the data. Get him to get backups and to restore them on another server to verify them.

Then ensure that regular backups are in place.

Then think about...

Is there a file called Detail.txt in the SQL Server setup log folder? If so, please post its contents.

You mean this[/url]?

ganapathy.arvindan (4/29/2016)

---

Consider my count is 30

using while loop i am decrement it..till it reaches zero

count =30

then output should be

Empid empname...

Brandie Tarvin (4/29/2016)

---

I hope someone can assist me. I'd like to know where I can find the code behind the SQL engine's "Script AS" choice in the right-click GUI menu....

Most SSIS packages will not run on SQL Express. You'll need a higher version.

Please explain why you are doing this.

Also, you first talk about inserts, then later updates as though they are the same thing. They are not.

I had a similar experience to you with table variables & replacing these with temp tables solved...

Does anyone have The Ball today?

mbraman (4/28/2016)

---

The data I presented is pretty much it.

I want to be able to query for a total for the year 2016 without it adding up all 4 rows. ...

mbraman (4/28/2016)

---

I will first of all draw out my issue:

EmpID Date FieldName FieldValue Total

1234 ...

At least you didn't get this.

Sounds like you've fallen foul of the new Cardinality Estimator.

Please have a read here [/url]& you'll get a better understanding of what it is and how to handle it.

RickNPHX (4/27/2016)

---

Hi,

I saw the following statements in a SQL DBA 2008 R2 and 2012 class text, and wondered why you cannot install all components in more that one instance? Does...