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...

As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message about NULL values being eliminated:

Select Sum(IsNull([Col],0))

No problem. Thanks for posting back.