[mssql] Forum Topics

Hi Forum, I need a funtion to retrieve data from more then one Table. The tables are not related.Field names are the same in all tables. The table list I get from a view and i need to go through this list and pull out any records from the different …

I'm newbie in MSSQL, I would like to ask what web server should i use? Should i install IIS in my PC? I appreciate your suggestions... Thanks.. Mar....

Hi, Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve. Eg: field #1 field …

hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), …

Can Any one Explain me about Isolation level in mssql server

well i was looking at some videos online and was prompted to update my realplayer and it failed, since then i haven't been able to open any explorer window. I have run adaware, spybot, striker, and norton full system scan. I can't figure it out and i know alot of …

Hi All, I have a query that returns rows from a message table. Im basically trying to get the latest MESSAGE_TYPE for the user based on when the message was sent (MESSAGEDATE) At the moment I have a query that gets me almost what I want. It returns something like …

In my-sql i used a variable c and in a situation i used like c-- to decrement the value of c but while executing i came to know that remaining code in the line get commented, how can i avoid that without using c=c-1;

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 …

I am usins SQL server I need to fire a trigger when an appointment for the same date comes.It should not allow more than one appointment for a hall booking system,how can i do that? iam using a table called appointment and the logic i used is take the date …

[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, i want select all values from tables, this code i have, desplay warning! I do not know why. can you guys help me!! [B]!Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the nvarchar value '1t38123' to data type int. (severity 16) in C:\xampp\htdocs\SGFT\Dados.php on line 18[/B] [CODE]$fotog = "SELECT …

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 …

I am working on a software project that utilizes the MSSQL Express version. My question is... I have checked out software that does the same thing that I want to do, but it seems that the competition uses a file based database system. I intend to use SQL because it …

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 …

Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like …

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 …

I have no idea whats wrong with my computer... My RAM is through the roof and for seemingly no reason... This is a problem that I have had many times and each time its taken a different solution to fix. (the last two times its been the svchost and IE) …

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 apologize if this is a double-post, as the first time I tried to post to this board, I got a 404 browser error. 2 weeks ago, I had an issue with pop-ups on my work PC. I was eventually able to clean it up with Malawarebytes and thought I …

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 …

hi, i am doing a project in attendance system in vb.net, i don't know how to maintain back end process ,i am using sql 2005 ie database and tables for different department... pls help me

Hi all, I am having a bit of a problem with implementing a nested statement that will update based on conditions. I know the logic behind it, but do not know how to implement it with nested queries. Please see below the pseudo code I've written along with an example …

I'm using the HR@orcl learning account from oracle. ----------------------------------------------------- and I have the following question : Create a an SQL query to display the department, the number of employees for that department based on their salary, and the total number of employees for that department, giving each column an appropriate …

If I want to select the max value of 1 record, but there are two columns that having the same max values? How can I select both of them?

HI, I have a requirement where I need to compare the data in different database(tables having same structure/schema). I know manually I can execute the queries in each database, compare the results and it is done. As this execution is repetitive in nature, how I can automate this. Thanks In …

Hi there, I have a project created in C# visual studio 2008 standard edition and I am using a Microsoft SQl database file. I took my solution project in a filer and tried to run the application, going to the project folder and to the bin folder -> Debug folder …

Hey using the following sql [code] SELECT DB_SALGSPRIS from pris_interval WHERE DB_INTERVAL_START < '11.78' AND DB_INTERVAL_END >= '11.78' SELECT DB_CUSTOMER from pris_interval WHERE AND DB_INTERVAL_START < '7.19'AND DB_INTERVAL_END >= '7.19' [/code] I get multiple results, 3 from first, and 2 from the second to be precise, what I am wondering …