Strange SQL Problem

I have a Select Statement that returns 4 rows.  When used in a stored procedure as input to an Insert Into, though, it was returning five rows.   I commented out SET NOCOUNT ON; which is added by the SQL 2014 template.  It then returned 4 rows.  To test that was what was really going on, I uncommented out SET NOCOUNT ON; and it is now returning 4 rows properly.

I made no other changes.

Anybody else ever run into anything like this??

Comments

Post a Comment

Popular posts from this blog

Proposed Amendment 28

Section 1. That the following language be stricken as unworkable from the US Constitution, Article I, Section 10: "No State shall enter into any Treaty, Alliance, or Confederation; grant Letters of Marque and Reprisal; coin Money; emit Bills of Credit; make any Thing but gold and silver Coin a Tender in Payment of Debts; pass any Bill of Attainder, ex post facto Law, or Law impairing the Obligation of Contracts, or grant any Title of Nobility. No State shall, without the Consent of the Congress, lay any Imposts or Duties on Imports or Exports, except what may be absolutely necessary for executing it's inspection Laws: and the net Produce of all Duties and Imposts, laid by any State on Imports or Exports, shall be for the Use of the Treasury of the United States; and all such Laws shall be subject to the Revision and Controul of the Congress." Section 2. And be replaced with "All States, for the protection of their citizens, may reject any Treaty, Alliance, or Confe...
Read more

Father claims 15 year old girl is capable of consent in Lesbian Rape Case

Father claims 15 year old girl from another family is capable of consent : I'm beginning to really like the change in Florida's government.  First they stop handing out welfare checks to junkies.  Now they are treating Lesbians under the same rules as Heterosexuals, gasp, what a concept!  Don't sign this petition unless you are FOR statutory rape of younger girls by predatory lesbians. How many 18 year old boys have been prosecuted for having sex with 16 year old women under "minors can't give consent"?    Special treatment for lesbians?  Please, no.
Read more

Call them what you like, Broken Families are still a TRAGEDY!

Yes, liberals value family , but not enough to recognize that a broken family is a tragedy. Divorce is actually worse than death as far as the grieving process goes- especially when there are children, custody battles, parental support, and alimony involved. And homosexuals raising children? That is tragic, not something to be celebrated. Maybe if we'd *recognize* that a broken family is a tragedy we would be more willing to say, pay taxes for WIC so that the single mother working a minimum wage job actually has the ability to choose life. Maybe we'd have more men willing to stick around and help raise the children they cause because the condom broke while they were stupidly using sex only for recreation. Maybe, just maybe, we'd be raising men instead of a generation of cowardly wimps who choose homosexuality and suicide over real life. Suffering and tragedy is valuable- but only if we recognize that it exists.
Read more