2,935 Topics
 | |
| | Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys |
| | Hello! I'd like to ask for some help. I'm using Visual Web Developer to create a web site, in which members can log in. It has the default aspnetdb.mdf database, in the app_data folder to store the member's data. This works quite good offline. My only problem is that I'd …  |
| | --query of a very large table SELECT abc AS 'productname', xyz AS 'quantity' INTO #tmptable FROM dfg WHERE blah -- --content of #tmptable: --productname quantity --product1 5 --product2 3 --product1 2 --product2 8 --product1 5 -- how does a query on #tmptable look like, if I want to receive the … |
| | I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error: The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for … |
| | Hi, I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any … |
| | Hi all, I am new to sql programming, How can we copy a database from a local system to server? Thanks in advance, karthik. |
| | Hello, I'm making a phone book application (ASP.NET, C#). I store general information of people such as name etc on one table called "people", and I've another table called "relatedInformation" which has 5 columns (ID, Name, Info, PersonID, Type). In this table I store all other information regarding people, because … |
| | Hi, I would like to know if it's possible to create a procedure, where we pass 2 arguments (the databases where the search must be done) and how to use those parameters in select clause What I would like to know is if it's possible something like: [CODE]create proc dbo.uspMySearch …  |
| | I'm working with SQL 7 on a Windows Server 2003 R2 Ent. Things will be working just fine and then we will for some unknowen reason start getting this error message and then we have to restore the DB to resolve it? This has now happened twice within the last … |
 | I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure … |
| | Hi, I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. … |
| | Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order … |
| | How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810 |
| | Hi there, I'm completely lost. I have 3 tables: - work (workID, description) - machine (machineID, name) - work_machine (machineID, workID, hours) What I want is to obtain a result similar to: work, machine1, machine2 A , 1 , B , 3 , 5 The problem is that the number … |
| | Hi all, I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone help me? I would need to get something like:- [CODE]Year | Month … |
 | Hi Everyone, Is there any in built debugger tool present in SQL Server for PL/SQL programs? Or can we configure a new debugger tool like SQL*Debug for Oracle? I need your help for this. waiting for your reply |
| | Greeting When it comes to SQL I'm a novice and I think what I want to do is WAY outside my expertise. I have a file management system called ProjectWise. Everything to create the folder path is located in a single table. You start with the lowest folder then you … |
| | Hi Group , A small Query ,I need to know how can I notify a new row entry in a table. to be more specific I have a table Users If at all a new users registers from web his details are stored in database. i would like to know … |
| | I am a SQL n00b, mostly using some hand-jammed ASP to access/update data. Now I have been tasked to develop a web map of our campus so I need the geospatial functionality of SQL 2008. I have a server (Windows 2003) that is limited by domain policy. I tried to … |
| | Hi guys. I have web site, but my hosting don't support php functions(mssql,sqlsrv,obdc_connect) :cry: for connections to MS SQL. I need that remote connect to MS SQL and receive from data online. Can you tell me, about alternative ways to import data from remote MS SQL server with php script. … |
| | Hello I have two tables a Master and Child. I want to return a recordset that has all of the Master records and any related child values. Sample Data: [INDENT][B]Master Table[/B] 'id' 'field1' 1 Test1 2 Test2 3 Test3 [B]Child Table[/B] 'id' 'masterID' 'field1' 1 2 Child1[/INDENT]The following code will … |
| | hello Guys, I facing a sql query problem which is i need to join many query into one query. That is : a) [code=sql]SELECT sum(Total) As [MONEY1] FROM ((SELECT SUM(T1.Amount+T2.Amount) AS Total FROM TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID) UNION ALL (SELECT SUM(T3.Amount+T4.Amount) AS Total FROM TABLE3 … |
| | using PHP with mySQL, or ASP with msAccess 2000 on a win2000Server web server; also using a "rich text format" utility to allow formatting of text in a text area: when i use the mySQL command "UPDATE", and data from the textarea is written to the database, it adds erroneous … |
| | Hi I have a problem when I am copying data from my excel document to sql server 2005. I have a document called database.xls Every time I try to copy files from the document to sql server. It comes up with an error. "Column 'tid' does not allow DBNull.Value." You … |
| | I am having a problem with my sql select statement below. What i am trying to accomplish is add a weighted gpa average to the actual average that gets calculated after a vendor gets assigned a gpa per job. The sectioned off area is where the problem lies. it is … |
| | I need to replicate data from server A to server B, server A is for transactional use, while server B is for reporting, where we do some database modification, for example posting, the problem is everytime the replicate agent run, it reset the modification into the original data. and when … |
| | We are building a query to count the number of events per hour, per day. Most days there are hours that do not have any activity and therefore where the query is run the count of activities per hour show up but there are gaps and the query excludes these. … |
| | Hello all! I need that awesome knowledge I know you have!! In your opinion, how would you create the following? Here are the specs. Database driven website Multiple users <200 from all over U.S. Intranet based < 700 different fields Server side will be mssql (IT requirement). Same record edit … |
| | How do search an entire SQL server - every database, every table, every field - for an exact match? Help much appreciated, Harry |
| | I need to connect my hosted vps in a data center to my sql server so I can pull info out of a database for our website. I setup a vpn by the windows dialup vpn wizard. It works fine but when I logoff the VPS it disconnects the VPN … |
The End.