Hi All,

I have updated the table create script and indexes on the table for reference.

• This reply was modified 1 year, 12 months ago by  arvind.patil 98284.

you can convert it money data type

SELECT CONVERT (money , '$15,000.50 ')

Hi ,

you can try using below query

Select Employee_Name,SSN,STRING_AGG(Emp_code,'_') within group (order by Emp_code) from #input

group by Employee_Name,SSN

Hi Experts ,

We have identified the process which has consumes the space in tempdb . The stored procedure uses a lot of temp tables in it . Does storing the...

Will it free the space temporary?

So in production its still happening and we needs a temporary solution for the time being. It will take us some time to fix the...

Hi Guys ,

I have a very basic question regarding comparing 2 execution plans .

While comparing the execution plan i usually see Estimated sub tree cost of the left most operator...

Thanks it was helpful

Hi Experts .

I have table Temp_decimal_mismatch which has duplicate data . The duplicate data is not straightforward to remove .

Here the row highlighted in yellow is a...

As i cannot post the actual data and table structure. .I have created that table , so that i can post it in sql center portal .

There is [TABLE_SCHEMA], [TABLE_NAME], [COLUMN_NAME], [datatype] is the pk

/*
CREATE TABLE SampleData(
Cust_Name varchar(100),
Prd_Name  varchar(100),
[1/1/2019]  decimal(10, 4),
[2/1/2019]  decimal(10, 4),
[3/1/2019] decimal(10, 4)
)
INSERT...

Hi,
Please find the attached UAT execution plan . I am not a dba can you please provide me a list of things that i should check.