2,935 Topics
 | |
| | So, I've got a bit of a conundrum that I cannot for the life of me figure out. Here's what I need to do : In column PO_I, look for column ITEM with lowest # in column Seq_I. If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next …  |
| | I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion: 1) Will MSSQL2008 support all sql statement that was written in MSSQL 2000? 2) I know SQL2008 … |
| | Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example … |
| | Example Database id master_id ref_id 1 p1 c1 2 p2 c1 3 c1 c3 4 c3 c1 5 p3 c4 6 p3 c5 Starting with "p1" I wish to return the recursive list of master_id:ref_id Here's the problem: p1:c1 c1:c3 c3:c1 (circular reference) c1:c3 ..... ..... etc How do I … |
 | hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable. |
| | We are working on a project & finding an issue while accessing the data from SQL Server. Problem: Display of record in search console of application on number of times it has been processed. Consider we have a record which needs to be displayed 5 times a day in search … |
| | Hi, I have created DB applications using MS-SQL and VB. But, I am new for distributed database program development. Will you please help to design one? |
| | Hi all, I have a very simple query but this is driving me nuts. I have installed sql server 2008 on my system. Its working fine, but the main thing is that i am not able to configure the report server. Can anyone help me how to configure the report … |
| | Hi, Check the following description of my requirement. (This is in MS SQL 2005.) 1. Select a table in your DB. 2. Alt+F1 lists the structure and the details of the table. 3. In that, i could see a. Table Name and Owner b. Columns , data type , size … |
| | Hi, lets say I have the following 7 records in my database ID Model -- ------ 1 400 2 400FL 3 400 FL 4 ABC 5 SGH500 6 SGH-500 7 SGH 500 How is it possible if i could select out the rows which are of possible match to some … |
| | I could not find pubs database after installing mssql 2000. I dont know wat to do.. Help me |
| | Hello! I've beat my head crazy trying to figure out what the heck is wrong with this query. It is not my query, but one from a packaged software I need to customize. I've created a link to the sql db's in an access db (linked to all sql tables) … |
| | Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't … |
| | |
| | I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns … |
| | Hello, What SQL query should I use, in order to copy records from one table to another, both of the same schemas, in such way that only records that don’t already exist in the destination table will be copied? For example: Table A – Destination table ****** Col1 Col2 Col3 … |
| | We have a Log table which logs the events of a request. When any error event occurs, I need a query to see the row with errorevent and the previous row to this row which contains the actual data which caused the error. Here is the table structure: LOGID (int), … |
| | Require help I had 2 question 1) What is the script when I select Option 1 click command button will go to form 2 and select option 2 click button command will go to Form 2? 2) What is the script connection within vb6 to mssql? |
| | In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails. The transaction was initiated by a C# program using a table adapter and LINQ. In Visual Studio you see that the transcation fails but not … |
 | Hello all, Are UDFs written only on SQL Analyser in within the SQL? Can we use them in programming code?How to use them in the code? What are the actual benefits of UDFs? We can write the method in the code and connect to the database and execute which yeilds … |
| | I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I … |
| | Hi All, I've a table name Countries with two fields as ID, and CountryName. Where ID is foreign key(ie., may have duplications) and the country name can be repeated as many times as it needed. for example the scenario is ID CountryName 1 India 1 US 1 UK 1 Japan … |
| | Hey all, I need help from all you genuises out here. I have 3 tables [CODE]CREATE TABLE IF NOT EXISTS `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag_id`) ) CREATE TABLE IF NOT EXISTS `video_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` … |
| | Urgent help Please! I have a table exist in two database on two different server. I want to get the data of table from one table and another. When I am using OPENROWSET command it through error. I don't know what it mean. Is there any way to migrate the … |
| | trying to extract fulladdress to individual column such as address1 address2 City State Zip, and each of the fulladdress has a [B][U]comma[/U] [/B] so that why I am trying to create a function that count the comma and put the fulladdress ito individual column. hear is the script that I … |
| | Hello, I hope my question falls in the right forum. I have a content web 2.0 website with ms sql database. As most content websites, every file has Title, description and tags added by uploaders. I would like to know if there is any standard algorithm for SQL search based … |
| | Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation … |
| | Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named … |
| | I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management … |
| | Hi all, I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that? Please help. P.D.: I have … |
The End.