Viewing 15 posts - 1,006 through 1,020 (of 5,111 total)
You could create a custom Report within SSMS (Add a Custom Report to Management Studio), or if you're using Azure Data Studio add the query ad a Widjet to...
May 10, 2019 at 3:19 pm
Is this definitely SQL Server? There is no number datatype in SQL Server, and neither is there a varchar2. Yes, this can be achieved in SQL Server, but considering this...
May 10, 2019 at 11:46 am
Do you have a column you can order my in the data that will retain the order of the file? If not, then yes, using a Script Component instead would...
May 10, 2019 at 9:35 am
This appears to be what your after then. I perform the conditional aggregation inside a CTE, as then you don't need to repeat the CASE expressions for the total:
May 9, 2019 at 3:11 pm
Is this what you're after? If not, can you post your expected results please (don't forget to use the Insert/Edit Code sample button)
CREATE TABLE #temp ([Type] varchar(50),
...
May 9, 2019 at 2:33 pm
perhaps SQL synonyms could help, but i'm not sure and it needs testing
That would give you the error:
Synonyms are invalid in a schemabound object or a constraint expression.
Here's...
May 9, 2019 at 1:59 pm
I think the OP is saying that want to create an index on a view, but that the view will be returning data from other databases. Simply put, you can't....
May 9, 2019 at 1:24 pm
I'm hoping that's not actually a bad thing. 😉
Being able to turn the software off that's trying to keep your work device "safe" doesn't seem "safe". 😉 It's like...
May 9, 2019 at 10:15 am
May 8, 2019 at 8:58 pm
It's the Alt key that allows block selection.
No one saw my brain fart... No one... ... 🙂
May 8, 2019 at 11:17 am
Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query window...
May 8, 2019 at 10:24 am
It WAS working for me before on both places it is no longer working. I've not made any security level changes in FireFox or Chrome, either.
Maybe a DNS issue?...
May 8, 2019 at 8:23 am
You could by switching to a Stored Procedure. SSRS, when using syntax like WHERE [Column Name] IN (@Parameter) injects the values into the query instead, replacing the value of @Parameter...
May 7, 2019 at 5:49 pm
It worked fine on Windows 10 Edge and Firefox at work, and fine on Ubuntu Firefox at home. Sounds like the problem might be your end, Jeff. Considering that the...
May 7, 2019 at 5:15 pm
The multi-tabbed item is cool. I have that with ConEmu and use it all the time.
I've got in the habit of using CSSH at home lately, as I...
May 7, 2019 at 4:15 pm
Viewing 15 posts - 1,006 through 1,020 (of 5,111 total)