We are doing some R&D to use Sql server 2012 Power View feature in our asp.net application for dynamic reports and graphs.
Request all to provide your valuable inputs /thoughts/ experience on the same.
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Friday, September 5, 2014
Wednesday, October 10, 2012
Hi Team,
We have an requirement where we need to use a 32 bit dll developed in C++ in the 64-bit environment (Windows server 2008 and SQL Server 2005 64-bit). This 32bit dll is being loaded in SQL Server instance memory with the help of an extended stored procedure, as per existing functionality.
While executing the extended procedure in above mentioned 64-bit environment, we got the error – ‘Could not load dll’. The dll we are trying to load in 64 bit environment in turn uses another 32 bit dll which is a third party dll with no source code available.
We have tried recompiling the 32 bit dll into 64 bit but received following linker errors:
<image missing>
If anyone have faced or come across similar challenge then please suggest the approach taken. Any inputs/suggestions to recompile the dll into 64 bit will really help us to take this forward.
Regards,
Ankur Kumar
Hi,
I need to write query to fetch the hierarchy based on child node (leaf node), I am able to fetch the same using parent node (top level node).
Below is the query to fetch the hierarchy by parent id (here 107 is parent id)
SELECT node_id,
node_name,
parent_id,
node_depth
FROM temp_node_details nd
START WITH nd.node_id = 107
CONNECT BY PRIOR node_id = parent_id
But I need to get same hierarchy based on chile node (last leaf node, ie: 109)
Please help me write this query, thanks for you’re help in advance.
Query’s to create sample tables and its data.
create table temp_node_details (node_id integer, node_name varchar2(300), parent_id integer, node_depth integer) ;
insert into temp_node_details values(107, 'DDD', 0 , 0);
insert into temp_node_details values(108, 'DDD1', 107 , 1);
insert into temp_node_details values(109, 'DDD2', 108 , 2);
I am using Oracle DB.
Thanks & Regards
Basagalla,
Friday, July 20, 2012
Hi All,
We have an project requirement to implement an scribble pad which saves and retrieves Unicode data from SQL server 2005.
Please let me know if anyone has performed this kind of activity.
Scribble pad –is nothing but textbox which takes input in any language and save to database
Thanks,
Datta
Hello, my name is Monikandan. I'm a 40 year old self-employed ML Group from the Nagercoil.