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...

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...

Thanq very much for the response and for giving me a nice idea of uisn CTE's which will surely help me further

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...

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...

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

...

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...

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...

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...

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...

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...

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 *...

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...

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

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...