3,481 Topics
 | |
| | Hi i am wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick off either the First letter or first two letters and group by this. I have figured out how to group by the first to characters of the postcode using …  |
| | hi, how to auto increment the value in database table when the button clicks.i have created a table named register .when the user completes his registration we will generate the receipt based on the registration. so for every receipt we will generate the receipt no on that. when we click … |
| | Hello Everyone, Please tell me, how to insert data into two tables with one SQL query? |
| | My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using SQL Server 2008. I know that if I were backing up the database to begin … |
 | Hello everyone. This is quite possibly not the place for this but it is more to do with SQL than the other things included so I apologise if I am wrong. I am looking for some help on a task I have been set. When I say help, what I … |
| | hi, i need to get the column values from the table login.it contais two columns ,userid and password. i want to check the userid and password values when the user logged in.so i have to compare the entered textbox value with the saved value. i am using the code is … |
| | I installed Visual Studio 2008 but when I creates any database it gives me error that" SQL server don't allow remote connection" & if i uninstalled only SQL Server & it'r related packeges like VSS Writer, setup support files etc. & I agian installed fresh copy of SQL server then … |
| | Is there a way to upgrade SQL Server Express 2008 basic to Advanced Series without having to reinstall the whole thing? |
| | Hello! I'd like to run mssql script (file with extension sql). I installed Microsoft SQL Server 2008 and run in Command Prompt: C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql" [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Server Native Client 10.0]Login … |
| | Hello, I've the following problem: I need to insert to a table the following customer data: Year No., Month No., CustomerName, CustomerID... The problem is with the Month No. (MonthNo is the table column name). I'm using the following command, in a stored procedure, after the insertion. [code=sql]SET @MonthNo = … |
| | 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 … |
| | Have "Security Warning" pop-ups "application cannot be executed...do you want to activate your antivirus software now?" - which links to a fake-looking site to purchase the software. Also have sounds playing from my computer (usually ads) even when I don't have an internet browser open. I've run multiple virus, spyware …  |
| | 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 * … |
| | I am copying excel file to mssql database's table, problem is this : I have some informations in 4 rows but mssql database table has 13 rows. fisrt 4 rows has my information and 4-13 rows has null values. sbccm from 1 to 14. where is the problem I donw … |
| | 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' …  |
| | Hello fellow "Developers" I am trying to create the local search functionality for a website using C#/APS.Net going against a MSSQL Dbase. I'm not really sure where to start. I have uploaded an attachment of what I think needs to be done. If someone could have a look and point …  |
| | 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 ???? |
| | Okay, I had a thread in the HTML and CSS section, but I'm going to put a new one here with more detail. My friends have created a Cabal private game server, on THEIR computer. Im trying to create a site for it using my computer, but AS OF NOW, …  |
| | 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 … |
| | Hello Everyone, I am having difficulty looping through an array of stored procedures. The issue: Array with x number of stored procedures Column names identical in all Stored procedures (PO_Date, PO_Data, PO_Pointer) Each stored procedure has three inputs pi_pid, pi_from, pi_thru Must execute each stored procedure in the array Must … |
| | 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 … |
| | I would like to add a column to an existing table, where the new column would only have running numbers starting from 1. If I've understood correctly, the "create index" command is not the right way to do this, as that's attached to just certain columns to speed up querying. … |
| | Hello! My internet connection is gone and I dont know why! Can you help me ? since 4 days ago my antivirus(kaspersky) has been detecting some threats, I did the online scan and after booting, the connection was gone. Here is my log Logfile of Trend Micro HijackThis v2.0.2 Scan … |
| | Hi, I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code. eg- MobileNo (this is the field name) ------------------------------------- 1. 6016-2880537 2. 6012-3137200 so there is about 400 records in the table … |
| | I have a problem. I hope that someone can help me. I have to do an analysis of an student course registration database. The Case is that I have an database application of a student registration system. Students can enrolll for one or more courses, When they enroll, there will … |
| | Hi, We have schedule a job through SQL agent in which We want to access the data of a specific field from SQL table For example we have a field named interviewDate, we have to compare it with current date. now we have to write a stored procedure to read … |
The End.