2,935 Topics
 | |
| | Hi Team! Anybody could help me with this hell query? I got 2 tables: Table: STUDENTS with only 1 field: [name] id1: jose id2: william id3: john id4: sandra Table: COURSES with 2 fields: [name], [course] id1: jose, saxo id2: william, cook id3: john, saxo id4: sandra, garden I wanna … |
| | Dear Friends, I would like to know how to find exact word from a text data available in SQL String. I mean, Suppose I have a string available in Table1; ie , "My latest activities" I want to search the word like test. Currently I am using query [code=sql]select * … |
| | Hi guys, I'm new here. I have a problem though. I can perform a bulk insert from .csv file to MS SQL Server 2005. My problem here is that there are foreign tables in the .csv file. What I want to happen is that these data should be replaced with … |
 | Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …  |
| | I know mysql but I now have a job where mssql is needed. I am having a problem inerting multiple rows at once. MySQL Query: [code=mysql] INSERT INTO colours (ccode, cdesc) VALUES ('35', 'Green'), ('35', 'Turquoise') [/code] How do I get the same result with MSSQL? Thanks in advance. |
| | In every asp.net webpage i am using more than one sql commands to get the data and store it in data set. after the execution of the front end asp.net is it possible to go back and open sql server and see in a window which all statements got executed …  |
| | Hello! I've got web application created for MSSQL and IIS. There are two directories in this application - Scripts and WebSite. In Script there is file CreateDb.sql. I need to run it so that it can create database. I changed in that file one line into this: CREATE DATABASE [NameOfDb] … |
| | Hello! I tried to install MS SQL server express 2008. I run SQLEXPR32_x86_ENU.exe and see: "SQL Server 2008 Setup requires Microsoft .NET Framework 2.0 SP2 to be installd. Download and install .NET Framework from [url]http://www.microsoft.com/net/[/url] and then return Setup". I downloaded dotnetfx.exe - that is .NET Framework 2.0 SP2 and … |
| | Hi everyone, It's my first time with looping through data in a query. I know there are two ways of doing this and one is using CURSOR (I read it'snot the nicest thing to use). Wouldn't mind hearing your thoughts. I will copy and paste my first attempt at usingCURSOR …  |
| | hi there, in my database, I have a match table, and one of the columns is matchdate I also have a country table, where each country has an ID. I have a seasons table where each row is linked to a country and has a start date and end date. … |
| | Hi everyone! I have the following problem I am trying to solve: I have one table with data and need to access the same column twice, everyone with different criteria and then output the results on one table. I tried [code=sql]SELECT e.user, SUM(e.column), SUM(f.column) FROM table AS e INNER JOIN … |
 | Hi I already Install the MS Sql server 2005 into my machine,but I want to install the Sql server 2008 into my machine.I want to install the sql server into "D:" Drive, because of few space available in "C:" drive. 1)Can I install sql server 2008 into "D:" drive? 2)If … |
| | I have a huge stored procedure which calls other mini-ones. The problem is that I need a temp table and I'd like to avoid a real table being used as a temp one. You've probably guessed by now, but if you haven't, a table variable is created at the beginning … |
| | Hi everyone. I'm relatively new to MS SQL but one of my clients has a site based entirely around it so I am having to get to know it a bit better. While trying to clean out some of the fake emails from the mail list table they all got … |
| | Hi all, I have searched high and low for this answer but turned up nothing concrete. I am using MS SQL Server and ASP. I have a database with a table which includes a field with a TEXT datatype. I have created a simple stored procedure to select all the … |
| | hiiii how can I use 2 different select statement to insert 2 different values in same insert statement ???? |
| | Hi all I crated a Report in SQL Server Reporting Services. The Report uses 1 parameter. When I exe the Report in my IE it asks me for the parameter and then run fine. When I use Subscriptions' I can put there my email. And sent it to me. (Work … |
| | Hello all, i have a small question. In mysql i can do "select 'abc' into outfile 'c:\out';" is it possible to be done only with sql querry (to be executed at the server manager). I tryied select 'abc' into outfile 'c:\out.txt' and got the error : Incorrect syntax near 'c:\out.txt'. |
| | Posted - 08/08/2009 : 20:48:04 Hello, I hope someone may have some suggestions for a SELECT statement I am trying to create. I have a primary table like: Field1 Field2 Field3 1_____AAA____BBB 2_____BBB____AAA 1_____CCC____DDD 5_____DDD____KKK Secondary table like: Field1 Field2 Field3 Field4 1__________________X 2____BBB____AAA____Y 1____CCC___________Z ___________________J Desired Result: Field1 Field2 … |
| | Hello, I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 Issue I have a database in access 2003 that is the front-end and the backend on sql server 2005. I … |
| | Hi frnds I have a problem im using sql server 2005 I have a database on my local machine and on a web server. I want that through stored procedure or a query i shud b able to synchronise the database on the remote serveras the local database... Can anyone … |
| | hi friends i am a new bee to the world of sql server, started with it a few months back... i deleted a table from sql server by mistake, and trying to recover it. but i dont hav any backup concerned. is it possible to recover that table without backup, … |
| | Hello everyone, I'm disapointed around problems of fct datetime:) I have a datetime column and I want to display the time period of the days in a datagrid: For exemple : H1 = Monday to Friday, from 06:00:00 to 21:59:59 H2 = Monday to Friday, from 22:00:00 to 05:59:59 H3 … |
| | I have a web application for recording time, bonuses and commissions for employees. I am having a hard time joining three tables together. Here are the tables: employee - provides employee information including the primary key emp_id emp_timecard - provides recorded time from employees tc_bon_com - provides bonuses and commissions … |
| | I am trying to design a Query in SQL that will enable the user to enter a customer code. However being new to SQL I do not know the language. I have selected the data from the tables, however I want to add criteria. In Access I used [] and … |
| | My problem is as follows: 1- suppose you are in database db1 2- in db1 there is a role :role1 3- there is another database :db2 4- db2 contains a stored procedure :sp1 5- now, I want to grant the role (role1) in db1 a permission to execute the stored … |
| | hi friends We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy … |
| | Ok, I guess wasn't as specific as I needed to be. Here is essentially what I need. I have two separate tables application_status and application_status log. Within the application status table there is the application_status_id and the application_status_description. The application_status_log table holds information on applications and the connecting factor between … |
| | I am a newbie with sql and need some help. Question Details: ARTIST.Name Artist.Nationality Transaction.purchaseDate Transaction.SalesPrice... Customer.Name Customer.Phone.AreaCose Customer.Phone.LocalNumber Customer.Name... (The Ellipses(...) refer to the structures that can repeat. Code SQL statements to update this view as follows: a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby. I … |
| | Can anyone help me out with this? SalesPerson Name Age PercentOfQuota Salary Abel 24 63 120,000 Baker 56 38 42,000 Jones 34 26 36,000 Murphy 64 42 50,000 Zenith 45 59 118,000 Kobad 43 27 36,000 Order Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction … |
The End.