Hi, I have been trying with this *&^%%$$&^ crap since 5pm. I am trying to convert this vb.net code which works absolutely fine Dim sTemp As String = "41234554321" Dim iSum As Integer = 0 Dim iDigit As Integer = 0 ' Calculate the checksum digit here. ...more >>

I am reading in a text file line by line and need to perform some calculations on the data before loading it into a SQL table. I was originally loading the data into SQL using ADODB via vbscript. I would open a recordset, check to see if it was AtEndOfStream, and if so, then add a new row, ...more >>

I have used a SQL Server 2000 database with an Access ADP front end for 2-3 years with several different server boxes without experiencing the following problem . . . If I work on the database over the period of a day, I generally experience at least one prolonged period (say > 10 min) during...more >>

Hi All, I'm not sure this can be done in a calculated field but here's what I need. I have a table that stores time off for employees (such as vacation, sick time, etc). An employee can take partial days off. The table has 2 datetime fields, StartDate and EndDate that store the beginning an...more >>

I am trying to use a REPLACE function to replace '<br />' in a text field with CHAR(13) but it fails and I'm not sure why. My statement is REPLACE(activity_note, '<br />', CHAR(13)) The activity_note is a text column and I want to be able to replace HTML line breaks in this field with car...more >>

hello friends, i am trying to use stored procedure to insert data in datbase....i hav done concction with oledb consumer wizard....can you just help me to get step by step procedure next what to do?how to proced Thanks you ...more >>

Is it possible? I have references to a fair number of Microsoft.SqlServer.* assemblies. I'd really (REALLY REALLY) rather not have to run installs on each machine this web project has to run on. My preference is for being able to copy a folder and go. And installation means later upgrading...more >>

Hi, When using the UNION operator, is there any way to tell which records came from which side of the UNION? E.g. SELECT PrimaryKeyColumn, SecondColumn, ThirdColumn FROM table1 WHERE <criteria1> UNION SELECT PrimaryKeyColumn, SecondColumn, ThirdColumn FROM table1 WHERE <criteri...more >>

I have been trying to get a function to accept a table variable as input with little success After reading the BOL TSQL reference for CREATE PROCEDURE I find the following line "Parameters can take the place only of constants; they cannot be used instead of table names, column names, or the...more >>

I'm trying to figure out some alternative ways to find some counts, so I can test them for performance. My example below shows what I'm talking about. (My real situation is based on real tables, not variable tables, but I'll use variable tables to show what I'm getting at) Basically, I ...more >>

I am restoring a DB with a different name from the original via enterprise manager, but I get an error about using WITH MOVE and RESTOR FILE LIST ONLY. How can I go around this problem...Help! -- obelix "Whether you think you can or you think you cant you are right" .... Anon Message p...more >>

"When you create an index, you can specify WITH SORT_IN_TEMPDB option, which directs the database engine to use tempdb to store the intermediate sort results used to build the index. Although this option increases the amount of disk space used to create an index, it reduces the time it takes to...more >>

Hello... What you think is better as a programming tool to build applications using MS SQL 2000 database server? MS Visual Fox Pro 9.0 or Sybase PowerBuilder 10.5? Please let me know your opinion, and if you know about any reference I could read as part of my decision to select a progra...more >>

Hi, I just found 'Aug-14-1973' isdate returns 0, how to convert a string like this into sql datetime formmat, mybe 'Aug/14/1973' too. Thanks. ...more >>

Noob question. I have a column that's not the indexed key and I want to disallow the inserting of dups in that column (column1). adding a a check constraint with expression unique (column1) is apparently not the answer. Thanks. ...more >>

I have this query string: string queryString = "select * " + "from products " + "where name = " + selectedCategory3.Trim() + " "; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteRead...more >>

Hello all, I require the ability to be able to get route info (specifically Distance) from inside a SQL 2005 Function (so that it may be displayed in a view). I know that it may be rough performance wise but I have no other option right now (I don't think anyway...) I created a small clas...more >>

I hope someone can help me with this . We have 2 SQL Servers. ACCTG and OPS. Database on ACCTG SQL Server is Solapp and on OPS SQL server is Opsapp. I needed to run a query to see what values in Table -SOSHIPHeader Coloumn- User7 did not exist on OPSSQL server Databasse-Opsapp Coloumn -O...more >>

hi everybody, Hope i'm in the right group. If not, please forgive me. I'm very much screwed by INSERT clause. Is it possible to use INSERT with WHERE condition?? Can anybody explain me with an example. ...more >>

Does anyone know if it's possible to set a column header as data that appears in the 1 row that it is returned? ...more >>

HI I'm designing a database. This database will be installed in a few servers. Some of the tables in the database the user can't change only once a month the "center" should send their data to all clients. No connectivity between installations (Replication isn't relevant). What we thougth to do ...more >>

SELECT CategoryName FROM ads_categories WHERE (adnum = 12) returns 3 rows: Catering Cleaning Concierge yet i want it to return all the rows in one bite with a <br> thrown in Catering<br>Cleaning<br>Concierge MAKE IT SO! ...more >>

Hi, We are running Sql Server 2005 SP1 on a windows 2003 server. The server has quad processor with 8 GB ram. We have also enabled the 3 GB switch on the windows. This server is also running Veritas backup with its own sql express instance. We have currently 6 databases that are runn...more >>

Hello If there is a clustered composite index on a table (using multiple columns, InvoiceDate , CustomerID , StoreID for example) then users beside occasionally search by those columns , sometimes search mostly by 1 column of them alone (InvoiceDate), in that case will the parser uses the c...more >>

Hello! Can someone help me finding why this query doesn't work? select 1 C1, 'Interno' [C2], 'ProntoPagamento' [C2], (select c1 from (select count(a.c1) from (select distinct 1) a(c1)) B(c1)) [C3] I get the message: Server: Msg 8159, Level 16, State 1, Line 1 'B' has fewer columns than w...more >>

Hi All, I am writing a stored proceedure which simply selects some basic data out of the table. Within this Table is a field named 'DateAdded', which is a date field. I am wondering if there is anyway I can write my query so it will only retrieve messages, younger than 30 days old. Thank...more >>

convert (datetime, '2006/11/20') is ok. convert (datetime, '11/20/2006') is ok too. Why can't SQL 2005 convert (datetime, '20/11/2006') ??? ...more >>

Hello! Can someone give me a clue why this query doesn't work? ...more >>

Hi, Can we make a composite unique key for a table separate from a primary key? Regards, Sugandh ...more >>

Hi All, Can anyone recoomend a really good book on SQL Server 2005, Im particularly interested in how the security works and Reporting Services. -- Goofy ...more >>

Can anyone reccomend a good on-line resources which takes you through the security and how to set it up. An on-line video / web cast would be really good. Thanks -- Goofy ...more >>