Viewing 15 posts - 16 through 30 (of 56 total)
INSERT INTO #answers
VALUES(1,'1,2,3,4,'),
(2,'5,2,'),
(3,'3,4,')
GO
These values all have a blank at the end of them. Is that intended?
March 3, 2017 at 12:55 pm
At the moment...
March 3, 2017 at 12:26 pm
Why do you want to leave a potential performance problem available for anyone?...
March 3, 2017 at 12:05 pm
DECLARE @String AS VARCHAR(100)
DECLARE @Search_String AS...
March 3, 2017 at 12:00 pm
Why do you want to avoid the WHILE loop? I can't see this being a performance issue and if so what size string are you searching? And if you just...
March 3, 2017 at 11:47 am
If you're going to use this on a regular basis I would probably turn it into a Scalar-valued Function so you can just pass in the string and search string...
March 3, 2017 at 11:02 am
Tell him he's right, you agree with him and you've submitted this request to the design team. But because it's the government it has to go through an approval &...
March 3, 2017 at 9:27 am
Aaron, so is this a performance issue? How much data are we talking about here? How long does the query take to run with the ComplexQuery in there twice? How...
March 3, 2017 at 9:01 am
Window functions are only allowed in the SELECT and ORDER BY clause. So if you really wanted to use one of them then the best option would be to put...
March 3, 2017 at 7:12 am
You're welcome. If you haven't worked with Common Table Expressions that much just note that any statement that comes before it will need to end with a semicolon. Some people...
March 2, 2017 at 1:36 pm
With CTE AS
(
SELECT
ID
,CancerType
,Sex
,Rate
,ROW_NUMBER() OVER(PARTITION BY CancerType Order by Rate desc) as 'Row'
FROM tmpRate
)
SELECT ID, CancerType,...
March 2, 2017 at 1:13 pm
DBA = 2 am call when the servers down;
T-SQL programmer = sleeps like a baby;
C# programmer == sleeps like a baby;
😀
February 22, 2017 at 1:24 pm
So, I am wanting to find what are the records a that are different...
February 22, 2017 at 11:08 am
T-SQL Fundamentals by Itzik Ben-Gan is now in it's 3rd edition. I've read the first edition once, the second edition multiple time and now I just started reading the 3rd...
February 21, 2017 at 6:09 am
Don't you just love it when DB designers leave out primary key or unique key constraints? If it wasn't for poor database design we wouldn't get to have so much...
February 17, 2017 at 6:19 am
Viewing 15 posts - 16 through 30 (of 56 total)