CREATE table #AllCountryStates

(

CountryName NVARCHAR(100),

Treeid int

)

insert INTO #AllCountryStates

select N'??',1

select * from #AllCountryStates

declare @Country NVARCHAR(1000)

SELECT @Country = STUFF(

(SELECT ',' + ''

+...

Existing Result:

"??"

Expected Result:

"??"

Thank you so much. It is working fine.

thank you it is working fine.

thank you so much.

Hi Team,

Support if i take only date in this table.
is it possible to get the expected output.
please help.

create table trend1
(
keyinstn INT,
ratingdate...

Thank you so much it is working fine.

Hi,

Looks like it will work but i am using SQL Server 2014.

we dont have this function "string_split"

can you please provide alternative to this.

Thank you so much.

please try this code it is working fine.

SELECT *

FROM (

SELECT

SOFTWAR_ID

...

Sorry still i am not clear on my question ?

My question is

1. When we will use SET XACT_ABORT ON in my procedures ?

a)if...

thanks for you reply but if possible can u please explain me with example.

thank you

need one more help.

table insert cost is 30%. how to reduce this cost.

Thank you very much.

it is working fine.