2,935 Topics
 | |
| | I have written the following Stored Procedure: [code] USE [BHPropertyInfo] GO /****** Object: StoredProcedure [dbo].[usp_UnitAvgByRM] Script Date: 08/26/2010 16:47:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[usp_UnitAvgByRM] -- Add the parameters …  |
| | hi i am trying to convert data from excel sheet to dataset\datatable using sqlserver2005 as backend, so anybody can help me . Thanx in advance. |
| | I am working on an ASP VBScript to upload some files to my web server. When I get a compliation error, I go to the .asp file and make a change. Save, then reload the page. I still get the same error. For example; I had this statement: Dim ProductFilePath … |
| | |
| | [CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[createaccount] @account VARCHAR(15), @password VARCHAR(32) AS SET NOCOUNT ON DECLARE @DateActivated AS CHAR(8) IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) VALUES (@account, @password, @password, 'T', 'A', … |
| | This is the error i get when im trying to Run my AccountServ.exe it pop ups an error DB LOG Connect Failed. SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified |
| | Hello to all, I am using MS SQL 2005. I have created 5 databases in it will same tables structure. The table contains the data in same structure. Now I want to merge all the databases in one database so that I can have all the data in respective tables. … |
| | Hi, URGENT!! I need help regarding updating the datagrid. I have a datagrid with columns A , B , C , D in Page 1. Column C gets the value from a dropdown list from another page(Page 2). I need to update the column in Page1 with a value from … |
| | Hi, I require your suggestions for the database server problem that I have. We have around 4000 thousand client programs spread across globe geographically, with one site having thousand clients. The clients report data directly to db server, not using http but using (tcp/ip connections). My question is whether MS … |
| | i have my database ready... but when im using my ODBC i'm getting prompted with [SQL Native Client][Named Pipeline Provider] Could not open a connection to SQL Server [51]. Connection failed: |
| | hey, my question is, i have the visual studio and the SQL server confuration installed in my computer, i wrote a windows desktop application in C# and I am using a mdf file(microsoft SQL database file). i copied the database file which is the database file to the folder it … |
| | Hi everybody, I'm setting up peer-to-peer replication topology. Now, my two sites are working well, both sites could make changes to the common database and the common database is synchronized between the two sites. However I have a question which I still not have the answer my self. In the … |
| | Dear SQL sharks.... Please somebody help me with this struggle. I have been searching the web for hours now. I have a table with sales data. In this table i have a columne called SalesAmount, CustomerName and SalesDate(the format i smalldatetime) Now I would like to retreive all the records … |
| | helo i a have this problem in my coding plezz help me.. when i want run my sytem... i get this error..Type 'OpenDb.OpenDbMSSQL' is not defined. anyone can tell what is this?? |
| | hello i want to read 12 values (datetime data type) named s1,s2,s3,s4....,s12 from database. compare these 12 fields with current date. if difference lies between 10 days i want to show corrosponding result. please tell me code for this in c# |
| | I have table that has students classes and grades. They are allowed to fail a test twice but if they fail twice they have to retake the couse in which they have two more tries. I would like to show only the most recent grade. Here is the table structure … |
| | I have a table that looks like the one below: Name Score1 Score2 Score3 TOTAL Dan 71 85 23 ? Tom 58 84 87 ? sam 76 65 64 ? I dont know d command that will dynamically get the total score for each student and put it in the …  |
| | We need to access a MS SQL 2000 database with unicode data in nvarchar fields from PHP (on IIS). Unfortunately PHP's MSSQL does not support this. Unfortunately we cannot use a different driver (like ADODB) - we're stuck with the application (Interspire KM) and can't rewrite it. Is there anyway … |
| | I"m very new to SQL but need to insert LOT numbers to inventory. I have my table (cards) and my column (lot). The cards come in lots of 25 units. Each lot increments by 1. So rows 1-25 would have lot 0001, 26-50 would have a lot of 0002, etc. … |
| | I'm trying to connect and can. The code fails at the select database. I have created the Tools database already. The table is an exact clone of the mysql counterpart that is currently working. Any Suggestions? [CODE]<?php $dbuser="yukon"; $dbpass="yukon"; $dbname="Tools"; //the name of the database $chandle = odbc_connect("sqlserver", $dbuser, $dbpass) … |
| | userid | personID | positionID 712 | 912 | 8 713 | 814 | 15 516 | 811 | 9 712 | 912 | 9 713 | 814 | 15 from the above table i have to find out userID of the person who has different multiple postion. i.e my …  |
| | I have an error I don't understand how to get rid of. I want to compare a string consisting of: ID + " " + date + " " + time + ":00" to a string in the database (data type = text). Here's an example of what I fetch … |
| | I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at [URL="http://rapidshare.com/files/412276985/SQL_query.zip"]http://rapidshare.com/files/412276985/SQL_query.zip[/URL] Or, from [email removed] Thanks for your guidance, below are the query: 1) MS Office Query: ================ [CODE]select v_Add_Remove_Programs.DisplayName0 … |
| | Hi I am new to this SQL and I using access to build the below statement. Below is a working SQl statement but I need to output DISTINCT records. How do I compose this syntax inorder to display DISTINCT record using this {SR.No#] field ----------------------------------------------------------------------------------------- SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem … |
| | Hi all, I'm using ASP.NET programming with SQL Express 2008: Basically to simplify and summarise, I have Users who can message to each other: Users table: UserID (PK); UserName Messages table: MessageID (PK); UserIDSender; UserIDRecipient I want to Select * from Messages table and also the UserName for the UserIDSender …  |
| | Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14) in \usr\local\htdocs\connect.php on line 5 [B] We are using the following code for connectivity[/B] mssql_connect('servername,port', 'username', 'password'); mssql_select_db("dbname"); |
| | I have a few tables on my dev computer that I would like to roll out into productions. Is there an easy way to convert the table to sql syntax? Ideally, I would like to end up with a file with all the commands to create the table and the …  |
| | Hallo dont now if its right forum and excusse for bad english. I hawe a site on one.com and tried to restore my sql data base. i hade a backup, before i restored it i dropped all the thables to read in the new wone. buth it dosent work it … |
| | I have two tables tbl_1_id_pk tbl_1_diska_fk (relationship) ---> tbl_2_id_pk tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk and tbl_2_id_pk tbl_2_name When I create views/queries for the name for each disk, it returns nothing. Why? |
| | hello people, when i run this below written query then i get error as "ORDER BY clause is invalid in views,inline functions,derived tables, subqueries and common table expression unless TOP or for Xml is also specified". i want to have the top 5 result based on the Gross_written_premium . can … |
The End.