Weegee2017

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 49 total)

RE: Dynamically outputting a set of columns based on another Tables records

Thats great. Thank you very much Thom

January 28, 2019 at 4:58 am

#2020258
RE: Dynamically outputting a set of columns based on another Tables records

Thom A - Monday, January 28, 2019 4:08 AM
If I'm understanding correctly, the first mistake you are making is actually pivoting your...

January 28, 2019 at 4:31 am

#2020256
RE: Dynamically outputting a set of columns based on another Tables records

Thom A - Friday, January 25, 2019 9:48 AM
I'm not sure I actually understand your goal here I'm afraid. What are you...

January 25, 2019 at 9:57 am

#2020140
RE: Importing 2 files using a dynamic configuration using SSIS and not SQL

Phil Parkin - Wednesday, January 23, 2019 11:00 AM
Weegee2017 - Wednesday, January 23, 2019 9:24 AM

January 24, 2019 at 2:21 am

#2019917
RE: Partioning a table of data for 2 distinct rows

Jonathan AC Roberts - Friday, December 14, 2018 5:26 AM
Weegee2017 - Friday, December 14, 2018 5:17 AM

December 14, 2018 at 7:52 am

#2016325
RE: Partioning a table of data for 2 distinct rows

Jonathan AC Roberts - Friday, December 14, 2018 5:06 AM
Weegee2017 - Friday, December 14, 2018 4:58 AM

December 14, 2018 at 5:17 am

#2016304
RE: Partioning a table of data for 2 distinct rows

Hi Jonathan
That wont retirieve the last 2 entries

December 14, 2018 at 4:58 am

#2016297
RE: Partioning a table of data for 2 distinct rows

Hi Jonathan
Thanks for posting that.... The only thing is that i want to retrieve the 2 last entries ie LogID = 11750 and Log ID = 11757 and i...

December 14, 2018 at 4:28 am

#2016295
RE: How to Use Values from Previous or Next Rows in a SQL Server Query to calculate status

Jonathan AC Roberts - Friday, October 19, 2018 6:55 AM
;WITH CTE AS
(
SELECT a.HoldingID,
a.IndicatorID,
a.[Status],
...

October 19, 2018 at 7:45 am

#2010430
RE: How to Use Values from Previous or Next Rows in a SQL Server Query to calculate status

Thom A - Friday, October 19, 2018 6:43 AM
Weegee2017 - Friday, October 19, 2018 6:36 AM

October 19, 2018 at 6:47 am

#2010409
RE: How to Use Values from Previous or Next Rows in a SQL Server Query to calculate status

Thom A - Friday, October 19, 2018 5:16 AM
Rather than using a JOIN with the clause InActive.RowNumber = Active.RowNumber -1...

October 19, 2018 at 6:36 am

#2010404
RE: Create a specific Pivot Table from a table output table

Joe Torre - Thursday, October 18, 2018 10:19 AM
SELECT
     Min(o.HistoryDateTime2) BegDt
   , Max(o.HistoryDateTime) EndDt
   , o.IndicatorID
   , o.HoldingID
FROM #OutputTable o
GROUP...

October 19, 2018 at 3:22 am

#2010372
RE: Create a specific Pivot Table from a table output table

Phil Parkin - Thursday, October 18, 2018 10:20 AM
Try this:
SELECT
ot.HoldingID
, ot.IndicatorID
, DateFrom = MIN(ot.HistoryDateTime2)
, DateTo = MAX(ot.HistoryDateTime2)
FROM #OutputTable ot
GROUP...

October 19, 2018 at 3:22 am

#2010371
RE: Using a look up table to remove values in another using pattern matching

SGT_squeequal - Friday, July 6, 2018 8:26 AM
depending on how the data looks, if its guaranteed to the exclusion is guaranteed to...

July 6, 2018 at 8:36 am

#1996553
RE: Using a look up table to remove values in another using pattern matching

John Mitchell-245523 - Friday, July 6, 2018 8:17 AM
Yes, you can do that, but you have to use "LIKE" instead of "=". ...

July 6, 2018 at 8:23 am

#1996550

Viewing 15 posts - 31 through 45 (of 49 total)