[mssql] Forum Topics

I have a MS SQL DB where I need to add a constraint to a filed of a table. This table is manipulated through an application... in a particular field, the integer (field data type) is subtracted from 5 to 4 or 3 whatever, sometimes a user does an error …

I am developing a system where: - Users can go to a website, sign up for classes, and pay for classes - Or they can come to the store and sign up in person I was wondering if someone could walk me through the steps from the beginning of making …

I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI =============================================================== 1000|31/12/2005 | Sales | -8,000.00 | 12 | 2005 =============================================================== 1000|06/01/2006 | Sales | -6,000.00 | 01 | 2006 =============================================================== 1000|20/01/2006 | Sales | 2,000.00 | 01 | 2006 =============================================================== 1000|28/01/2006 | Sales | -4,000.00 …

I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …

I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005 =================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005 =================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005 =================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005 the fields above have the …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 ================================================== 1001| Hardware| 10,000.00 | 02 | …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales | -20,000.00 | 01 | 2005 =================================================== 1000| Sales | -10,000.00 | 02 | 2005 =================================================== 1001| Cost | 5,000.00 | 01 | 2005 =================================================== 1001| Cost | 5,000.00 | 02 | 2005 the fields above …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI =================================================== 1000|liability | -10,000.00 | 08 | 2005 =================================================== 1001| asset | 20,000.00 | 08 | 2005 =================================================== 1000|liability | -9,000.00 | 09 | 2005 the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer …

I don't know if this is possible but would appreciate any help. RefDes table: ------------------------------------------ ID RefDes ------------------------------------------ 123 VR1 123 C1 124 C2 123 C2 123 R1 125 R2 ------------------------------------------ Is it possible to write a SELECT statement that will produce the following? ------------------------------------------- ID AllRefDes ------------------------------------------- 123 VR1, …

Hello, i've got two tabels, "Artists" and "Music". The relevant columns are: Artists: [Id],[Name] Music: [Id],[ArtistId], [Title],[Added] I want select the post's in the music table, but instead of returning the artist id, it should return [Name] from the Artist table where Music.ArtistId = Artists.Id (so it looks in the …

i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank …

i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank …

guys i have problem in saving a report after i put some colors and formats, i am using MS SQL. The attribute is saved but when i want to see it, there is nothing the report attribute contains nothing while the report id contains number. what is the code i …

I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link …

Hey, I want a search of name ='Jose' to find both Jose and José, but with SELECT * FROM Users WHERE name LIKE '%Jose%' i only get Jose, in "Inside SQL SQL" an article shows this: If you want a search of name ='Jose' to find both Jose and José, …

Hi all i m currently having mysql5.0.18 installed on linux box and i want to downgrade it to some of 4.1.xx. at that same time i want to retrive data also so can any helpme with the same. plz provide some soltion as i dont know how to do that …

Hello, I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. …

I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, …

Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches …

Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link …

Ich transferiere gerade ein Hosting von einem alten auf einen schnelleren Server. Gleichzeitige Versionsänderung MS SQL Server von 6.5 auf 2000. Dabei habe ich mit einer SQL-Abfrage zu kämpfen. Und zwar sieht die folgendermassen aus: SELECT COUNT(*) AS nrecords FROM ABData WHERE (0=0) AND (MARKE='Dodge') AND (Rubrik='Autos') Cold Fusion meldet …

Hi All, I want to save a large string (>8KB) in to a table feild. How can I do this,Pls help me on this

hi if i have table employee with employee_id as a primary key [b]how can i assign the primary key to the columns firstname and lastname?[/b] table structure is something like this : employee_id int not null, firstname varchar(20) not null, lastname varchar(20) not null the problem is that there is …

hey cna you please explain to me the following <" Because the database also stores all the data of the database itself, each database has a number of system tables. Each new database is created following the Model database model. The Master database keeps track of information about the other …

Hi all, I'm looking for a nice query tool to query MS SQL and/or Sybase databases. Currently, I'm using Excel to do some minor query stuffs...and I don't mind using it but it get's repetitive when you have to do it for 70 different databases. So I'm looking for something …

im working on a asp.net project, sorta like a web portal, which will need a user database. i have a very good understanding of sql. i just want some examples or tips on writing a good user database. ive create a few which i think are good, but could be …

Hello have a good day is there a way to retrive top records by range , i mean like this "select top 15 to 20 record from Table name any condition" i dont mean top 15 or top 20, i mean records from 15-20 take care thanking u in advance …

trying to get a count of transfers from one account to another account within the same bank relevant columns: table transfers transferid, toaccount, fromaccount table accounts accountid, bank what i have now is select count(*) from transfers where toaccount in (select accountid from accounts where bank = @bank)and fromaccount in(select …

Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye