[microsoft:sql-server] Forum Topics

Hello, I'm working on an inventory system for a store that was originally built by MS Access. The database, forms and reports are all MS Access components, and it's a total mess, thus an upgrade needed. I thought of programming the new system with C#, and using MS SQL to …

I'm working on a Java program that is calling sqlcmd. It works perfectly on a computer with SQL server installed, but not at all on a computer that doesn't. I want to include the necessary exe and dll files to run this command in my jar. Anyone know which ones …

Hi all, Currently working on Visual Studio trying to create a login system for my website. Tried following various tutorials but can't seem to get them to work. Are the pre-defined login tools on Visual Studio good enough? I've got part way there using them but can't piece it all …

I had built a small cRM database in MS Access. The database is outgrowing its life in access so i was thinking of porting the backend to SQL server express. I was curious on what people's favorite/best frontend for forms and reports was. ie keep my access forms/reports on top …

I am using Below SQL commands at Crystal Report as command [CODE]SELECT count(id) FROM Content WHERE CONVERT(varchar(10),ImportDate,101) between '{?Para1}' and '{?Para2}'[/CODE] but its generate message value as '0',But When I run in sql server it give result as 23454.Please Help me Sort this problem Thanks Tank50

hello all I have Table1 and table2 table1 design is Name ,varchar amount , decimal table2 design is Name , varchar nominal,decimal how is the statement to find the sum of amount in table1 plus the sum of nominal in table2 ? thank you denny

Hi, MS SQL 2005 I'm trying to write a stored procedure.Weighted average cost related to accounting.An area where the data from one field if the date is 01.01. There is no problem. But history is different from 01/01 with the calculated formula into another value equal to the previous day.If …

Hello dear daniweb experts, i was searching over the web and couldn't find any good explenation on how to write properly to a Microsoft SQL server database, so i decided to ask the experts here: How to properly write to the sql database: i used this snipped to read: [CODE]//Start …

I used this code to store convert pictures to "[COLOR="Red"]binary[/COLOR]" inoreder to save in database but it stores only one picture from two pictureboxes. let someone show me how, you can convert pictuers in two seperate [COLOR="Green"][B]'picturebox ("picturebox1 and Picturebox2")'[/B][/COLOR] using the function in the code snippet on something similar. …

I'm not sure if this is the best way but I would like to display a list of addresses in a combo box where the columns come from different tables such as Countries, Cities and Types (work and home). I don't want to display the countryID or cityID, etc. but …

i hv created 3 tables category,author and publisher...n i hve added category,author,publisher items in dropdownlist...n i hv taken lsit box...in which when i select item from dropdownlist i should get the list of items in that particular selected item from dropdownlist..eg...if i select category from dropdownlist i should get the …

I am trying to write my first sproc that inserts values into a table. These values will be entered by the user and stored in a variable . They will then be added to the database. This is what I have come up with so far. I can't seem to …

I have developed a java web application and make installer of the application. This application is using SQL Server 2000, Now I want, when user installs this application on his/her machine, the installer install the database also, if the machine does not have SQL Server then it install the SQL …

Hi All, We want to create a c#/VC++ application by using which we should be able to create sql server database SNAPSHOTs in our own file format (in online manner). And later we should be able to get data from those snapshots files in offline manner using our application ( …

I have this table publication_en Field Type related varchar(200) public_area int(11) title text detail text file varchar(200) and i am trying to do this INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la' "kajakjajk"','J3.pdf') but it doesn't work any idea why it doesn't work ? Thank …

Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want to incorporate the functionality that is being provided by the udf and make it part of the code. the first part of my statement creates a solid table that is being used in …

Hi All, Is there any way to convert the Sql Server 'Snapshot' files (*.ss files) to some other format...like 'xml','xls' or 'txt'...etc. Thanks.

subreport[code]Dear friend pl help me how to call crystal subreport in vb6 backend sql !) I created two report report1 & report 2 both r working fine with below code. 2)I linked two reports by subreport concept of crystal but how to make coding in visual basic 6. Rep_form.CR1.Reset Rep_form.CR1.LogonInfo(0) …

hi doing i try to import data from sql server to text file bust i have some probleam like:--- 2/15/2010 12:00:00 AM ===================================================== POSITION GAMENO START ENDDAY AMOUNT TOTALSALE ===================================================== [code=text] #1 223 92 92 $1 $0 #1 121 92 92 $1 $0 #2 222 115 115 $1 $0 #2 …

Thanks to Daniweb I've almost finished my project just the last few bits to do e.g to prevent double bookings I've had a search around and found [url]http://www.daniweb.com/forums/thread129022.html[/url] which has helped me to make this [CODE] Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim con …

hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the …

Hi All, For more than two days I m trying this problem. Some one please help me out. My scenario is I want to directly insert data into my table from the input which I get it from text boxes. Here is my code... [code] con = new SqlConnection(); con.ConnectionString …

Many people would probably think this question is stupid, but how can i insert a value that starts with 0 in a Bigint/Numeric/Int field? This would normally not be a problem, just using a varchar field instead, but because of the index speed (this is a very large table with …

Hi everyone, I have a query as - [COLOR="Red"]select DateName(Month,Date), avg(NetAmount) as AverageCustomerBill from salesmaster group by DateName(Month,Date)[/COLOR] which gives result as follow - [COLOR="Green"]April 451.5664 August 432.6227 July 441.1437 June 429.9915 May 423.7198 November 407.4123 October 425.1684 September 416.3678[/COLOR] As u can see here Months are not in proper …

ok i know connecting access. i want to learn database connectivity using sql server in vb.net. How do i create a table in sql server in vb.net visual studio i dont have sql server installed in my pc also performing database manipulation in windows application(i have been doing it in …

Yet another date time related sql statement i need help with, oh how I loathe them. I need to find the records between now and a week ahead. I have this so far [CODE] Dim con As New OleDb.OleDbConnection Dim OleDBCon As System.Data.OleDb.OleDbConnection Dim ds As New DataSet Dim da …

Hello. Because my client's table has two rows getting int values as ids from other table to display the string values. Table 1 Table 2 Item: 12 12 = 'Cat' For displaying the values I have created view in DB [CODE] create view ClientsView as select cl.id,cl.Name,cl.Familyname,cl.Position,cl.Email,cl.OfficePhone,cl.Mobile,cl.Website,cl.Comment,cl.[Date],cont.country,cl.Street,cl.City,clgr.[Group] from Clients as …

Hi, I am trying to find a logic for reading sql query data and displaying it properly. i have 2 sql tables Modul & Relation (see attachments) which i am using to create a GDL file format (see Old and New GDL file attachments). I am trying to extract data …

the deal is to create trigger(function?) which would send updated value from one table and add to another example: table1 column:AccountID and 2 column: Money table2: column:AccountID and 2 column: Money i create something like this: [code]CREATE TRIGGER money_from_vault ON table1 FOR UPDATE AS DECLARE @Money Int,@AccountID varchar(10) SELECT @Money …

I was wondering whether anyone could tell em whats wrong with this code. Its trying to get the records where the theorydates (stored in a database as shorttime) are before 2 years ago and return the records in a datagrid but it doesnt. [CODE] Private Sub ExpiredTheoryTest_Load(ByVal sender As System.Object, …

I need code to connect a remote server and displays the databases in that server either by windows authentication or sql server authentication.

[CODE]select distinct cust.no, cust.branch, cust.name, cust.surname, term.benefit, term.code,tehi.trcode, tehi.trancode, dmhi.trancode, dmd.benefit from cust as cust inner join term as term on cust.rowno = term.rowno_custterm_cust inner join tehi as tehi on term.rowno =tehi.rowno_termtehi_term inner join dmd as dmd on cust.rowno =dmd.rowno_custdmd_cust inner join dmhi as dmhi on dmd.rowno =dmhi.rowno_dmddmhi_dmd group by …

hi can anyone help me with checkbox binding in c# to sql database if data is in bit format and to retrieve the same from database

Hi This is my first time posting after daniweb has helped me alot but I couldn't find a solution for this so I thought hey why not ask. Basically I would like to have an sql statement which selects all the bookings from a table in microsoft access callled tblBookings …

i have supertype-subtype: supertype: document subtype: clearance, sedula this query: [CODE=mssql] SELECT Document.DocNo, (Person.Givenname + SPACE(1) + Person.Middlename + SPACE(1) + Person.Lastname) AS Name, Person.Address, CASE WHEN DATEADD(YEAR, DATEDIFF (YEAR, Person.DOB, CURRENT_TIMESTAMP), Person.DOB) > CURRENT_TIMESTAMP THEN DATEDIFF(YEAR, Person.DOB, CURRENT_TIMESTAMP) - 1 ELSE DATEDIFF(YEAR, Person.DOB, CURRENT_TIMESTAMP) END AS 'Age', Person.Status, Person.Picture, …

Hi Everyone, I have a query as - [COLOR="Red"]select top 10 bm.name, sum(sd.Amount) as bd from brandmaster bm join lobattributevalue lob on bm.brandid = lob.valueid and bm.lobid = lob.lobid join salesdetail sd on sd.productid = lob.productid where lob.attributeid = 3 group by bm.name order by bd desc[/COLOR] Now In this …

i have a supertype-subtype: supertype: DOCUMENT subtypes: CLEARANCE, TAX CERTIFICATE, RECEIPT, BUSINESS CLEARANCE each clearance subtype may have a TAX CERTIFICATE, how could i join using join? in other words, document>clearance document>tax certificate i want to join document>clearance and document>tax certificate into a SINGLE view help. thanks

Explain what is meant by cluster index and non-clustered index.

[code] SqlConnection myConn = new SqlConnection(); myConn.ConnectionString = "Data Source=192.168.15.252;Initial Catalog=TestDB;User ID=sa;Password=Pdindia123;"; myConn.Open(); string strqry = "UPDATE Registration SET Password = ' " + Text2.Text + " ',PhoneNo = ' " + Text3.Text + " ', Email = '" + Text4.Text + "' WHERE (UserName = ' " + Text1.Text …

Hi there my first post :), i've started a project that transforms a table from SQL to XML, works like a charm.Now i want to transform from a XML file to database: 1)search if there is a database created(i've done that using try catch) if not create a database XMLReader …

below is my code....i m gettng "System.InvalidCastException: Specified cast is not valid." error in my code...m new on asp.net n sql...m trying to build login area....but unless n until i solve this error i can't move forward n as m new, m not gettng y m gettng dis error... can …

I am trying to help a friend make a database(and ultimately piece of none commercial software) to determine personality type as part of his thesis. For the formula to work properly a couple of the questions need their values inverted(ie if the person answers 1 the recorded number will have …

i m using sql 2000 and i have a table with 3 columns ( credit , debit, total) what i want to do is whenever a value is inserted to the credit column it should add that amount to the total column and whenever there is a debit value it …

Iam writing (or trying to write) a simple join query statement in Query Analyzer. As of right now Im getting the error message Ambiguous column name 'categoryID'. My Statement is ; [code=sql]Select categoryID, Max (StockPrice) as maxStockPrice, MIN(StockPrice) as minStockPrice, AVG(StockPrice) as avgStockPrice From Category, InventoryPart Where Category.CategoryID = InventoryPart.CategoryID;[/code] …

Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you.

please help someone help me.. i need to create a phonebook application, if else, i will fail in my subject. Or help me to insert data on mircrosoft sql server using a save button. please someone... asap.. thanks!

Hello every one i downloaded [B]"microsoft sql server 2005" [/B]and installed it correctly but i m now confused b'coz i can't find [B]Query Analyser[/B].Can any one help me out of the situation .

[COLOR="red"][COLOR="Green"]Hi, Does anyone know if Vista Home Premium can connect to SQL server using the ODBC ? I have tried to create a connection with all the right info such as user id and password but error is "failed connection server does not exist or access denied". The story is …

HI, I have a table which has hundreds column which are boolean value. I need select from the table based on passing parameter which column, (will set this column value = true) How i write a store procedure which accept the column name as parameter, then based on this to …

We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column. This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded. Please suggest how to write a query to know …