Viewing 15 posts - 1 through 15 (of 33 total)
As I understand it (and already wrote in the top posting on this page btw) you need a way to determine if an entry is a group or person.
Currently you...
April 13, 2011 at 11:04 am
The code you provided did not work.
Is debtMapping = codeMappingTable and codes = dept?
April 13, 2011 at 10:37 am
please provide some sample data as INSERTS, I will look over it when I'm in the office the next time (Wednesday I believe)
April 9, 2011 at 12:48 am
You should be able to accomplish this by adding an IF to the function and an additional column like "IsGroup" to your table.
HR and IT have IsGroup=true. (Or somethin like...
April 1, 2011 at 1:33 am
I don't really understand, what you are trying to achieve. Could you elaborate?
March 31, 2011 at 1:47 am
Ok, people. I've got it working again.
Here's what I have done:
1. Rename all the *.config files in the Reporting Services directory to *.config.bak (so the installer thinks there are not...
July 28, 2010 at 12:04 pm
thanks a bunch, but all the honor belongs to stackoverflow user Recep who provided the solution I adapted to fit my needs
March 15, 2010 at 11:21 am
I had the same problem.
It can be solved easily without XSL using a recursive funtion. Check the answer on this thread:
http://www.sqlservercentral.com/Forums/Topic879380-21-1.aspx
March 12, 2010 at 4:12 am
thanks for the info!
I already answered the question myself based on a thread on stackoverflow.com
1. Create a recursive function
CREATE function SelectChild(@key as int)
returns xml
begin
...
March 12, 2010 at 4:09 am
thanks for your answer! But unfortunately this returns
<IndustryCodes_Path IndustryCode="IND" />
<IndustryCodes_Path IndustryCode="AUTO" />
<IndustryCodes_Path IndustryCode="PHARM" />
<IndustryCodes_Path IndustryCode="FIN" />
<IndustryCodes_Path IndustryCode="CFIN" />
<IndustryCodes_Path IndustryCode="CMRKT" />
<IndustryCodes_Path IndustryCode="CON" />
<IndustryCodes_Path IndustryCode="IMPL" />
<IndustryCodes_Path IndustryCode="STRAT" />
which is a flat...
March 10, 2010 at 10:24 am
Here's what folks @ stackoverflow answered, which I found is (partly) working:
1. create a recursive function:
create function SelectChild(@key as int)
returns xml
begin
return (
...
March 10, 2010 at 6:02 am
I found the answer myself.
The problem is not the wildcard, but the string-markers. The index server does not use apostrophes but quotation marks. So the correct SQL should be...
August 4, 2009 at 6:16 am
the linked server isnt a SQL server, but a windows server. I just access the index server of it. I'm pretty sure the statement is correct, cause it returns results...
August 4, 2009 at 3:09 am
Well, you would of course be right if I would put a static SQL-string into my code. The point is, that I want our useres to flexibly build up a...
February 9, 2009 at 5:04 am
Thank you all very much. I really appreciate your help!
nonetheless I made a whole different approach, which may be not as high-performance as your solutions, but it saves work in...
February 6, 2009 at 8:10 am
Viewing 15 posts - 1 through 15 (of 33 total)