2,935 Topics
 | |
| | Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = … |
| | I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1. Any idea why? P.S. I think the installation process is asinine. |
 | Hi there, I was trying to get a [B]Scheduled Job[/B] (in SQL Server 2000) to [B]run every second[/B] or two. I had three T-Sql blocks I needed to execute every two seconds, and you know you can just schedule recurring times to every minute. I started out by introducing multiple … |
| | Hi I have 3 tables that I need to display in a report TableA idxA valueA 1, a 2, b 3, c TableB idxB bidxA valueB 1, 1, aa 2, 1, bb 3, 1, cc 4, 2, aa 5, 2, cc TableC idxC bidcA valueC 1, 1, dd 2, 1, … |
| | How can I create a Formula to figure out a Golf Handicap IN MS SQL Step 1 (Score - Course Rating) x 113 / Slope Rating For example, let's say the score is 85, the course rating 72.2, the slope 131 The formula would be (85 - 72.2) x 113 … |
 | [B]Hi all The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each group can contains multi-user by [U]Group_Id[/U] which is foreign key in [COLOR=Green]user_tbl[/COLOR] . [/list] [list]I am now about creating a trigger that happens … |
| | hey all i need help i am developing web project with ms sql db. i want to know how i can insert a text in db after i changed its font or color or align, i have html editor in one of the web pages, ex: [B]xxxx[/B] the insert statement … |
| | The table I'm searching is varchar. The entries I'm interested in are only numeric. But for some reason there's mixed string/int entries. How can I chose only the numeric values? |
| | I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql … |
| | Hi Guys! I am newbie to MS-SQL Server and I’ve run into a very very serious trouble. My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is: MEMORY Out of my stupidity I upgraded our server’s memory to 4 GIG and to our … |
 | 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 … |
| | |
| | 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 … |
| | hello, how to close all open sql server connections from vb.net? please help. |
| | 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, … |
The End.