Viewing 15 posts - 676 through 690 (of 5,109 total)
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 12, 2019 at 9:23 am
What is the SQL you're trying to run (use the Script button)?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 12, 2019 at 9:17 am
Viewing 15 posts - 676 through 690 (of 5,109 total)