2,736 Topics
 | |
| | Hi, I created to data tables to hold information provided through peer reviews in the company that I work for. One table has 5 different levels of quality (unsatisfactory, meets some requirements, meets requirements, exceeds expectations greatly exceeds expectations), and another table that holds the data for each peer review … |
| | I'm in need of some help with 3 tables I have with MSSQL. Is there a way to use a single database query to get the results I'm looking for? (See the bottom for an ideal returned recordset.) Thanks! TABLE: APPLICATION APP_ID APP_NM GRP_ID -------------------------------------- 1 Script 1 1 2 … |
| | i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you … |
| | I'm Using Microsoft Visual Web Developer 2005 Express Edition to design a web site, and it displaying this error " Saver Disabled" any time that i try to run the programm , pls what is d couse of this problem and how can i solve it. am using SQL Server …  |
| | hello, I have a table with int Primary key. Is there a way to set identity property on this field w/o dropping/recreating the table? Thank you. |
| | Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. … |
| | [COLOR=#0000ff]UPDATE[/COLOR][COLOR=#000000] table1 [/COLOR] [COLOR=#0000ff]SET[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC] [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#808080]([/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]SELECT[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC][/COLOR] [COLOR=#0000ff]FROM[/COLOR][COLOR=#000000] tmptable[/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] tmptable[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] table1[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN[/COLOR][COLOR=#808080])[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] [/COLOR][COLOR=#808080]EXISTS [/COLOR][COLOR=#808080]([/COLOR] [COLOR=#0000ff]SELECT[/COLOR] ID[COLOR=#808080],[/COLOR][DESC] [COLOR=#0000ff]FROM[/COLOR] tmptable [COLOR=#0000ff]WHERE[/COLOR] tmptable[COLOR=#808080].[/COLOR]ID_SUN [COLOR=#808080]=[/COLOR] [Table1][COLOR=#808080].[/COLOR]ID_SUN[COLOR=#808080])[/COLOR] [COLOR=#808080]I tired this but i coudn't uptade tow columns at once[/COLOR] [COLOR=#808080]do i need to seperate them or i have any mistake? … |
| | Asset Table +-------+---------+-----------+ | Date | Asset | Value | +-------+---------+-----------+ |1/1/07 |Building | $1000 | |1/2/01 |Computer | $ 500 | |2/1/07 | Fax | $ 100 | +-------+--------+------------+ Result Table I would Like; +-------+---------------+ | Month | Total Asset | +-------+---------------+ | 1 | $1500 | | 2 … |
| | hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number … |
 | Hello everyone! [COLOR=#000000]I ‘m new to SQL Server 2000... [/COLOR] [COLOR=#000000]My industrial supervisor wants me to study about the best practices for database maintenance. I’m not sure about the content of my project. Could anyone give me some guidelines…? [/COLOR] [COLOR=#000000]Thank you[/COLOR] |
| | Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I … |
| | Hi Everybody, I am a newb in SQL Server 2000. I have a genuine question. Actually what is the use of this sql server, just to store information/datas of small size??? that is: Name: Anish Age:22 Sex: Male in this format?? Maybe this question arises in my mind due to … |
| | Hi, I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel. Could any one tell me how this can be made possible.Also could any one …  |
| | I cant call : [111.111.111.1].Database.dbo.fn_test(@test) (Not working !) but i can call : Database.dbo.fn_test(@test) why ? and if no way to call this, can i populate in a function a TABLE variable using a Stored Procedure to do this ? CREATE FUNCTION fn_test(@idcode int,@idoper int) RETURNS TABLE AS RETURN (EXEC … |
| | hi friends........ I have created a database in a web server.... i have the server ip address .... and also i have the control pannel acces fot for tat particular server.... but how i will acces tat particular location using my sql server please help me...... |
| | Hi all i have 2 DBs: Energy & Users [U]Users:[/U] -id (pk) -nick [U]Energy:[/U] -id (pk) -title -userid (fk) -dateposted Description of workflow: there are a number of titles in "Energy", and each user has more than 1 titles. I would like to display Users's Nick, and LATEST TITLE (which … |
| | hai all i am undertaking a project of sending sms to mobile phone using sql server 2005,pls guide me how to do that,[COLOR=red]this is urgent please:'( [/COLOR] |
| | hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL … |
| | i want to connect to a sql server db using a sql login from VB.NET. the problem is that i cannot fill my dataset when i login using the sql login. However, the code works perfectly well from a windows login. ALSO i can login well using the sql server … |
| | hi.. i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created. [code] CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] … |
| | Hello, hopefully you can please help me. I've been tasked to upgrade an old system and there's many different versions of VB code that uses MDAC to talk to MSSql. Version 1 of the program is: [code] Public cnxEventLog As New ADODB.Connection (defined globally) <code in a procedure follows> If … |
| | I have a populated table and would like to store a link in a field. I am populating an html table from the table and want the value of the field to be a clickable link....is this possible? :-/  |
| | Hi guys, I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and … |
| | [COLOR=#000000]I have two record sets. One is transactions and another is GL posting. I am aiming to create a third table to find out the customers are from which country inflate our GL.[/COLOR] [COLOR=#000000]For example GL Table has following fields[/COLOR] [COLOR=#000000]GLCode[/COLOR] [COLOR=#000000]GLDescription[/COLOR] [COLOR=#000000]GLAccount[/COLOR] [COLOR=#000000]GLAccountCCY[/COLOR] [COLOR=#000000]Balance[/COLOR] [COLOR=#000000]BalanceUSD[/COLOR] [COLOR=#000000]Transaction Table has the … |
| | Hi, I am writing a query that requires as input the difference in days from two dates (Project_End - Project_Start, both of data type DATETIME), how can I find it? Can I subtract the two dates? Thanks, Robert |
| | Hi! I want to share news... Found an interesting SQL editor supporting intellesense. Site vendor [URL="http://www.yukondev.com"]www.yukondev.com[/URL] there is no editing tables, but otherwise that is what I was lacking. [COLOR=black]Regards, Mike [/COLOR] |
| | Hi, I'm a bit stuck. I've been breaking my head quite long figuring how to do this. I need to generate areport that is grouped by week. i need to display total number of patients who are enrolled in the system. And they are grouped by the weeks in a … |
| | Hi all, I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a [code]select * from sales[/code] I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser` I …  |
| | Hi, I have a small database with 15 tables and 20-40 records in each table. I just want to ask how can I print all the tables together with their names, atribute names and all the records? (the Print option from the File menu is not active) Thanks, Robert |
| | Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in … |
The End.