Viewing 15 posts - 91 through 105 (of 1,199 total)
Because Brian is smarter than me! 🙂
Seriously, we don't see your actual table, nor do we know your indexes, so it is difficult to answer. However, keep in mind that...
September 18, 2020 at 7:08 am
Your problem is a little complicated since your text columns lists on two levels. Since this is more of a presentation issue, maybe it should be done in the presentation...
September 17, 2020 at 8:23 pm
I guess then that Service Broker is actually used in production. And the message comes from the production environment, but cannot be processed because of this error.
Did you change the...
September 12, 2020 at 8:43 am
Thanks, Erland... I missed it. I'll be back. I'm starting to think you might have been right, though. I showed the Op the "easy way for understanding" with the...
September 9, 2020 at 5:37 pm
Yeah, all I get for tsql_text is "Unable to retrieve SQL text".
Extended Events in SQL 2008 was a little half-baked, and things like capturing what is executed definitely works better...
September 9, 2020 at 4:09 pm
Profiler is of course a really bad idea, but why would a server side Trace be impossible?
September 8, 2020 at 7:03 pm
Jeff, he has already answered which version he has: SQL Express 2012 SP1. (So, Gaurav, you should apply the latest Service Pack for SQL 2012, which is SP4!)
September 2, 2020 at 6:48 pm
Edit: When you say, "SQL Server may still opt to only assign the variable once.", are you indicating that SQL Server may not only get the order wrong but...
September 2, 2020 at 6:17 pm
3. What would cause or allow SQL Server to ignore an explicit ORDER BY clause when a specific row goal has been established?
How would an ORDER BY or TOP...
September 2, 2020 at 4:34 pm
But here I still have a thing that is missing.
The list of all location is coming that's fine, but also I need the full list of Assets also (I marked...
September 2, 2020 at 4:29 pm
Erland - As written, you are absolutely correct. That said, it is, however, easily corrected by by simply adding TOP(N) and ORDER BY clauses. See test below...
No, I maintain...
September 2, 2020 at 12:37 pm
No, quantity belongs to tblLocationAssets
Well, then you know what to fix in the query.
September 2, 2020 at 11:41 am
You have ast.quantity all over the query. Is there a quantity column in the table tblAssets? In such case, why is the CTE taking quantity from a different table?
As I...
September 2, 2020 at 11:25 am
Jeff, if you are going to suggest people to use dynamic SQL, at least show them code that is safe and robust. The construct
SELECT @sql = @sql + col FROM...
September 2, 2020 at 8:16 am
I generally agree with Erland on this subject and pietLinden is probably correct about SSRS BUT... this is actually fairly simple to pull off in T-SQL.
Yes, for you and...
September 2, 2020 at 6:47 am
Viewing 15 posts - 91 through 105 (of 1,199 total)