Hi Please find the expected output here:

Its little urgent please help.

Thanks

Bhanu

Thx a lot.

Great Thanks frederico_fonseca.

Just curious to ask how to add  decimal(19, 6) to each column ?

is it manually or any technic.

Share your answer will be appricated.

May I know the reason for this issue?

Why i am not able to create this table?

max column limit is 1024 right?

can you please clarify?

no not possible on productid

Hi Jonathan AC Roberts and Phil Parkin,

Thanks for your reply but if i create 2 temp tables how to join in query as there is no column mapping columns right?

CREATE TABLE [dbo].[aaa_tempSalesData1](
[CustomerID] [int] NULL,
[ProductID] [int] NULL,
[RepID] [int] NULL,
[Amount] [decimal](18, 6) NULL,
[InstallmentDate] [date] NULL,
[Customer] [varchar](200) NULL,
[Rep Name] [varchar](200) NULL,
[Product] [varchar](100) NULL,
[IssueID] [int] NULL,
[IssueDate] [date] NULL,
[IssueName] [varchar](110) NULL,
[StartDate]...

Hi Ratbak,

Thanks for your reply but order is the only my main problem.

--Expected o/p : Previours years following by current year data

--Jan-2022,January-2022,Jan-2023,01-01-2023,Jan-2023,Jan-2023

Thanks

Bhanu

thank you

Great Thanks.

No luck sir still i am getting the same result.

declare @id numeric(19,6) = '123.456'

select @id, ROUND(@id,2)

(No column name) (No column name)

123.456000 123.460000

please provide any other alternative way.

thanks for your respone.

my requuirement is

"there should only be a return

if a given AlertID only has AlertTypeID's of both 4 and 6" nothing else.

thanks

bhanu

sorry updated the data.

create table #comapny

(

companyid int,

childname varchar(100),

activeid int)

insert into #comapny

select 1,'aaa',0

union ALL

select 1,'bbb',0

union ALL

select 1,'ccc',1

UNion ALL

select 2,'ddd',0

union ALL

select 2,'eee',0

union ALL

select 2,'fff',0

select *from #comapny

--Existing Data:

companyid childname activeid

1 aaa 0

1 bbb...

thank you.

Thanks you so much.