2,736 Topics
| |
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), … | |
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 … | |
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 … | |
Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys | |
Hello! I'd like to ask for some help. I'm using Visual Web Developer to create a web site, in which members can log in. It has the default aspnetdb.mdf database, in the app_data folder to store the member's data. This works quite good offline. My only problem is that I'd … | |
--query of a very large table SELECT abc AS 'productname', xyz AS 'quantity' INTO #tmptable FROM dfg WHERE blah -- --content of #tmptable: --productname quantity --product1 5 --product2 3 --product1 2 --product2 8 --product1 5 -- how does a query on #tmptable look like, if I want to receive the … | |
I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error: The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for … | |
Hi, I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any … | |
Hi all, I am new to sql programming, How can we copy a database from a local system to server? Thanks in advance, karthik. | |
Hello, I'm making a phone book application (ASP.NET, C#). I store general information of people such as name etc on one table called "people", and I've another table called "relatedInformation" which has 5 columns (ID, Name, Info, PersonID, Type). In this table I store all other information regarding people, because … | |
Hi, I would like to know if it's possible to create a procedure, where we pass 2 arguments (the databases where the search must be done) and how to use those parameters in select clause What I would like to know is if it's possible something like: [CODE]create proc dbo.uspMySearch … | |
I'm working with SQL 7 on a Windows Server 2003 R2 Ent. Things will be working just fine and then we will for some unknowen reason start getting this error message and then we have to restore the DB to resolve it? This has now happened twice within the last … | |
I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure … | |
Hi, I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. … | |
Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order … | |
How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810 |
The End.