Viewing 15 posts - 4,471 through 4,485 (of 5,109 total)
@ben that doesn't give the correct answer, no, look at the OP's sample data. You've effectlvely just captured the next ReferralID in your query, something that would be much better...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 7:03 am
kreuzer - Monday, January 16, 2017 1:40 AMHi,there is a very simple way to activate the "dark theme":
https://community.spiceworks.com/how_to/136505-enable-dark-theme-in-sql-server-management-studio-2016
Kind regards,
Andreas
Huh, interesting. It...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 6:33 am
SSIS comes with an FTP task by default, however, you don't have much functionality with it (you can't check all the files on the server and get their age for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 4:52 am
Your question doesn't explain your logic. As i asked, I need to know why your output is what it is. To quote my previous post:
My confusion arises from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 4:34 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 4:09 am
You'll need to use a lookup table.
I've done this with a CTE, but if you have a true lookup table, you should use that. Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.USE DevTestDB;
GO
Larnu.uk
January 16, 2017 at 3:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 2:20 am
Anandkumar-SQL_Developer - Sunday, January 15, 2017 11:28 PMHi Please some one help me who have a good knowledge in XML its little emergency.
Please...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 16, 2017 at 1:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 1:53 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 4:14 am
You're going to be hard pressed to get a solution then. As Eirikur pointed out, an escaped underscore in an = statement doesn't work(well, it searches for '[_]', not '_')....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 3:52 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 3:36 am
The above also screams SQL Injection at me. Are your getting the values of @sqlstmt and @filterstmt from the SP's paramters?
What if I were to pass the following...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 3:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 15, 2017 at 2:53 am
It might just be me, but I;m afraid I don't understand what you're trying to achieve here.
My confusion arises from "those column values should added as a xml...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 14, 2017 at 1:49 pm
Viewing 15 posts - 4,471 through 4,485 (of 5,109 total)