Viewing 15 posts - 1 through 15 (of 26 total)
Thanks for your reply!!!
We have around 1500 tables and 15000 columns. My concern is not about the increase in DB size(memory).
I am more interested to know that if we...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
February 28, 2013 at 5:55 am
Thanks for your reply!!!
We have around 1500 tables and 15000 columns. My concern is not about the increase in DB size(memory).
I am more interested to know that if we...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
February 28, 2013 at 5:55 am
Thanq very much for the response and for giving me a nice idea of uisn CTE's which will surely help me further
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
February 16, 2010 at 2:20 am
Hi ,
Thanq i made the final query , integrating with yours . One small ques will it be faster for huge data coz this i need in reports where already...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
February 15, 2010 at 11:31 pm
Hi ,
This works pretty good , But i have to integrate with my query like i have a query for that i need to add a where condition saying
where...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
February 15, 2010 at 11:23 pm
k my tables are
package_event (Id int,name nvarchar(50),fk_event int)
workscope_event (fk_user int,fk_event int)
data : Package_Event
Fk_Package, Fk_Event
...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 25, 2010 at 12:57 am
Hi,
I have a table workscope_event where i will be having event id and user id mappings,
say for user id --> 1 mapped to events 1,2,3 where i have total 10...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 25, 2010 at 12:31 am
Hi ,
I have created a table say "dummy" with one column say "xml" of type XML. I havent created any XML index on this table. I will create now and...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 7, 2010 at 4:57 am
Hi ,
I have inserted that xml text into one table just because, to read it from some where instead of file. There will be always one row in the table...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 7, 2010 at 4:19 am
Sorry for that the name tags i gave in the above example is the one wich i entered just to say that there are 1500 columns but i have proper...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 6, 2010 at 8:46 pm
Hi ,
The above solution using @xml.nodes for this data is very very slow compared to OpenXml, iam using sqlserver 2008 can you please suggest any other option because the aboce...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 6, 2010 at 8:44 pm
Hi Jacob,
Its working thanqqqqqqqqqqqqqq
i tried like this , I have created linked server on my own and then the below one.Thanq for suggesting me linkedserver .........:-)
select TOP (100) PERCENT *...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 5, 2010 at 9:19 pm
Hi Jacob,
Iam getting the following error
Msg 7357, Level 16, State 1, Line 1
Cannot process the object "exec CsvFull". The OLE DB provider "SQLNCLI10" for linked server "(null)" indicates that...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 5, 2010 at 8:51 pm
Hi All,
Thank you very much for above solution , Iam actually waiting for that ..... I will try that immediately.
Once again thank you for your solution
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 5, 2010 at 8:06 pm
Hi,
I have a tool in .NET which accepts only views but i have some procedures which returns some result sets but Id is common in all the result set so...
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/
January 4, 2010 at 3:31 am
Viewing 15 posts - 1 through 15 (of 26 total)