[microsoft:sql-server] Forum Topics

Hello people, I need your advice, what to do. I use LINQ stored procedure to select all data from sql table to DataGridView: EtiketyLINQDataContext EtiketyData = new EtiketyLINQDataContext(); IEnumerable VypisDat = EtiketyData.Vypis("Cislo", "Typ", "Hrubka", "MaterialTyp"); LINQdataGridView.DataSource = VypisDat; The problem occurs with this line: `IEnumerable VypisDat = EtiketyData.Vypis("Cislo", "Typ", "Hrubka", …

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" …

Hello everyone, I am working on a web using ASP.Net (VB) and Sybase as its back end. I am trying to display data from database to the textbox. Does anyone know, pls help. Here's my code and its not working. pls. pls help. thanks a lot Try conn.Open() cmd = …

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 am a newbie in vb 2005 and i would like to ask for help regarding this problem that i encounter. i have no idea how to fill up my combobox or listbox using dataset. i am accessing data from sql 2000. please help...

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

I have an existing connection string in my web.config file. I just added some code from another web developer into my website. Along with that I added a new ObjectDataSource control and configured it to look for the existing ConectionString which IS NOT an OleDbConnection, by using the following code. …

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 …

--URGENT-- 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 …

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 …

Dear friends, thanks in advance for reading this: I wanted to set up membership roles for my application. I am using Visual Studio 2005 Web Development. However, I could not enter into the security tab under ASP.NET Web Site Administration Tool(In a web interface look)... they threw me this: There …

Hi All, I have a datagrid that that get populated from a SQL store procedure and I need to hide the row(s) that are blank. Any idea how I can force the datagrid not to show blank row(s)? Thanks Doc Holiday

Hi, this is my first job in UK, so need bit of help. The problem goes like this. I have an existing SQL database where there are 2 user tables. One contains only field.U_Id(int) not null and other is user_details table where there are fields like user_id(int), username and so …

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 …

i relly need help in connectin my visual basic 6.0 with sql server 2000.... thouhg I'm ok with acess

hi guys, i have recently uploaded my project in school website, in a free host site. but unfortunately, i encountered this error, check this out: [COLOR="Red"]Server Error in '/projecty3' Application.[/COLOR] User does not have permission to perform this action. Description: An unhandled exception occurred during the execution of the current …

Hi guys, first of all i would ask all the engineers out there, i really really need this favour. I am building an online shop (DVD's), i have with me the basic page "movies.aspx" which displays the movies in a table with a thumbnail and a small description . there …

Hello this is it: I have a desktop app using WinForms and the user have an option in which he/she can enter a query to a database (TRANSACT-SQL, PLSQL). I need to validate that input, but the user would have to struggle with typos and remember exactly every database detail. …

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 …

I'm trying to determine why I receive this error message when attempting to update the database.."Syntax error in UPDATE statement", please assist! Thanks! [code=vbnet] Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim SQLStmt As String Dim UpdateOK As Integer If txtFirstName.Text = "" And txtLastName.Text …

[code] order table orderid orderdate cust_name address itemno itemname qty price totalprice 54 12/09/2008 xxx yyy 5 cake 5 5 25 54 12/09/2008 xxx yyy 3 choclate 5 3 15 55 13/09/2008 www uuu 7 rice 6 6 36 55 13/09/2008 www uuu 8 biscut 1 10 10 55 13/09/2008 …

Hi, I need to develop a windows application using c# 2.0. It is basically a data entry application which should involve a three layer architecture. The application has two fields namely Empname, and Empage where the datatypes are varchar(20) and int respectively from a sql server 2005 table. The user …

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 …

Please help me with my project When the form loads it will connect to serial com and retrieve the number of chinups from a PLC and store it a variable called 'int' there is a textbox in the form called 'txtname' and a button called 'ok' My question is when …

Hi, People can you please help me on how to start the connections using SQL Server and C#.NET. I have the following tools in my PC but I don't know how to start,from the very beginning. Can you please send me a link on how to start. Badly needed. Your …

Hi people, Please do help me on how to start the connection with SQL Server and C#.NET. If you have links or tutorials, can you please share??? Thanks a lot guys.

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 …

[CODE] Imports System.Data.OleDb Module Module1 Sub Main() Dim Cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\mibase.mdb;Persist Security Info=False") Cn.Open() Dim comando As OleDbCommand comando = New OleDbCommand() comando.CommandText = String.Format("SELECT Telefono FROM empleados ") comando.Connection = Cn Dim lector As OleDbDataReader lector = comando.ExecuteReader Do While lector.Read Console.WriteLine(lector("Telefono")) Loop Dim nombres As New …

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 …

Emp ----- ID Name 1 x 1 P 2 y 2 Q 3 W Emp_Data Id Name-1 Name-2 1 x P 2 y Q 3 w above is my tables (Emp ),And the I want the Resulting Data in the (Emp_Data) format.is this possible Pls Help........Thanks in advance-----

Hi, I've got a major headache with a SQL Union statement. Basically I'm running a SQL Union statement in ASP that is not returning the first few unions. But if I run the SQL in enterprise manager it runs fine. I can't find anything on the web that even remotely …

Hi, I am trying create a query that counts all records which have the field Hypotension=1 (which is Yes), but I only want to count the same customer once. For example: My table has 3 fields: RecID (primary key), MRN, and Hypotension RecID Cus# Hypotension 1 6 1 2 6 …

I am trying to work on VIEW command of SQL. Whenever I write the SQL as [code=sql]CREATE VIEW PartOrder AS SELECT PartNum, NumOrdered, price FROM part;[/code] I get an error message "Syntax error in CREATE TABLE". I dont have any problems in writing SQL commands but whenever I mention CREATE …

Does SQL support ASCII data type?Or we need to do some type casting for it.?

Hi, I have a table with columns like cats,dogs,birds and totalanimal. It is mainly a database which maintains how many cats,dogs and birds a person has... what i need is , get the sum of these columns(cats,dogs,birds) and keep the total in totalanimal column... how do i do this ??

how to transfer a database from ms access to ms sql 2005 through a button clik event in c#