Viewing 15 posts - 841 through 855 (of 5,111 total)
Without some sample data, and a way to replicate this, this is really difficult to answer. If you can provide some DDL and DML that we can use and let...
July 10, 2019 at 3:43 pm
From what little I am able to see it seems like there are a LOT of companies still running SQL 2008R2.
There definitely are. You still see questions about SQL...
July 10, 2019 at 3:13 pm
Yes, the common way is using a CTE and ROW_NUMBER or using ROW_NUMBER in the ORDER BY and TOP 1 WITH TIES. There's plenty of examples on the internet on...
July 10, 2019 at 10:21 am
If there's a question here, I can't see it.
The data isn't even well formed either. If we assume that the | not contained in a " is a delimiter,...
July 10, 2019 at 7:55 am
That's not good enough for most CPAs, my Mom, and lots of other business users. The online version seems to be a last resort for most people.
I don't...
July 9, 2019 at 3:37 pm
I think that the authentication on Linux is still a hassle. I know some people have it working, but it certainly isn't easy right now. That will get lots...
July 9, 2019 at 3:16 pm
I was able to resolve this by making the open query select list a CTE and selecting from the CTE.
also, procedure sp_describe_first_result_set can be useful in...
July 9, 2019 at 2:19 pm
For the above data sources which access level can i give to the SSIS packages? Is it only read and write or are there other options?
What permission you need...
July 9, 2019 at 1:09 pm
I'm actually a little bit confused as to what you're trying to achieve here. Are you trying to delete rows from the table MA_HST_PW_EM on the linked server, where the...
July 9, 2019 at 11:27 am
I actually do use Linux as a Desktop PC at home. This is more of a hangover from when I was living at my parents for an interim period and...
July 9, 2019 at 11:02 am
Seems like it would be easier to have the user update a table to update a status to say that the file is available, and your SQL job pools the...
July 9, 2019 at 8:48 am
This sounds like an "XY problem". I assume you want the user to be able to start a SQL Agent job? Is it a specific job you want them to...
July 9, 2019 at 8:14 am
Hello, I need help to write a query with CTE. I wanna write a query for TotalPrice of Last Sunday of each month between some years.
Why do you need...
July 7, 2019 at 9:30 am
So to connect between SSIS package and a separate linked server I would create an OLEDB connection using the connection managers.
You just need to create an OLEDB connection for...
July 4, 2019 at 8:46 am
You don't have linked servers in SSIS; Linked Servers is a Data Engine "thing". You can have multiple OLEDB Connections in a package, and those can reference different Servers/Instances in...
July 4, 2019 at 7:37 am
Viewing 15 posts - 841 through 855 (of 5,111 total)