Good explanation Eric 🙂

Hi,

Why are you doing deleting and insertion on the same id value?

what you want to accomplish from that.

Hi,

First you can insert the data of excel file in a SQL table using import task/Bulk Insert/SSIS whatever you like.

Once you inserted the data into the table you can use...

Hey folks I found the solutions for this -

For version SQL Server 2016 CTP 3 we do not need to run DBCC TRACEON (209,219,-1) else it will show the...

You are creating the #temp_2 table in the same script without dropping..

Uncomment the code of DROP TABLE #temp_2 and run the query.It will work buddy 🙂

Hi,

Try this.. Hope it will work for you:

WITH CTE(col) AS

(

SELECT

'ServerCentral|||||forum|||||||||||||||is||||||the||best'

UNION ALL

SELECT 'so||||||be|||||on||||||||||||||||||||||||||||||||||||||||||||it'

)

SELECT

REPLACE (

REPLACE (

REPLACE(

REPLACE(col,'||','|' + '=')

,'=' +'|','')

,'=','')

,'|','=')

FROM CTE

Eirikur Eiriksson (7/19/2015)

---

kapil_kk (7/18/2015)

---

HI friends,

I was trying to create temporal table feature which gets introduced in SQL Server 2016 but I am getting this error while trying to create it;

Cannot...

using SSMS version 13.0

Already tried but nothing happened...

Using SQL version SQL Server 2016 CTP2...

After running that query its returning me value 1 for database on which I enabled Query store ON.

name ...

you can try below this query :

SELECT OrderId, TaskID, MAX(SerialNo)SerialNo

FROM table_name

GROUP BY OrderId, TaskId

Modified the query using Alias:

UPDATE table1 t1

SET t1.col1 = 'aa'

WHERE t1.col1 < (SELECT MAX(t2.col2) FROM tabl2 t2 WHERE t2.col3 = t1.col4)

OR t1.col1 < (SELECT MAX(t3.col1) FROM t3.tabl3 WHERE t3.col3 =...

Hi,

Welcome to SSC!!

I think the table structure that you have provided and output you desired is lacking somewhere due to missing information..

As in table structure there is only one date...

Hi,

Can you please provide some more details?

what exactly you required in output with some sample data

You can try this:

;WITH CTE (sig)AS

(

SELECT'5.625X11.25-2.875x8.5' UNION ALL

SELECT'5.625X35.25-2.875x32.5' UNION ALL

SELECT'22.5X9.75-9.5x19'UNION ALL

SELECT'28.5X9.75-9.5x25'UNION ALL

SELECT'40.125X9.75-9.5x36.625'UNION ALL

SELECT'22.5X11.25-11x19'UNION ALL

SELECT'22.5X11.25-11x19'UNION ALL

SELECT'34.125X11.25-11x30.625'UNION ALL

SELECT'22.5X12.75-12.5x19'UNION ALL

SELECT'34.125X12.75-12.5x30.625'UNION ALL

SELECT'24.375X8.8125-8.5625x20.375'UNION ALL

SELECT'18X12.25-12x14'UNION ALL

SELECT'5.625X8.25-2.875x5.5'UNION ALL

SELECT'5.625X12.75-2.875x10'UNION ALL

SELECT'5.625X14.25-2.875x11.5'UNION ALL

SELECT'23.75X20.25-15.5x19'UNION ALL

SELECT'5.875X10.75-3x10.5'UNION ALL

SELECT'12.5625X10.75-9.6875x10.5'UNION ALL

SELECT'11.3125X10.75-8.4375x10.5'

)

SELECT

SUBSTRING(sig, CHARINDEX('-',sig,1)+ 1,CHARINDEX('x',sig,CHARINDEX('-',sig,1))-...