[microsoft:sql-server] Forum Topics

Hi, Is there a way to do a mail merge (data coming from sql server) from a web form? I've looked into Word Automation, but for this you need Office installed on the server, and even then the mailmerge might just open on the server. I've also tried looking into …

I wanted to create a form where a user can create an account, have it loaded in SQL, and be able to retrieve the information and validate it. I've reached a mental block on the validation code and need some advice. Here is my code so far: [code]Public Class main …

Hello everyone, How can I convert this format using Java? 2009-05-20T18:19:23+08:00 I was able to convert this using the SQL Statement below. select cast('' as xml).value('xs:dateTime('2009-05-20T18:19:23+08:00')', 'datetime'); I would like to know how Java handle this format. Any suggestions are greatly appreciated. Thanks in advance, Jamojo

Hi everyone! I work for a public university and need to create a new forum. Never done this before and was hoping you experts out there could give me some advice. We have our own website, servers, etc... so that isn't an issue. Our online community will include university employees …

Hi! all Let me explain the problem:- I have two tables A(aid,aname,adesc),B(bid,aid,bdesc). I want a query which will extract all records of 'aid' in 'B'. means aid bid aname bdesc 1 1 qw eeg 2 null re null 3 4 sd v tyuy 4 null dffg null Hope to get …

I have a couple of queries in a union all that need to get all records, some from the first where clause, and everything else in the other. Here is the original where clause: [code=sql]from license_status ls, pos_driver pd, pos_policy pp where pp.pos_id = @pos_id and pd.pos_id = pp.pos_id and …

Hi all, I’m trying to re-write a solution from Ms. Access to VB.Net Previously I had a number of queries that filtered records depending on what value of a filed on my main menu, if the filter was empty (Null) than all records were returned. Here’s the criteria part of …

It is an asp.net web application with following specifications: Wndows Xp o/s, IIS 5.1, asp.net frame work is 1.1, VB is server side script, SQL Server 2000 Enterprise edition. An asp.net datagrid control is dynamicaly populated with sql server 2K database table data by VB Script. The page numbers are …

I'm trying to calculate a column from a database called rogaine.mdb. I've been using an SQL statement to do this as I only want to calculate the points for certain teams. This is the code I've been using: Dim teams As DataTable Dim da As OleDb.OleDbDataAdapter Dim sql, connStr, teamName …

Hi, How can I delete duplicate records from a table in a single query. Thanks in advance.

Hi, When I use sql server native client for odbc sql connection then it is asking uid and password, once I supply uid and pwd in odbc connection , I think there should not be necessary to give uid and password in C# in sql connection string. I want once …

Hi all, Apologies to be a pain but I'm relativeley new to .net programming and I need a little assistance please. I have created a login and registration pages using the control for .net 2.0 and tested locally I can add users and login to the site. However, once published …

Hi, I would like to know whether the Data parsing can be done by perl scripting by checking the specified the webpage and fetch the data from the page and load the same i nto the sql server table. In the sql server table, it checks for a value called …

Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query". I …

Hi all! I am new to delphi programing ive started with delphi 8. My simple application needed to connect to sql server with borland data provider components like BdpConnection and BdpDataAdapter and i was able to connect to server manipulate with data, sqls everything is working fine but when i …

i'm using sql server 2005 for my asp.net program. i have 2 tables, first table X, second table Y X has column: [code]DEM_ID int DEM_DATE datetime DEM_QTY numeric(18,0) constraint PK_DEMAND primary key nonclustered (DEM_ID)[/code] Y has column: [code]FRC_ID int FRC_YEAR numeric(4) FRC_MON numeric(2) FRC_SALES numeric(18,0) FRC_FRCSALES numeric(18,0) FRC_FRCLOG numeric(18,0) constraint …

Hi, I have almost finished working on a small application using VB.NET 2008 Express Edition as front end and SQL Server Express as back end. Now my next step is to generate reports for the application. Is there ANY way I could create reports in VB.NET Express Edition? Please help. …

I have a dynamic query: ID Name Num ------------ 22 A 2 22 B 3 23 C 1 23 D 2 23 E 2 How to create a dynamic query to calculate the total like below? ID Name Num Total ----------------- 22 A 2 7 <=> (2*2)+3 22 B 3 …

Can someone please help. I have a dataset that is populated with a csv or a tab seperated txt. I get the datset fine but when I try to insert into a table in sql with bulkinsert I am getting an exception. The table does not allow nulls in the …

Hello, I am doing Login Screen in VS2008. When i logon with username and password in form it only checking the first field in database. How to do coding for checking all the fields??? This is my coding [CODE] Imports System.Data.OleDb Public Class frmLogin Private connstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data …

I'm just starting to get into some Service programming (WCF). I've successfully tried out the Microsoft WCF tutorial and got mathematical results from the service. Now I'm trying to set up a SQL Server Express database on the Service side so that it can allow the client to either retrieve …

How to re-write this self-join queries by using the sub-query Structure (without using the CONNECT BY clause)? [code=sql]SELECT f1.child as parent, f2.child FROM FamilyTree f1, FamilyTree f2 WHERE f1.child = f2.parent[/code] [code=sql]SELECT f1.child as grandparent, f3.child as grandchild FROM FamilyTree f1, FamilyTree f2, FamilyTree f3 WHERE f1.child = f2.parent AND …

Hi all, i have a table, it will store millions of rows, corresponding to raw byte sequences from many sources. I´m thinking on using for primary key two options: 1- Columns: (source_id, date, data) and PK = (source_id, date) 2- Columns: (id, date, data) and PK = (id) The sources …

First I created a Login to SQL Server using a T-SQL command from within C#. This is the query I used. [code] CREATE LOGIN NT AUTHORITY\NETWORK SERVICE FROM WINDOWS WITH DEFAULT_DATABASE="MyDB"; [/code] Here, NT AUTHORITY\NETWORK SERVICE is the name of the Login I created and MyDB is the DataBase I …

Hi, Can anyone tell me how can we know if any updation is done in table such as insertion | Deletion | Modification of record in one or more table without peeping inside the table... say, finding the history records that are updated... To be more clear; say I have …

Hello i have some issues in how to display data in specific format (i am using SQL server 2008 & visual web developer 2008 C#) - how to display the data input as percentage like this 3% - i have field which the input should be more than zero (how …

Dear all, How do I change primary key field from query because if I use VS Designer, raised an error about [B]time expired[/B] ? I want to extend my FK field length. Thanks

hello all.... i created a asp.net application with the aspnet database on my pc...now that it is time to publish my application i copied my database with all the stored procedures and tables to a sql server 2000 server that is supposed to hold the database....then i changed the membership …

Hi, Im new here, im sorry if i am posting in a wrong forum, i have a piece of code that update a binary field in sql server 2000, im keeping this code a simple as possible, so this is working but only save the first character in the string …

hi, i would like to make an insert statement with a subquery, i know that it is possible with a following select command, but i would like to combine it with scalar vars from a data grid ? please help: [code] INSERT INTO akquise_dispo_stunden(sb_id,akquiseprojekt_id,monat,jahr,ma_name,stunden)VALUES(@sb_id,'test',1,@jahr,([B]SELECT name FROM ma WHERE user_id=@sb_id[/B]),@JanStd); [/code] …

Hi all Im trying to insert an SQLDateTime into an SQL database column which takes DateTime here is an extract of my code [CODE]sTime = new SqlDateTime(DateTime.Now); command.CommandText = "INSERT INTO Sensors VALUES ('" + sensors[i].getName() + "','" + sensors[i].getType() + "'," + sensors[i].getVal() + ", " + sTime.Value + …

I want to run a Transact SQL statement from within C# in order to create a login to SQL Server. It is important that I do it inside the code, without executing a .sql file from outside the program. How do I do that? Following is the T-SQL statement I …

I initially developed my app with vs2003, using sqlDataAdapters and datasets. Now I need to add additional fields, etc. I'd like to use the Data Adapter Configuration Wizard, and have found instructions for 2005 to select the component in design mode, and pull up the wizard using the context menu. …

have two listboxes. first one of these is multiselect. what i want is after i choose one or more item from the first listbox the other listbox should be populated by an sql query. what i mean is i will use the first listbox's items in sql and populate the …

Hi i am making a intranet website and i want to insert update and search data from usin sql connection.I want to insert data from giving textboxes and when click on update button textbox shows and when click on update button it will update in database and when i delete …

Good Morning All I have a table named “Final” with Values like this [code] ID || DESCR || CYCLE ====================================== 1 || Earl G || 20 2 || Earl G || 21 3 || Earl G || 22 4 || Davidson I Dr || 20 5 || Davidson I Dr …

when we for trigger in c# .net ..can anyone expalin me with simple example

I've been working on a project lately but it has been unsuccessful. I would like to build a Windows Application Form program that can interact with a SQL table. When program runs, user has to fill some gaps as follows: Exam type: Exam number: Theme: No. of students: No. of …

I am developing a railway reservation system, i am having one issue which i hope could be solved here, my query as below works like this : there are 2 train; train1 which goes from station 1 to 5 and train2 which goes from station 5 to 10, now when …

I am using SQL Server 2005 express. I want to insert a record into a table and return its primary key. Here is my SQL Procedure: [code=sql] ALTER PROCEDURE InitialiseHistory AS INSERT INTO StatusHistory (StatusCode, DateChanged, Comments) VALUES (0, { fn NOW() }, 'Status initialised to UNKNOWN') RETURN SCOPE_IDENTITY() [/code] …

Having problems building a select list with an aggregate and Group by Clause Using VWD and mssql server express 2008 Below I have listed two conditions one that works and one that does not. I have named them example 1 and 2 Example 1: A working Select List ----------------------------------------------------------------------------------------------------- Example …

Hello everybody! I have such problem: I'm going to make a little application, which will interact with MSSQL databse, located on remote server. Server is my and I can administrate it remotely. There is MSSQL 2005 there. I created a database there, but can not connect using code from my …

In The Name Of God Hello All i will connect to my table in sql server 2008 but display this message to me. [url]http://www.uploadgeek.com/share-10D4_49F1AEF5.html[/url]. can anyone tell me how can solve this prfoblem? thanks alot. goodbye.

I have simple question. How to list Max people with tie. select student.stdname from student, class where (select max(class.awrd) from class) = class.stdnumb and class.stdnumb = student.stdnumb; Apparently, student table have tie for student total awards they received. If I run above query it will list only one Max awarded …

Hello! I have a DB setup which simplified looks like this: PRODUCT(id, owner_id) OWNER(id) What I want to do is to produce a list of how many products each owner has, and then sort it in some way, all in a single query. How do I go about this? Thanks!

well tried readin many tut's about how to go about doing this but they seem to confuse me :S there seems to be many ways. i understand the concepts of what is required, but jus cant implement it into code [url]http://www.programmersheaven.com/mb/VBNET/389030/389030/database-search-/?S=B20000[/url] So im trying to display results from a form …

I have an Access 2003 database to track employee call-outs. I have to run the report for the current day and for the last 7 days. I only want to show the employees who have call-out more than 1 time in this seven day period. The report must run automatically …

I am trying to access one colum in one row in a SQL Database. Dim qryDraw As String = "SELECT LastDD FROM dbo.comDate Where DrawNo = 2 " Dim cmdDraw As New SqlCommand(qryDraw, Connection) Dim pagesize As Long = 0 Dim adpDraw As SqlDataAdapter = New SqlDataAdapter(qryDraw, Connection) Dim dataSet …

hello everybody I'm Deepak Singh,I'm a first year studsent of Bsc.IT and i'm having a lots of problem in solving C# and SQL programs. so I request that please give me a better guideline for the same. at the same time I have also problems in my communication skills. I …

I am trying to make a login form, and i need it to check for the inputed name in the database. I can't figure how to get text from the cell. i would also prefer not to use a GDV on the form. I am mainly seeking a way to …