Search Results

Search found 37260 results on 1491 pages for 'command query responsibil'.

Page 542/1491 | < Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >

• Copy row to another row in same table and vice versa Sql Server

  - by AmRoSH

  I have Table and i want to copy data from row to another and vice versa and i have the rows IDs. is there any query to do that because i don't want make it by .net code i think sql query is easier than that. thanks

  Read the article

• Difference of two series in MySQL

  - by Brian

  I have a table with the following fields in MySQL: date, Value, Type. Type can be either exports or imports. I want a query that returns the trade deficit (exports-imports) for each month. Is this possible with a single query?

  Read the article

• sql server 2008 takes alot of memory?

  - by Ahmed Said

  I making stress test on my database which is hosted on sqlserver 2008 64bit running on 64bit machine 10 GB of RAM. I have 400 threads each thread query the database for every second but the query time does not take time as the sql profiler says that, but after 18 hours sql takes 7.2 GB RAM and 7.2 on virtual memroy. Does is this normal behavior? and how can I adjust sql to clean up not in use memory?

  Read the article

• how understand one result set is subset of another in twomysql select result set ?

  - by Ehsan Khodarahmi

  Hi I've 2 mysql select statements, suppose these are my queries & their result : Statement 1 : select id from a which returns this result set : { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 } Statement 2 : select id from b which returns this result set : { 3, 5, 10 } I want to write a query which determines whether resultset1 contains all records of resultset2 or not. I think needs a simple query, any suggestion ???

  Read the article

• print_any for F# 2.0

  - by user79339

  Hi, I am upgrading an old version 1.0 F# project to 2.0 using visual studio 2010. So many changes. I can't seem to find the print_any command that was littered all over the place in the old books and samples. I have installed powerpack but can't find it there either. Any idea where i can find this command. PS: I know I can easily implement it myself but was curious where this is now.

  Read the article

• directoryperdb issue

  - by Rich Blumer

  I installed MongoDB to run as a Windows Service on Win 7 and everything runs well. However, when I attempt to use the command --directoryperdb, it does not recognize this command. Does anyone know how to resolve this issue?

  Read the article

• Basic Google search using a shell script

  - by Lri

  Something like this but using just basic shell scripting: #!/usr/bin/env python import urllib import json base = 'http://ajax.googleapis.com/ajax/services/search/web?v=1.0&' query = urllib.urlencode({'q' : "something"}) response = urllib.urlopen(base + query).read() data = json.loads(response) print data['responseData']['results'][0]['url'] Any more convenient alternatives to ajax.googleapis.com? If not, how should you encode the URL and parse JSON?

  Read the article

• Jquery Keypress is not working for my input box.

  - by alex

  $("#epFilter").keypress(function(){ query = $("#epFilter").val(); alert(query); }); In this code, whenever I type in my text box, it always alert one character less. It doesn't catch the last character. Why?

  Read the article

• How can I compare tables in two different databases using SQL?

  - by chama

  I'm trying to compare the schemas of two tables that exist in different databases. So far, I have this query SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('table1') The only thing is that I don't know how to use the sys.columns to reference a database other than the one that the query is connected to. I tried this SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('table1') but it didn't find anything. I'm using SQL Server 2005 Any suggestions? thanks!

  Read the article

• boost library gives errors on ubuntu

  - by senioritta

  I am trying to compile a package on ubuntu 8.1 when executing this command: ./configure I get the follwoing error: checking for Boost headers version = 103700... no configure: error: cannot find Boost headers version = 103700 knowing that I installed needed boost packages using these command: $ apt-get install libboost-dev libboost-graph-dev libboost-iostreams-dev Can anybody help please?

  Read the article

• Setting Up virtualenv with python2.6

  - by Zach

  I'm setting up a virtualenv, but it seems to be using python2.5 by default. I'm using this command virtualenv newenv --no-site-packages -p python because the python found on my path is python2.6. I believe this to be true because when I type python and go into the shell, it tells me it's 2.6. When I create the virtualenv with the above command and launch the shell, it tells me I'm in 2.5. Anyone else have this issue?

  Read the article

• Generate a JasperReport for a specific user

  - by user530846

  I'm looking at using the JasperReport Web Services to create user specific reports. As opposed to getting a user to supply the name of the user to use for the query (and therefore expose a risk of users viewing each others data), I'd like within JasperReport to pull out their identity from their (Basic) authentication details from the web service run report call and then use their user name as a query parameter when running the report. Is there any documentation or examples on how this can be achieved?

  Read the article

• How can I ask Maven for a list of the default repositories?

  - by Derek Mahar

  What command can I use to ask Maven for a list of the default repositories that it searches for its dependencies? If no such command exists, where else may I look to find this default list?

  Read the article

• MySQL & PHP: auto connect to DB or to properly way to pass host/db to MySQL methods

  - by SODA

  Hi, does anyone know of a known method in PHP to auto connect to MySQL db/table in case an app is using multiple databases on multiple hosts? Question 1: are there scripts around that allow to auto connect to necessary host/DB based on query? Question 2: if above is not possible, is there a known approach to properly passing host/DB info to make sure app is properly connected before executing the query?

  Read the article

• How to implement something like PHP's http_build_query and the reverse in javascript?

  - by wamp

  <?php $data = array('foo'=>'bar', 'baz'=>'boom', 'cow'=>'milk', 'php'=>'hypertext processor'); echo http_build_query($data); /* Output: foo=bar&baz=boom&cow=milk&php=hypertext+processor */ How to do similar thing in javascript,say, get the query string from the array ,and convert the array to query string?

  Read the article

• buttons inside scrollviewer problem

  - by Miroslav Valchev

  Hello, everyone. I couldn't find a solution to my problem eventhough I believe that others have come across this too. Basically, there are like twenty buttons in a wrap panel, which is inside a scrollviewer. The problem is that when I want to scroll the list, the click event fires the triggers. Really would appreciate help on this one. <ScrollViewer> <ScrollViewer.Content> <toolkit:WrapPanel Orientation="Horizontal" HorizontalAlignment="Left" VerticalAlignment="Top" Width="420"> <Button Style="{StaticResource imageButtonStyle}" > <i:Interaction.Triggers> <i:EventTrigger EventName="Click"> <cmd2:EventToCommand Command="{Binding SelectCommand, Mode=OneWay}" CommandParameterValue="1" /> </i:EventTrigger> </i:Interaction.Triggers> </Button> <Button Style="{StaticResource imageButtonStyle}"> <i:Interaction.Triggers> <i:EventTrigger EventName="Click"> <cmd2:EventToCommand Command="{Binding SelectCommand, Mode=OneWay}" CommandParameterValue="2" /> </i:EventTrigger> </i:Interaction.Triggers> </Button> <Button Style="{StaticResource imageButtonStyle}"> <i:Interaction.Triggers> <i:EventTrigger EventName="MouseEnter"> <cmd2:EventToCommand Command="{Binding SelectCommand, Mode=OneWay}" CommandParameterValue="3" /> </i:EventTrigger> </i:Interaction.Triggers> </Button> <Button Style="{StaticResource imageButtonStyle}"> <i:Interaction.Triggers> <i:EventTrigger EventName="MouseEnter"> <cmd2:EventToCommand Command="{Binding SelectCommand, Mode=OneWay}" CommandParameterValue="4" /> </i:EventTrigger> </i:Interaction.Triggers> </Button> </toolkit:WrapPanel> </ScrollViewer.Content>

  Read the article

• Dynamic sql vs stored procedures - pros and cons?

  - by skyeagle

  I have read many strong views (both for and against) SPs or DS. I am writing a query engine in C++ (mySQL backend for now, though I may decide to go with a C++ ORM). I cant decide whether to write a SP, or to dynamically creat the SQL and send the query to the db engine.# Any tips on how to decide?

  Read the article

• Date range intersection in SQL

  - by Will

  I have a table where each row has a start and stop date-time. These can be arbitrarily short or long spans. I want to query the sum duration of the intersection of all rows with two start and stop date-times. How can you do this in MySQL? Or do you have to select the rows that intersect the query start and stop times, then calculate the actual overlap of each row and sum it client-side?

  Read the article

• how to remove repeated record's from results linq to sql

  - by Sadegh

  hi, i want to remove repeated record's from results but distinct don't do this for me! why??? var results = (from words in _Xplorium.Words join wordFiles in _Xplorium.WordFiles on words.WordId equals wordFiles.WordId join files in _Xplorium.Files on wordFiles.FileId equals files.FileId join urls in _Xplorium.Urls on files.UrlId equals urls.UrlId where files.Title.Contains(query) || files.Description.Contains(query) orderby wordFiles.Count descending select new SearchResultItem() { Title = files.Title, Url = urls.Address, Count = wordFiles.Count, CrawledOn = files.CrawledOn, Description = files.Description, Lenght = files.Lenght, UniqueKey = words.WordId + "-" + files.FileId + "-" + urls.UrlId }).Distinct();

  Read the article

• CAML queries: how to filter folders from result set?

  - by drax

  Hi all, I'm using caml query to select all documents which were modified or added by user. Query runs recursively on all subsites of specified site collection. Now problem is I can't get rid of folders which are also part of result set. For now I'm filtering them from result datatable. But I'm wondering: Is it possible to filter out folders from result set just by using caml?

  Read the article

• Two FullTextSqlQueries?

  - by SeeBees

  There are two FullTextSqlQueries, one in the namespace Microsoft.Office.Server.Search.Query, and the other in Microsoft.Office.Server.Search.Query. What's the difference between these two? Which one should I use?

  Read the article

• Need ad-hoc reporting component

  - by Nelson

  We need some simple ad-hoc reporting solution for our ASP.NET web-site. Just an ability to build a query with user friendly interface, then show the result of this query in some table and maybe export it to Excel or print. The solution must be quite easy for end users (our site visitors) who know nothing about databases, SQL and other tech stuff.

  Read the article

• How to insert a float into a SQL table in the right locale

  - by SoMoS

  Hello, I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server? Do i need to detect the locale of the server before constructing the query or what? Thanks in advance mates.

  Read the article

• How to insert <br/> after each 5 results?

  - by Axel

  This is my code: $query = mysql_query("SELECT * FROM books ORDER BY id") or die(mysql_error()); while($row = mysql_fetch_assoc($query)) { echo $row["bookname"]." - "; } How to make only 5 books displayed in each line, by inserting a at the start if the row is 5 or 10 or 15 etc... Thanks

  Read the article

• Converting ObsevableCollection foreach to lambda.

  - by Jitendra Jadav

  Hello Guys, I am working some ObservableCollection converting to lembda it will give me error this is my actual code . foreach (var item in Query) { userDetail.Add(new UserDatail(item.ID,item.Name, item.Address, item.City, item.Pin, item.Phone)); } and I am try to add as lembda Query.ToList().ForEach(x => userDetail.Add(x.ID,x.Name,x.Address,x.City,x.Pin,x.Phone)); This will give me error. Thanks..

  Read the article

< Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >