Viewing 15 posts - 1 through 15 (of 1,047 total)
Good explanation Eric 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 13, 2016 at 9:33 am
Hi,
Why are you doing deleting and insertion on the same id value?
what you want to accomplish from that.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 13, 2016 at 7:13 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 12, 2016 at 3:50 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2015 at 8:20 am
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 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 18, 2015 at 1:40 am
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
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 6, 2015 at 5:33 am
Eirikur Eiriksson (7/19/2015)
kapil_kk (7/18/2015)
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 19, 2015 at 2:11 am
using SSMS version 13.0
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 11:47 pm
GilaMonster (7/16/2015)
Not asking about SQL's version. Asking about Management Studio.Tried restarting SSMS?
Already tried but nothing happened...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 10:45 am
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 ...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 10:32 am
you can try below this query :
SELECT OrderId, TaskID, MAX(SerialNo)SerialNo
FROM table_name
GROUP BY OrderId, TaskId
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2015 at 1:48 am
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 =...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 17, 2015 at 1:53 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 11, 2015 at 3:34 am
Hi,
Can you please provide some more details?
what exactly you required in output with some sample data
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 26, 2015 at 3:16 am
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))-...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 19, 2015 at 4:12 am
Viewing 15 posts - 1 through 15 (of 1,047 total)