[microsoft:sql-server] Forum Topics

Hello, I am working on a C# application where i have to store values of article in sql server as i have 3 products (stone, diamonds, jewellery). Now during the initial process when i enter the product details let say i have to store value for a diamonds i put …

Dear All, I am beginners in MS Sql, now I have three tables (Companies, Product, SaleBody). and their fields are (CompanyId, CompanyName), (ProductId, ProductName, CompanyId, PurchaseSTPrice, TradePrice), (SerialNo, SaleId, ProductId, Quantity, Price, TotalPrice).............. I want to create Report in which I want (companies.CompanyName, product.ProductName, product.TradePrice, salbody.TotalPrice) How can I get …

For a lack of words, I'm confused with my server at the moment. I moved an old site on ASP/Access over to ASP/SQL Server 2008 Express, and now some data appears, while other data does not. This one is an odd ball to me. I have data cells of the …

Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks.

Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, …

1. How to create effective ajax table in asp.net 2. Having problem in adding data from dropdown list and saving it in sql server (a). In my .aspx web page i have First Name Last Name Gender Email (b) Gender is taken by dropdown list (c) When you run the …

hello! i am working on a client and server application , i want to connect my server with my client application to perform some database transactions.i think it is very simple to connect a client with the server , but here is the point , i have two pc , …

I wana know how can i use a value from a sql table that i added from another form? It basically supposed to validate that whatever was the last recorded added in the other form(eg formA) , i must then use those same values from the sql , into another …

Trying to find a way as to how can i display a message box to say stock not available when i link it to my database to show that the quantity_available of the album( typed in and is refered to by the album_id in the textbox) ? here is my …

Hi all, Have a nice day.. I want to know that way to backup our SQL data from server. Any suggestion for me?

I am Sameer Shah. I am a young coder born and educated in Mumbai, India and now working in New York, US. Coding has been my passion since I was 14. I like coding in C#,C++,C. At my workplace, I develop applications software much of it using MICROSOFT.NET C# and …

Guys, I have a select statement ere one of the field has a negative value. How do i convert it into zero in select statement. ;with CTE as ( Select Itemid ,AVAILORDERED as OnHandQty - just want to convert some negative result into 0 From MyTable ) Select * from …

Hi everyone. I am making an application that you need to sign up and login to. I want to use an online SQL database to store the login information. I know how to use a local SQL database, but I want to use an online database. Please help :) BTW, …

hello, I'm creating e-menu system for a restuarent... It has 3 users... and in staff user i want , when the staff see orders of the custmer from StoreOrders1 table which will be displayed in DataGrideView ... i want a botton to move the records of StoreOrders1 to ReceiveOrder table.. …

Hello everyone! I am trying create some table for ticket escalations.Escalation have more than 5 levels.. There is two table example: table_escalation id serviceId ownerId table_level id escalationId levelId currentUserId userLevelId I need advice: if this good structure.

hi, how to create nested table in sql server for example employee table contains 3 column id name address where name should contain 3 sub columns like firstname middlename lastname how can i get this one help me plz

Could you guys show me how to create a progess bar which discribes the process of a SQL procedure?

Guys, I tried to reply but i got an error. ERROR MESSAGE: The Message field is required.

I been working on this login page for months, and to no avail can have the program working. I am using the MSAccess Database and using VB.Net. This is a windows application creating a login page. The following is the code that I been working on: Dim mypath = Application.StartupPath …

Hi Forumer's I’m currently having 3 reports (Detail, summary per etamonth and summary per sku). Those 3 results is derived in 1 query ( see my query using CTE) into a single report. so when generate it ito SSRS and export to excel i would like to send it into …

hi every 1/ . i am having problem in sql query. if i double click on the dataset. i am not sure which statement to write to restrict the user so that he/she cannot enter the date in the past. i have droped the data set on the form and …

I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,Timeout I want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them. here is my code so far, but it aint working Public …

Please I am currently working on a web application project that works on both the desktop and mobile devices also. The web application is to be for all and sundry and therefore I need it to work on all forms of mobile devices (old and new). The web application uses …

i want a code for registration form in vb.net and my project name is book bank system can anyone please post the snippet for me am using sqlserver2005 as backend

**How to Table Create in SQL Server 2000 Edition by OS: Windows 7** ============================================================ (1) Run Enterprise Manager as administrator preveliage. (2) Navigate (select) to a DataBase that you are working on. (3) Right click on any table in right side that already created in the system by default (Not …

I need some help updating data in my table based on data in the supply chain group's table This is how the table looks on their side ##Table Name: ProductSC## ID Code Description Status 1 N461579 Phone Available 2 N836257 Headset1 Discontinued 3 N836258 Headset2 Available 4 N748956 Adapter Available …

It just occured to me that when I go to create a new SQL query using VS's query builder, it pre-fills in a query based on the datatable I am building the query with. Normally I just delete the standard query (unless it's sufficient) and write my own, but this …

I have an application that is writen in PHP and connects to a MS SQL Server 2008 Database. I'm using ADO recordsets. There are cases where specific IDs and years in the table returns nothing. How do I test for when there are no results? I searched and most of …

I am trying to learn how to make a mobile phone communicate with a server and a database. So far, I have made a web-service on my PC using this tutorial: http://msdn.microsoft.com/en-us/library/ms733069.aspx The above tutorial makes a sortof WCF service. What would be the best Database system for me? Simplicity …

`Inline Code Example Here` con.Open() cmd.Connection = con cmd.CommandText = "SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By MONTH(SalesDate), Detail.ProductID" Dim da As New SqlDataAdapter("SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By …

I am newbie in sql server i'm using sql server 2005 and the northwind database i wanted to join order and order details tables and calculate the total purchase made by each customer by using group by clause. When i used select orders.orderid,orders.customerid,orders.orderdate,orders.shipcity,orders.shipcountry, orderdetails.unitprice,orderdetails.quantity,(orderdetails.unitprice*orderdetails.quantity )as total from orders inner join …

I have a csv upload utility for my company. When user run the application in the drop down user get the table name in which insert the data (data from file browse) when table column type is date it gives error "source type of string cannot be cannot to destination …

I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- `select * from Asset where contains(AssetDescription,'flower')` It returns nothing. …

Hi All, I need to show a map, plotting addresses that are held on a sql database. Has any one come across any software suitable for this task (i.e. can be built into vb.net). I have tried using MS MapPoint, which according to the write up says it will do …

hello ! how are you all , hope all of you are in great state of health and peace , well i have some questions , 1- WHAT IS MSSQL TRANSACTIONS . 2- where we use it. 3- Advantages /Disadvantages 4- Any imp information or point which you think it …

I write as one just starting to learn to use Visual Studio 2008. Is there a version of SQL server built into Visual Studio 2008 Team Suite? I have heard of SQL Lite but do not know if a database app already exists within Visual Studio. Seeking guidance on how …

what are requirements for sql server 2005 installation? how to connect it with netbeans> can we make no. of instances?how and why?

Hi, Am having, some doubt, please clarify this? [CODE] 1. Using Import/Export wizard, can i able to import the excel data into the temporary table ? How ?[/CODE] 2. The following TSQL is working fine. Can i able to do this, from the CLIENT Machine itself. I don't want to …

I am trying to save my scale configurations in the database so first I have to check if it exists in the database.and I am using the code below to do that . however when there is no data in the database I will get an error "No row at …

Currently i am working and using a filter function for my search however i not sure how to do it using a query the sql statement is [CODE]cmd.CommandText = select * from tblcustomer where customerName like "'& textbox1.text &'"[/CODE] I no there is some bits missing but i am not …

Hey i am just a little confused. I am creating a system where customers order items and i have just realized that i cannot add more than one item per order how do i get around this i am using sql and vb thanks

Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select …

Hi every one. I need help with regards to application distribution. The application i have made is in vb.net with sql server as database. I have 2 laptops . i want to install the application on both computer So that one computer will be for administrator and other for employee. …

Hi, Trying this Query, [CODE][B]DECLARE @SR VARCHAR(8),@SC CHAR(15),@ST CHAR(15),@SNO int; SELECT * FROM (SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY a.rno) AS rowid, @SR=a.rno,@SC=a.kat, @ST=a.type FROM SMas a, SDet b WHERE b.id='X' AND a.rno=b.rno) AS C WHERE C.rowid=4 [/B][/CODE] but getting this following error: [CODE][B][I][U]Msg 102, Level 15, State 1, Line …

Hi, I am trying to create a stored procedure to add a new column into a database from an ASP web application. The SQL Code for this is:- [code] ALTER TABLE tablename ADD COLUMN columnname columndatatype [/code] I have tried to insert this SQL into a stored procedure:- [code] CREATE …

Hi I am working on a project in c# where a part of my application should allow user to generate schedules for courses for this there will be a table named "session" in database which will store all the information of the schedule which has been created by the user …

Any tips on how to connect them? COmments are highly appreciated. Thanks!

Hi everyone, i am new in this Forum. I am from Greece so I'm sorry for my bad English. I must create an "e-shop" website with [B]Microsoft visual web developer 2010[/B] and [B]sql server 2008[/B]. I have done the database with sql, and the next step is make the website. …

Hello please can anyone help me with microsoft access. I work as a software support consultant for a medical software company and we have an sql server database with all the bugs etc but the website is awful. I have made myself a small access database with bugs that i …

good day. i have a problem with my login from. i have my table under SQL server 2008. which is tbl_user,with a field of userid,username,password and category i created a simple login form but that's fine and working as a simple login.. my problem is that i want to add …