Hai , in a textbox am having text as "(20/100)+pay1*pay2" .it's a formula. and stored in a particular variable. string strformula="(20/100)+pay1*pay2" ; i've to substitute the value of the variable 'pay1' & 'pay2' and finding the value of that strformula. can any onr tell me how to find ...more >>

Hi, I have three fields that make up employees' names in the database i.e. FirstName, MiddleInitial and LastName fields. FirstName and LastName fields are varchar(30) and varchar(50) respectively. MiddleInitial field is char(1). When I use the FirstName + ' ' + MiddleInitial + ' ' + LastNa...more >>

i have a table with 3 columns: duration (int) startdatetime (bigint) userid (int) i want to get that row's startdatetime where sum of duration becomes equal to or greater than 1000. how can i do that? i can only think of a cursor solution. Thanks ...more >>

Hi, I have a decimal field with precision 3 and scale 1. This field will have values ranging from 0.5 to 10. When enter new values into the table using the following stored procedure, my decimal values get rounded up. If I enter values directly into the table, everything is fine. Do I ne...more >>

I would like to use a select statement that selects various columns from a database table but also contains as the output of the select statement an image datatype which has been set to the value of a bitmap btained from a local file at location c:// How would I do that? Thank you. -hazz ...more >>

how do I do that? thanks. -hazz ...more >>

Is there a trigger that would handle this situation? I have a 1 to many between two tables and would like the primary key deleted if the last foreign record is deleted. Thanks in advance! ...more >>

In a datagridview databinding scenario, I would like to replace a datagridview column's text values with an icon for a better user experience. The problem is that if I select the column value from my table of datatype varchar, that datagridview column value cannot be changed from a textbox c...more >>

Hi all, I'm having a (probably) fundamental problem executing an insert statement on SQL Server 2005 from an app written in plain C, using the DBLib API. Please DO NOT comment on the fact the DBlib is obsolete, I know it is. It's just the fastest way with the least overhead, and as such my ...more >>

Any idea? column "TEST" data of column TEST [data123], [data234], [test111], [test321], [data456] How can I replace part "test" to "data" by simple sql-command? ...more >>

Ladies / Gentlemen I need to be able to store only the 'Time' that an event happens not the 'DateTime' how can this be done? I need to make sure that 'Dates' do not come into play as I will be doing queries such as this. Select * Where StartTime <= Convert(DateT...more >>

I have SQL 2005 installed on a server. The client is trying to connect to the server, I can create an ODBC connection but when when software tries to connect using ADO I get the following error "To connect to this server you must use SQL Server Management Studio" What do I need to ins...more >>

ISNUMERIC('.') returns a value of 1. This is bad, right? Howard ...more >>

A column (call it Pcolumn) in the parent table should equal the sum of [crProcAmount] from several rows in the child table. So, in Design Table, we set the formula property for Pcolumn to the user-defined function ([dbo].[udfBudgetAdjustment]([pkID])) where pkID is the primary key in the par...more >>

Following is a query based on Northwind. I need to output the highest order value for each date. The following works. However I want to see if there is any way to remove the nested query and do some joins. select a.orderid, a.orderdate, sum(b.quantity * b.unitprice) as total from orders a, ...more >>

Hello, I was asked by the finance dept. to come up with a solution to produce a report for them for tax area... anyway here's the probelm have a table 3 columns (invoicenumber, total sale, tax) so i have data that looks a bit like this 1 $200 $1.75 1 $200 $4.00 1 $200 $3.00 2 $400 $0.99 ...more >>

I have a udf with a single parameter @Status which I use to return records based on a status of Red, Amber, Green, or ALL(DEFAULT). It works great but I want to be able to return records that are either Red or Amber. I have tried entering values to the function when it prompts me a number of d...more >>

I generated SQL Script to drop and recreate some tables in my database that I will want to perform monthly. I would like to put the script into a sproc, however when I try to compile it I receive an error that the tables and indexes already exist in my database. Is there any way around this o...more >>

Hi and Help!! I'm using Bulk Insert to read a text file that is on a different server. I get an access denied message. - If I change the name to a non-existant file, I get an error that it can't find that file, so it can see it. - I can successfully read a copy that I stored on th...more >>

This bugged me in SQL2000 and seems to still be here in SQL2005. Here's repro code to run on two SQL2005 servers: Run this on the "remote server": Create Table RemoteTable (id int, txtdatacolumn text) Insert RemoteTable Values (1, 'remote') And run this on the "local server": EXEC sp...more >>

I'm having a rather weird problem with an Instead Of Insert trigger. Its supposed to check to see if the record exists in the destination table, and if so update it, otherwise insert the row in the table. All pretty straightforward, but I'm getting weird behavior. If the destination table...more >>

when running the following statement with CDatabase.ExecuteSQL: "update TABLE set COLUMN1=STRING1,COLUMN2=STRING2 where COLUMN3=STRING3" A little background... This statement is ran by clients when connected to the database. The database is running on a machine where there is manager/monit...more >>

SQL 2K w/latest SPS, Win2K Adv Server 2gb RAM, dual-core AMD CPU 3400, 80gb free on drive There are ~ 9 Million rows in table __ACS and there should be < 100,000 rows inserted into __ACSmaster. There are indexes on each of the columns in the Group By - though I suspect they have no effect ...more >>

How would I copy x amount of records, at the same time changing one of the fields? I can't copy the records as is, because of unique constraints, and I can't leave the field that needs to be changed blank, also because nulls are not allowed. So how would I do it in one swoop? ...more >>

Can I get your recommendations on the best schema differencing tool to be had? TIA! Robert ...more >>

If I do a INSERT INTO <table> SELECT ... and <table> has an identity column with an increment equal to 1, does SQL/Server 2000 and/or SQL/Server 2005 guarantee that the identity values generated for a single successful INSERT of this type will be consecutive. So if I do an INSERT INTO ... SEL...more >>

Folks, How can I program BCP to output text items in double quotes (")? Here is an example (please try it) that trys to output some columns from a table to csv file. However, due to the existence of commas within the fields, the comma separation gets messed up. --------------------------...more >>

Situation: We are blank new to SQL server (previosuly access) and we need to convert to sql server quickly. Consequently this is maybe not a very wice question - but it is SO important to us :-) ** this works in access - but not on sql server: Tabel contains 2 fields: id = autonumbering t...more >>

In SQL Server 2000 Query Analyzer, is there a way to print T-SQL code with the QA color coding? When I print, even to a color laser printer, everything including the keywords and comments come out in black and white. Thanks!...more >>

I have have three tables that I need to pull information from, and return selected rows. Sorry for the psudeo-code for the tables, but it should give you an idea of their (simplified) structure: Inspections ( InspectionID int (PK), LocationID int (FK), InspectorID int (FK), Inspect...more >>

What is the SQL equivalent of the following VBA? Am very new to SQL programming Kill "C:\Documents and Settings\Ray\Desktop\TestExtract.txt"...more >>

I was wondering how to write a query to count the following date and times. Any help would be appreciated. This is from a table sv_call_log I am using a column called start_date The column start_date is formatted start_date -------------------...more >>

I cannot for the life of me set up a linked server. I am trying to do what I think must be the simplest, easiest linked server set up there is: Link an instance of SQL Server 2000 to another instance of SQL Server 2000. I've read everything I can find in BOL, on the web, in my sys Admin book...more >>

I have a table that I need to remove duplicates from and the table includes an identity column. The table contains 12 fields but our business rules are that only 3 of the fields can make the record a duplicate. We would like to keep the record with the min identity column. I have done this ...more >>

Hi, I have some data in ANSI txt file, i want to know which one would be better and recommended way to import this into table. bcp or BULK INSERT Appreciate your inputs on this. Thanks, Manoj ...more >>

Dear all, I would need to rename the name of the server. any comments will be welcomed. -- current location: alicante (es)...more >>

I have created a CLR trigger that validates an address that has been enetered into our address database does not already exist and that it meets country critera for addressing. I have a RowVersion column (timestamp), I use this to determin if any changes have been made to a record in the ta...more >>

Hi, How could I create a new table dynamically where columns names are data from another table? Example: I have a table "Table1" with one column "T1Col" The column contains following data: "Row1" "Row2" "Row3" Now I would like to "read" data from Table1 and create a new table Table2 wh...more >>

Hi CREATE TABLE [Table1] ( [Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Title] [varchar] (50) NULL , CONSTRAINT [PK_Temp_Table1] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [Table2] ( [Id] [int] IDENTITY (1, 1) NOT FOR REPLICAT...more >>

Hello everyone, I have in a table a field smalldatetime. The problem is that when I select from table I need only the date without the time. Is it possible not to show the time? For example 06/02/2006 00:00:00 to be 06/02/2006. Thanks a lot ...more >>

Hi, I'm Roby Eisenbraun Martins. I'm a C++, VB, C# as ASP .NET developer. I'm creating a number of transactions one after another. Right now I always worked with the last transaction created. But somethings I need to add code in another transaction. Is it possible so switch back ...more >>

I am looking for a explanation on the following: I have the following code (on a dataset of 1 million rows). It runs very efficiently: ---- declare @tussentabel table (contractnummer nvarchar(25), positienummer nvarchar(25), messagetime datetime, ean nvarchar(30)) insert into @tussenta...more >>

Lately there seems to be quite a few posts regarding the concatenating of column data in sql.Faq2559,written by a very knowledgable MVP,is often cited as a reference for this problem's solution.This problem is interesting as it has spurred debate on a number of issues including client vs. server...more >>

Hi folks! I have a small problem i'd like to solve: Say i have 2 columns, both are nvarchar(20). the first one contains license plates. I'd like to update the second column to contain the same as the first, but with a space between letters and digits or viceversa. examples: col1: S XX1...more >>

Hi! I have a table I'm trying to sort a table from a stored procedure but no. If I do it from Query Analyzer it works fine, but when I try the same thing from the stored procedure it just refuse to sort. Any ideas? Collation? Anything else? Quite irritating... :/ /e ...more >>

Hi Gents, If there are some client connections on the database and I would like to detach the file, it's failed when execute the store proc "sp_detach_db". Any SQL statement or Store Procedure on clearing/kicking out the current client connections? Thanks in advance. Regards, CurtisL ...more >>

HI all, Where can I read up on how to use query analyser to optimise queries and SP etc. Thanks Robert ...more >>

Hi, I've not created one of these before so if anyone can help me get this up and running that would be great. I want to write a function to obtain the exchange rate from a table based on three parameters - exhange rate, country & year. The complication I have is I want to pass in the va...more >>

HI all, Which ould be the best datatype to use. I have possibilities of monetory values from 0 to 1000000000 I've heard that the money datatype is not readily used. Should I use numeric. What do you guys use Thanks Robert ...more >>