im not quite sure what you are attempting to do however my syntax would be slightly different
i would write that as
var results = db.tbl_ShearFix_Projects
.Select(x=>x.projectid)
.Distinct()...
if you get the NAS it should link to your wireless and wired computer without issue
you may have to setup some permissions for it but that should be about it
you will then be able to access it by going to
\\NASNAME\
or mounting it as a drive or Library
how many tables are there that you need to query?
could you not set up a excel list of
Key , table
and use that in a console app to generate results?
performance issue aside (you can always use a backup on a separate machine) would that not solve your issue?
this is what i do also
currently spending 75% of my time completely revamping the entire reporting Library
(requirements Phase atm)
starting to build up a Warehouse (more like specific KPI / MI Databases)
Average Day involves writing Lots of SQL, Reacting to Last minute requests...
put map of Europe up on the wall then throw a dart at it and try to reach that exact point by public transport (planes not included) how you get back is optional
i have always wanted to do that.
just take the map with a hole in, your back pack and good pair of shoes spare set of clothing...
Firstly as the posts above state we should count ourselves lucky we live here.
personally i think raising of Tuition Fees is a good idea as it will stop people going to university for a course that will likely be a 2hr a week course spread over three years and have little relevance to there...
Question, how do you plan on importing 50 million records into excel? the number of Rows in 2007 is a little over 1 million also there is a maximum number of records excel can graph (32000).
i would consider the use of a DataBase and a Charting utility
in terms of inputting data on a...
i would firstly check for the Indexes in the Tables then check the fragmentation of them,
failing that i would create a subquery
essentially
SELECT derivedtbl_1.UserName, derivedtbl_1.GroupID, derivedtbl_1.EASStatus, derivedtbl_2.COMPRESSED_SIZE, derivedtbl_2.UNCOMPRESSED_SIZE...
you have msdn and have not heard of Visual studio?
any way just grab Visual Web developer express (c#) and you'll have 90% of what you will ever need for free
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.