Viewing 15 posts - 6,466 through 6,480 (of 59,070 total)
Thank you so much for your help.
Sir, now I have added " group by ast.asset_name" and " LEFT JOIN ctePreAgg " it works fine.
Thank you, thanks a lot 😀
Good. ...
September 2, 2020 at 6:44 pm
p.s. The good part about this is that you reminded me that I needed to update my old Dynamic Cross Tab article. I edited the first post in the discussion...
September 2, 2020 at 2:50 pm
PLEASE READ ME!
This article is an old one and I've been remiss in not updating it but you need to be aware of something... The creation of the dynamic...
September 2, 2020 at 2:28 pm
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...
September 2, 2020 at 2:10 pm
Damn... I forgot the GROUP BY. Serves me right for posting so late without any test data to check with. That's no good excuse but those are the reasons.
On the...
September 2, 2020 at 1:55 pm
Please suggest where I need to modify or where I have done wrong. Thank you
No, quantity belongs to tblLocationAssets
Hang on... I'm checking. Heh... this is what I get...
September 2, 2020 at 1:23 pm
Replace the code for @SQL2 and its related comment with this. You might also want to fix the location names in the future... a lot of them have trailing spaces.
September 2, 2020 at 8:04 am
So print out the dynamic SQL and post it. It's likely going to be in line 9 of the Dynamic SQL.
September 2, 2020 at 6:18 am
p.s. I don't know who left you a rating of "1" but it wasn't me. I generally don't rate articles and I certainly wouldn't rate one so low without an...
September 2, 2020 at 6:13 am
I'm not sure where the 70-30 recommendation actually came from but I have do disagree with it on large systems. I can't believe it's not a total waste to give...
September 2, 2020 at 6:06 am
At this point, it's almost a dead issue but I have to agree with Scott. If you want to say that using WITH (NOLOCK) or setting the transaction isolation level...
September 2, 2020 at 5:47 am
... we get companies that require NOLOCK in every query (and yeah, run across this one many times now).
Seriously? An official, company-wide mandate to DB coders to use this?...
September 2, 2020 at 5:41 am
Any reference link I can refer too and make my point?
Frederico provided one in his post... the very first post after your question.
September 2, 2020 at 5:34 am
Jeff Moden wrote:How many rows do you have in the tbl_Projects table?
Sir, there are 51 rows.
Ok... so we definitely need Dynamic SQL, at least to build the query if you...
September 2, 2020 at 5:19 am
I agree. Very nice article and I share Scott's joy in seeing someone make a Bridge/Intersection/Cross Reference/M2M/Cartesian/Relational Multiplication table (heh.. those are just some of the names I've heard for...
September 2, 2020 at 4:04 am
Viewing 15 posts - 6,466 through 6,480 (of 59,070 total)