Viewing 15 posts - 676 through 690 (of 5,111 total)
declare @num decimal
decimal what? Where's your scale and precision?
November 18, 2019 at 2:14 pm
can we use procedure in our query to retrieve data ?
Yes. Contrary to popular belief, you CAN call a stored procedure in a SELECT query using things...
November 18, 2019 at 2:12 pm
This was going to go into a LOAD statement using QlikView (which uses SQL syntax)
But it doesn't use T-SQL. You've asked on a SQL Server community here, and the...
November 18, 2019 at 11:06 am
For something like this, I'd be more likely to use the -Q switch; which automatically exits after the query is run.
November 18, 2019 at 11:02 am
can we use procedure in our query to retrieve data ?
You can use an SP to return data, yes, but not inside a (SELECT?) query. Executing an SP would be...
November 18, 2019 at 10:13 am
Amazed at the simplicity of upgrading SQL Server (2017) on Linux to 2019. It was literally remove the 2017 repository, add the 2019 repository, then run a dist-upgrade. I had...
November 14, 2019 at 11:46 am
Forums can be for sharing, yes, but you're asking for support here, and Jeff and I are trying to help you (using our free time). You've just dumped 20,144 lines...
November 13, 2019 at 11:05 am
Just dumping stuff in the topic, without formatting or context, isn't going to easily help us help you here. I haven't read any of the above, I'm afraid. You would...
November 13, 2019 at 8:54 am
Not sure what the purpose of your topic is here? Could you explain? Are you simply sharing us your data and your final result and want to share how you...
November 12, 2019 at 4:11 pm
That code is wide open to injection. You really need to fix it before you do anything else. And I do literally mean anything. SQL injection is something your...
November 12, 2019 at 2:52 pm
Just break up the statement so you are adding to @SQLSTRING several times.
But why use a dynamic statement at all for a statement that isn't dynamic? The problem...
November 12, 2019 at 2:30 pm
SSRS doesn't use ? for parameters, it's uses the parameters name. Something like SELECT * FROM MyTable WHERE ID = ?; isn't correct, it would be ID = @ID.
When using...
November 12, 2019 at 12:34 pm
Why are you injecting the value of your parameters here as well? You should be parametrising them. I also suggest retaining linebreaks in your dynamic Statement as well; as it...
November 12, 2019 at 11:54 am
That's fine, but I (and other users) will really want to see the SQL Statement you're running. Like i said, use the Script button to get that.
I assume, as well,...
November 12, 2019 at 9:48 am
Not a command, Tasks > Back Up
Does Not Replace
That doesn't make sense. Does not replace what'; that sentence is incomplete? What is the SQL being run? An image of...
November 12, 2019 at 9:23 am
Viewing 15 posts - 676 through 690 (of 5,111 total)