Hi,

Thanks for getting back. There is no connection between [Owner],[PersonAttending],[Type] columns.

1. While Owner column can be blank and [PersonAttending],[Type] still have values.
2. Owner (different people than [PersonAttending]) <> [PersonAttending] and...

For ID 711 the output is not correct. Atta

CREATE TABLE #SplitColumnsToRows
(
ID INT,
Title nvarchar(1000),
[Owner] nvarchar(1000),
[PersonAttending] nvarchar(1000),
[Type] nvarchar(500)

)


Insert INTO #SplitColumnsToRows ( ID,Title,[Owner],[PersonAttending],[Type])

SELECT 711,'Training requirements','','Weiying Song;Muhammad Ismail Aftab;Saravana Kumar Rao;Rasha...

Thanks a lot. Works perfectly  🙂

Works like a charm.

Is there a way to sort the GM Scope and BL Scope columns in alphabetical order ?

-- Desired results

SELECT 'Q4-20'AS [Quarters],'FIN' AS [Function],'AC' AS...

• This reply was modified 3 years, 9 months ago by  PSB.

Works . Thanks

Instead of two rows it creates 4 records for 'Dual Task' , Not sure how to accomplish this

Create TABLE #TableA

(
 TaskNameA nvarchar(100),
 GovernA bit,
 ToolTypeA nvarchar(10),
 ResourceNameA...

Works like a charm. Thank you!

Yes, that's correct . Thanks.

Yes, requirement has changed . There will be no more hyphen after [] .

Here is the code snippet

CREATE TABLE #RemoveText ( ID INT,TextName NVARCHAR(100))
INSERT INTO  #RemoveText (ID,TextName)
SELECT '1','[Accounts Name] Transactional Process sessions' UNION 
     ...

Thanks for the solution. It works. How do I change this code for the hyphen part ?

The square bracket will not be followed by hyphen . It could have a...

Thanks. Works as expected.

Hi,

Thanks for the solution. It works as expected. Just noticed the main table has an extra space at the beginning of each 1st value. How do I change the query...

Here are some snippets from the log file :

extensionfactory!ReportServer_0-3!204!08/19/2020-09:58:48:: e ERROR: Exception caught instantiating ORACLE report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->...

I have Enterprise Edition . My question is how to set the Delivery Option Email and Report parameter value .