2,935 Topics
 | |
| | Hi everyone, I'm trying to write a stored procedure select statement which is a little beyond my experience level. I have a table in the DB called addresses which contains the following fields: [LIST] [*]address, VARCHAR [*]count, INT [*](a few more fields) [/LIST] My stored procedure will take in a … |
| | Hi all I am pretty new to MSSQL and have a problem. The solution is probably very simple but I cant find it :) I have a database field ZIP, I also have string with consists of a number of UK part postcodes eg 'S10 S11 S7 S17 S8 S3 … |
| | HAI, I'm creating a website for a computer forum (using VBScript, SQL server - back end). Im able to display the heading of the threads in a page & also im able to click and redirect to a proper .asp page but, can u tell me how can i show … |
| | I have an external application running on a MS SQL server2005 (express-edition) database. I need a notification each time the application reads a special table from the database. As a new user of MsSQL I experienced with the trigger function. But this is only applicable when fields in a table … |
| | Hello, I am trying to figure out how best to merge these two queries together: #1 - this is pretty basic: [code=sql] SELECT DISTINCT [vtebase].[EbLastName], [vtebase].[EbFirstName], [vtecomp].[EmAnnual], Str(vtecomp.[EmAnnual] * 1.03,9,2) AS [3% Increase], Str(vtecomp.[EmAnnual] * 1.05,9,2) AS [5% Increase], Str(vtecomp.[EmAnnual] * 1.07,9,2) AS [7% Increase], [vtEqbase].[EqDateNext] AS [Next Review Date], … |
| | hi, i hav some problem involving checkboxes 1.how do i submit the values into the database 2.i dont know how to connect with the db below is the sample of my codings p/s;the values of the checkbox will have calculation in the db,can i relate two tables? [code=html] <td><input type="checkbox" …  |
| | I just started learning php and mySQL, if i want to create 2 tables, how do i connect them with a foreign key? In oracle, it is something like below, would any one point out what have to change to make it work in mySQL? phpMyadmin GUI doesn't seem like … |
| | Hi, Unable to connect to MSSQL through PHP+ADODB+APache in my laptop. While the same is running fine in the server. Checked the SQL it is running fine. Can anybody help me? |
| | I need help with a left outer join on a table and some queries (is it possible to outer join with queries?) here's my SQL right now [CODE]SELECT Clients.ClientID, Clients.SSN, Clients.WholeName, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, DPs.SumOfAmount AS [Client Down Payments_SumOfAmount], Remain.SumOfAmount AS [Client Remaining_SumOfAmount], [MF PTD].SumOfAmount … |
| | Hello, I've been given the task of transferring a website from one server to another. Unfortunately the website was written in asp and is linked to a MS SQL database and I haven't had much experience with either. It was using a MS SQL 2000 database but the new host … |
| | Hi I have a database running on MSSQL server 2005. Now I want to move all my data in MySQL server 5. I am familiar with MySQL and PhpMyAdmin. Please help me what is the best way to do this. Thanks |
| | hi, iam having three tables as shown below table 1 table 2 table 3 column1 id column1 cust_id column1 cat_id column2 cust_name column2 cat_id column2 cat_name column3 cust_id column3 training column4 posted_date iam using the following query Select A.id,A.cust_name,B.training from table1 A,table2 B,table3 C WHERE A.ID = B.cust_id AND B.cat_id … |
| | Why is the result of this query.. [code=mssql] SELECT * FROM (SELECT TOP 5 * FROM (SELECT TOP 20 * FROM ODPSEnrlAccts ORDER BY fld_acctname) AS foo ORDER BY fld_acctname DESC) as bar ORDER BY fld_acctname DESC [/code] Is the same as the result of this one.. [code=mssql] SELECT TOP … |
| | I need to write a stored procedure to analyse appointments for the last 12 months. I need to get each salesperson (by ID) and for each person carry out a count of the number of appointments and count them by outcome (sale, second meeting , failure etc.) and then display … |
| | [INDENT][INDENT]--URGENT--[/INDENT][/INDENT] Ive written a code in VBScript in ASP where back end is SQL. Here I want to display all the records with the data of the selected field of the table "Users" but it displays only the first record repetitively for the total number of records in the table … |
| | Below query for comparing 2 tables and extract the uncommon like GUID X121 doesn’t exists in the 2nd table and the GUID which are unsuccessful (has –ve values). select isnull(pt.GUID,Wo.GUIS)as GUID, pt.[ErrorNo] as Error from PieTreace pt full outer join WorkMessage Wm on pt.GUID = Wm.GUID where(pt.GUId is null) or … |
| | Say we have a table with 1000 rows and there is no column which can identify a row(i mean no Identity or unique column) now if we want to select a set of rows from this table how can we do that? Ex: i want to select from rows 201 … |
| | Hi all, Short history - C programmer whose day job is working on AS400's over VPN. Now getting into C# and chose VS 2008 using ASP 2.0 MSSQL for web development on IXWebhosting They don't have 3.5 yet, so I believe I have to use MS SQL 2005, but I … |
| | [code] hai friend's i have 1000 and more question's in database ,now i want to select the question's by the amount of 10 at a time ,when i click the next button the another 10 question's are want to show , now the selected questions from database should be in … |
| | Hi all, I hope someone can help me with this. I have been racking my poor stupid brain for days over this. I need a way to be able to create a view of the data in a single table. Let's call it tblStatus. Here is a list of fields … |
| | I have a huge database with around 250 tables. But all the tables are the same ie. they all have all the same columns. These are survery forms from different stores and thats why they all have the same schema. When i converted all these files from excel sheets into … |
| | how is maintence plan in sql server 2005?ebook for maintenceplan in sql2005? tanks |
| | Hi, My server machine is running on Windows XP and running MSSQL. I have another client machine which also installed on Windows 2000 and since i cannot install the whole MSSQL, I installed the Client Tools only. After installing,through my query analyser in client machine i can query the tables … |
| | I am joining a select statement and a subquery with a left outer join. The subquery does a an average on one of the selects columns grouped by name, and I only select this sum value in the resultant joined result set. Typically there will the select result set will … |
| | I have a very large with milions of rows: I will attempts to create a reduced SSCCE to explain my problem. The below applies for multiple locations, and I will attempt to describe my problem assuming one location. The metric are also foreign keys so to get the real value … |
| | Is this posible: I am working in SQL 2000, using MS Access 03 as the front end. I have a table 'Mileage' that has the following fields, ID, Vehicle_ID, Current_Mileage, Date Checked, Last_Current_Mileage and Mileage_3000. I am trying to find out if it is posible to create a trigger so … |
| | i want to connect mssql(microsoft sql server 2005), when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect server which is in another system connected through LAN. if i connect the sqlserver 2005, is …  |
| | i want to connect mssql(microsoft sql server 2005) using php, when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect another db which is in another system connected through LAN. if i connect the … |
| | Hi I want to execute below query in ms-sql server 2000 but its giving errors. Can anybody help please. [CODE]select * from ( select vRefTable from mainmenu where iMenuId=58 ) where (select vFieldsName from TableField where iMenuId=58 and bIsPrimary=1 and iTableFieldId=11) = 1[/CODE] Its showing below errors. your help is … |
| | Hi all, I need to sort users by matching preferences, and because of the high count of rows I need to do that in the data store, not in the business logic layer. Imagine I have a table like USER-PREFERENCE 1-A 1-B 1-C 2-A 2-C 3-B 3-C 3-D 4-C 4-E … |
The End.