Viewing 15 posts - 676 through 690 (of 747 total)
Such as they are not really unique: https://www.nbcnews.com/technolog/odds-someone-else-has-your-ssn-one-7-6C10406347
February 12, 2021 at 8:00 pm
Page footer and/or Bottom margin. Assuming you don't have too much content to fit the page. If so, you might nee/want to reduce top margin or font sizes.
February 11, 2021 at 7:06 pm
No. Unless you use dynamic SQL, you will need to insert into a temp table or table variable -- e.g., via STRING_SPLIT() function -- and join to that table.
With STRING_SPLIT,...
February 9, 2021 at 7:52 pm
I fully expected this to fail with the trailing comma (after the "Kolicina" column).
Apparently it's a minor bug embraced as a feature: https://github.com/MicrosoftDocs/sql-docs/issues/4807
February 9, 2021 at 7:42 pm
The comparison to a constant acts like a where clause -- since they are inner joins, only rows where that condition is true will be included.
February 4, 2021 at 2:48 pm
So you are saying that SQL Saturday is only about live databases, not those used for reporting?
Not at all. Many of us do reporting using TSQL. MDX isn't the only...
February 3, 2021 at 5:20 pm
Note: Your example shows double quotes, not parentheses.
FIELDTERMINATOR=‘","’,
January 28, 2021 at 2:43 pm
If you're talking about passing a URL as a parameter, and then parsing a substring from that URL to use as the stored procedure parameter, then you would need...
January 27, 2021 at 9:38 pm
Are you saying you want to navigate to the parameterized report URL so the report calls the proc w/ the parameter(s) already defined rather than opening report & setting parameters...
January 26, 2021 at 7:33 pm
To handle one pair of consecutive CRLF, you'd use one replace. For additional consecutive CRLF, you nest additional replace statements.
DECLARE @crlf char(2) = CHAR(13) + CHAR(10)
DECLARE @doubleCRLF...
January 26, 2021 at 5:07 pm
I assume SSRS is running on the client in question, since a remote server can't read client's Windows registry (clients don't even have to be Windows).
If so, one could use...
January 24, 2021 at 9:07 pm
What version of SQL Server (@@VERSION)?
Using SSMS? Or another client?
Does it work using #test rather than test?
Are you in master or another database? Do other queries to same database work?
It...
January 21, 2021 at 11:35 pm
The error is telling you that value already exists at the time of execution. You can confirm by executing
SELECT * FROM DR_Player_Upgrade WHERE PlayerID = 2930848 AND...
January 21, 2021 at 2:01 pm
"after something like 500 messages have been displayed... yeah... I know... don't ask..."
Ouch. I'd like to see that. Not on my servers, mind you, but it would be interesting to...
January 20, 2021 at 5:51 pm
Order is important. To be used, the first column(s) should match the columns in the predicate(s) of the query.
Analogy: A phonebook is fairly useless for finding a person if you...
January 20, 2021 at 5:49 pm
Viewing 15 posts - 676 through 690 (of 747 total)