But my scenario does not have a seggregation or datefields in it.

Thank you for providing me the reply and it works perfect when I am passing the single company. Will it be possible to perform the same for the All the...

Sorry Lynn,

I replaced the # while formatting the text to update in the Site, I am using #temp tables in the query.

Sorry the Variable @SQLCmd and not @STR

Thanks Lynn for the code. It works as expected however the length of the @STR Nvarchar(Max) variable is not enough to generate the complete select statement for all...

Thanks all you for your responses, however When I print or Exec the result is Command Completed Successfully.

My request is

I have a company table with the Name Column having...

Hi James

I am not getting any result or any error when I execute the second query

Hi ,

Could you please let me know the adjustment in the query to get my desired results, I will give a try.

Thanks

SR

Sorry there is a typo in the Insert statement

the Tpkt_type for GA is 12 and not 4,18 or 2

I thank all of you for providing me solutions for different versions, however I thought of playing with the data once it is filtered with the earlier logic. However I...

A BIG Thank you for the Help.Its Perfect solution for my requirement.

Appreciate your reply which is perfectly matching with what I send earlier however Sorry as initially I thought I can manage if the I get the results which I mentioned...

The Data I have in my Category code column in my source table is as below, as an example I just posted it as A B C D.

My data...

Adding the Table create and insert script

use tempdb

go

Create table #Test1

(ID Int,

Name Varchar (50))

Insert into #Test1 Values (1,'A')

Insert into #Test1 Values (2,'B')

Insert into #Test1 Values (3,'C')

Insert into #Test1 Values...

Thank You for the Quick Responses

It Works for my requirement:-)