tag:blogger.com,1999:blog-8278327115958281522.post3756925191600219570..comments2022-04-05T17:11:34.925-07:00Comments on sql server erromessges: Msg 141 - A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.,sqlUnknownnoreply@blogger.comBlogger10125tag:blogger.com,1999:blog-8278327115958281522.post-48948827468817084982014-07-20T22:23:54.955-07:002014-07-20T22:23:54.955-07:00weak sauceweak sauceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-71325705982997292612013-03-01T04:29:50.634-08:002013-03-01T04:29:50.634-08:00this blog is created just for revenue on ads.. eve...this blog is created just for revenue on ads.. even the title is spelled wrong.. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-41787145581631375542012-04-04T06:38:49.422-07:002012-04-04T06:38:49.422-07:00Come on, you just steal articles from others witho...Come on, you just steal articles from others without giving them credit? <br />http://www.sql-server-helper.com/error-messages/msg-141.aspxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-79350962232264325292012-02-09T14:21:57.229-08:002012-02-09T14:21:57.229-08:00You're right. I'm still looking for a work...You're right. I'm still looking for a working solution to this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-51865859026819231722011-02-17T05:27:51.784-08:002011-02-17T05:27:51.784-08:00Isn't the SELECT query in your last section th...Isn't the SELECT query in your last section the exact same query as the one they said you should NOT use?:<br /><br />SELECT @CompanyName = [CompanyName],<br />@ContactName = [ContactName],<br />[ContactTitle]<br />FROM [dbo].[Customers]<br />WHERE [CustomerID] = 'ALFKI'<br /><br />In other words, you are still using the "[ContactTitle]" in the SELECT list without a variable being assigned to it. So, it still looks like it will not work. <br /><br />This is the same article as found at: http://www.sql-server-helper.com/error-messages/msg-141.aspxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-87141753555168929012010-11-18T10:43:32.313-08:002010-11-18T10:43:32.313-08:00thanks~usefulthanks~usefulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-68078040946631823162010-05-24T00:01:17.718-07:002010-05-24T00:01:17.718-07:00Thanks for the "dummies" explanation, it...Thanks for the "dummies" explanation, it saved me some banging-the-head-into-the-brick-time. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-74326855559802568952010-04-07T17:49:53.193-07:002010-04-07T17:49:53.193-07:00Thanks, this explanation saved me.Thanks, this explanation saved me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-16319613705480805632010-02-15T14:17:32.617-08:002010-02-15T14:17:32.617-08:00Very Very usefulVery Very usefulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8278327115958281522.post-16746365198366225862009-11-25T06:48:52.616-08:002009-11-25T06:48:52.616-08:00simple but very usefull.simple but very usefull.Anonymousnoreply@blogger.com