Forum Replies Created
Viewing 15 posts - 1,561 through 1,575 (of 13,855 total)
-
Reply To: Merging sql and excel
SSIS can do it.
Create a dataflow with
Source 1: SQL Server
Source 2: Excel
Destination: Excel
Inside your (source --> destination) dataflow, perform the merge, probably using a MERGE JOIN component.
-
Reply To: OAuth in SSIS
Rachel Gomez wrote:Oauth is an authentication protocol and is not relevant for having SSIS talk to SharePoint (SP).
--
Greeting,
Rachel Gomez
SharePoint is not mentioned anywhere else in this thread, so why mention it...
-
Reply To: LAST MAX 2 DATES
Shree23 wrote:when i have added 2 rows and max 2 rows is giving '2021-02-19' only one record
('577', '-1', '0', '2021-02-19');
('577', '-1', '1', '2021-02-20');
For me it gives 2 rows.
As you have...
-
Reply To: SQL Logic for time dependent role mapping
Based on your sample data, this works, I think. I suspect that more refinement will be required to make it work with actual data. Please post sample data in consumable...
-
Reply To: Summary Report
Which reporting tool are you using?
If you want a code solution, please provide sample data and desired results in a consumable format.
-
Reply To: LAST MAX 2 DATES
Shree23 wrote:Here is required output
('577', '-1','1','2021-02-14');
('563', '-1','1','2021-02-13')
DROP TABLE IF EXISTS #Table_1;
CREATE TABLE #Table_1
(
div_id NCHAR(10) NULL
,customerid NCHAR(10) NULL
,div_status... -
Reply To: LAST MAX 2 DATES
I don't need to see your query. What we need to see are your desired results, based on the sample data provided. You seem unwilling to do this.
-
Reply To: LAST MAX 2 DATES
Shree23 wrote:can not select top2 logdate along with other columns when really not required
That is confusing.
Based on your sample data, please provide a screenshot of the results you would like...
-
Reply To: LAST MAX 2 DATES
Shree23 wrote:Please do not use top(2) . i can not use in my existing query ..help me with alternatives
Please explain why TOP (2) is not to be used.
-
Reply To: Match and No Match(Gives same output)
Can you show us a screenshot of the Lookup configuration?
-
Reply To: Match and No Match(Gives same output)
yrstruly wrote:My data source is an excel file which i imported to sql server.
So what? The advice provided by Ed B is sound. Perhaps...
-
Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY
Well, there is something that you can do. Whether it helps you at all is a different matter, but I'll mention it just in case.
If you do the following, your...
-
Reply To: show percentage between 2 fileds
I ended up with something like this. Do you see any issues I would run into?
As I have completely failed to grasp what it is you are going to be...
-
Reply To: SSDT creates a clustered index b4 clustered columnstore index, then drops - WHY
I believe that most people structure their table definitions with key columns first, which may explain why I have never seen this behaviour before.
-
Reply To: Parse data from notes field
That means you have some data which does not follow the convention. You can avoid the error by filtering out the rows which do not match, like this:
February 21, 2022 at 2:06 pm
Viewing 15 posts - 1,561 through 1,575 (of 13,855 total)