Search Results

Search found 6846 results on 274 pages for 'ms 365'.

Page 166/274 | < Previous Page | 162 163 164 165 166 167 168 169 170 171 172 173  | Next Page >

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  Read the article

• Stored Functions with Linq to Entities

  - by Lawnmower

  Hi, How can I make a MS-SQL stored function availabe in LINQ expressions if using the Entity framework? The SQL function was created with CREATE FUNCTION MyFunction(@name) ...). I was hoping to access it similarly to this: var data = from c in entities.Users where MyFunction(c.name) = 3; Unfortunately I have only .NET 3.5 available.

  Read the article

• Unable to install gem "pg" on Ubuntu 12.10 (AMD64)

  - by Lynx_Eyes

  I've been (unsuccessfully) trying to install the "pg" gem on my ruby 1.9.3-p286 but nothing seems to work. I've already installed postgresql (9.1), libpq-dev and a few others like postgresql-server-dev-9.1. I've tried to pass the "with-pg-config" flag to the gem install but simply nothing seems to work. Every time I try to install the gem it outputs something like this: Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /home/lynux/.rvm/rubies/ruby-1.9.3-p286/bin/ruby extconf.rb checking for pg_config... yes Using config values from /usr/bin/pg_config checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for pg_config_manual.h... yes checking for PQconnectdb() in -lpq... no checking for PQconnectdb() in -llibpq... no checking for PQconnectdb() in -lms/libpq... no Can't find the PostgreSQL client library (libpq) *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/home/lynux/.rvm/rubies/ruby-1.9.3-p286/bin/ruby --with-pg --without-pg --with-pg-dir --without-pg-dir --with-pg-include --without-pg-include=${pg-dir}/include --with-pg-lib --without-pg-lib=${pg-dir}/lib --with-pg-config --without-pg-config --with-pg_config --without-pg_config --with-pqlib --without-pqlib --with-libpqlib --without-libpqlib --with-ms/libpqlib --without-ms/libpqlib Gem files will remain installed in /home/lynux/.rvm/gems/ruby-1.9.3-p286@phisiodata/gems/pg-0.14.1 for inspection. Results logged to /home/lynux/.rvm/gems/ruby-1.9.3-p286@phisiodata/gems/pg-0.14.1/ext/gem_make.out What am I doing wrong? Is there something else that I should do before trying to install the gem? Thank you in advance. [EDIT] Ok, so joelparkerhenderson's answer set me to think that there might me something wrong with paths and libraries and a went on digging a little bit further.. I've found this awesome post and it solved! Basically the problem lies with RVM. So, my problem is solved and for anyone out there that might suffer from the same thing, follow the link!

  Read the article

• Rewrite SQL Fulltext Function to return Table only

  - by Alex

  I have a MS SQL Fulltext Function like this: (...) RETURNS TABLE AS RETURN SELECT * FROM fishes INNER JOIN CONTAINSTABLE(fishes, *, @keywords, @limit) AS KEY_TBL ON fishes.id = KEY_TBL.[KEY] When I use this function in LINQ, it generates a special return type which includes all fields of my "fishes" table, plus Key and Rank. How could I rewrite above query, or change something in LINQ, to omit Key and Rank and just return my "fishes" results (and to have the fulltext search result objects be of type Fish, which is what I really care about, so I don't have to cast)?

  Read the article

• How do I use Microsoft Sync Framework to sync between SQL Server 2008 and a .NET Webservice?

  - by DanG

  Does anyone have an example of how to use MS Sync framework with .NET webservices? I have SQL Server 2008, which is exposing data to BlackBerry devices through webservices using regular web methods. Can I use the Sync Framework to expose data through Web Services and to save it back to the database?

  Read the article

• How to stop ADO Data Service from sending 'MetaData' with the Data

  - by ActionFactory

  I'm using MS Data Service to send JSON. (Using a View in the DB) Problem is that it sends "__metadata": { "uri":"ALL THE DATA REPEATED"} with the Data - each time. This doubles our Data over the wire each call. THERE MUST BE A WAY TO TURN THIS OFF!!! WHO KNOWS HOW? THX

  Read the article

• Measuring the Process Time After the Link Click - Javascript, HTML

  - by sahs-i-muhterem

  Hi, I want to downlaod a MS Word document from a server. Creating the document in the server takes some time, and I need to measure the time it takes from clicking the link to the end of the download process. (or to the beginning of the download?) Any way for this? Thanks

  Read the article

• How to check if Thread finished execution

  - by user295502

  I have following problem: I want to check (C#) if thread has finished execution, i.e. if the thread method returned. What I do now is call Thread.Join(1), but this gives 1 ms delay. Is there any way to simply check if thread finished. Inspecting Thread.ThreadState just seems too cumbersome.

  Read the article

• Force Normal View when generating Word doc via HTML

  - by Jared

  I am creating an HTML document which we are then pushing out to MS Word using a "application/msword" content type. This works so far except that the files open in Word with Web View. Once Normal View is selected all works fine. Is there any way to force Word to open with Normal View instead of Web View?

  Read the article

• SQL Server: Migrate Stored Procedures between Databases, Instances

  - by LS

  I just copied my current database to a new database to find out only the tables are copied, How do I copy all stored procs the same way in one go? I do not want to create each stored proc one by one again running create queries Thank you in advance This is in MS SQL

  Read the article

• Is is possible/a good idea to edit workflows in Visual Studio?

  - by Greg McGuffey

  I've been doing a lot of editing in MS Dynamics CRM 4.0 using the web designer. I'm wondering if there is a more efficient way to edit workflows and wondering if VS 2008 could be used (and if it is more efficient). If so how? Thanks!

  Read the article

• Ruby on rails - how to retrieve connection strings

  - by Jett

  Hi Everyone, Are there any ways to retrieve the database connection string where my ruby is connected? what i would like to get is the: 1) Database name where the ruby is connected 2) The username of the SQL Server 3) Password of the SQL Server 4) Server name I want to store it in session variables. (I'am using MS SQL Server.) Please help! thanks!

  Read the article

• How to use the Automation object model of Microsoft Office packages (Word, Excel, etc.) in "plain" C

  - by Jason S

  I finally found the object model documentation for Microsoft Office. However it talks about interop assemblies and stuff that sounds like .NET. I don't use .NET directly, and I don't really want to learn much about it. Is there a way to just use plain COM/ActiveX classes/interfaces to automate MS Word/Excel?

  Read the article

• how to forward engineer database diagram from visio 2003 file ?

  - by dotnetcoder

  I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc. I want generate schema from the database diagram for sql server 2005 database.

  Read the article

• Cassandra Production ready on Windows?

  - by BlackTea

  Question anyone know of any success stories of Cassandra running on windows in a production environment? I'm doing some work on Cassandra and trying to find the correct platform for it currently the platform is windows running MS-SQLas the data store. what are the dis-advantages if any when running Cassandra on a windows environment.

  Read the article

• Software and Source Code License - Explained on simple statements

  - by Click Ok

  GPL, MS-PL, LGPL, MIT, Creative Commons, etc. There are a lot of licenses to your software and sources. I would like to know about that licenses (and another important ones), but on simple statements, like "free for non commercial use" or "source is free for modify but maintain the credits", etc.

  Read the article

• ALTER TABLE my_table ADD @column INT

  - by Andreas

  If i want to use a variable as name of the new column, is this posiblem in MS SQL? Example that dont work: ALTER TABLE my_table ADD @column INT

  Read the article

• SQL IN Statement using like syntax?

  - by StackUnderflow

  I would like to do something like this i.e., use wild card characters in the in clause: SELECT * FROM mytable WHERE keywords IN ('%test%', '%testing%') This is not supported in MS SQL.... Is there some other way to achieve it... Looking for something other than: SELECT * FROM mytable WHERE keywords like '%test%' or keywords like '%testing%' or.....

  Read the article

• PHP image resize using nearest-neighbor interpolation?

  - by shipshape

  I have a 16x16 sprite in PNG or GIF image format, and would like to display it on a website at 64 x 64 in all its pixelated glory. In Firefox 3.6+ and IE I can do this easily with CSS using image-rendering and -ms-interpolation-mode, but as this doesn't work in all browsers I'd like to resize the image on the fly using PHP instead. What's the best way to resize images using nearest-neighbor interpolation in PHP?

  Read the article

• string patterns to PCRE conversion code

  - by ammasajan

  Hi all, I would like to know, is there a conversion library for converting string patterns to PCRE regular Expression patterns. Sample Patterns: application/ms-tnef ARKADMIN_GET_ 34 ^MAIL FROM|3a| ? 2| Thanks in advance.

  Read the article

• Convert Office Documents without Office

  - by Benny

  We are in need of converting all MS Office documents to PDF, TIF, or any similar image format with no loss in formatting (these are official documents that cannot have tampering). Is there any way to do this without installing Office on the machine that would do this? Ideally, this would go on a server and run multi-threaded without the overhead of Office Automation. Thanks in advance!

  Read the article

• how do I subtract values from two select statements

  - by fishhead

  I would like to subtract one value from another value. The schema of the table is as follows: tag, datetime,value ------------ tag1, 2010-1-1 10:10:00, 123 tag2, 2010-2-2 10:12:00. 321 select * from ( (Select Max(Value) as [Value1] from History WHERE Datetime ='2010-1-1 10:10' and tagname ='tag1') as v1 - ( (Select Max(Value) as [Value2] from History WHERE Datetime ='2010-1-1 10:12' and Tagname ='tag2') as v2)) obviously I am lost...how do I do this. thanks ms-sql

  Read the article

• How to insert hyperlink into access database via sql?

  - by CSharperWithJava

  I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive. However, when I use a SQL INSERT statement to populate the hyperlink field, the value I give it only becomes the display text, not the actual link. How can I make the value a functional hyperlink? I'd think that the hyperlink data type would actually create hyperlinks. I'm using Access 2002 SP3.

  Read the article

• I am using Python on Windows. How do I delete my script after it is run?

  - by Zachary Brown

  I have written a Python script and compiled it into a MS Windows EXE file. I can modify the code, but how do I make it remove itself after running?

  Read the article

• tsql to know when a database was last shrunk

  - by Manjot

  Hi, In SQL 2000, 2005 and 2008, how can I know when databases were last shrunk on a MS SQL server? I want to do this using TSQL. Regards Manjot

  Read the article

< Previous Page | 162 163 164 165 166 167 168 169 170 171 172 173  | Next Page >