Hello, While working through my encryption questions from preivous posts, I am finding that I may have to resort to use triggers to do the encryption (not that this is the only way, but might be the best way for my circumstances). I would like to create a trigger that will encrypt the field bef...more >>

Hi All, I have a problem, a user deleted some tables from a couple db's dealing with replication. I now get this error on those db's. The process could not execute 'sp_repldone/sp_replcounters on servername I have deleted one of the database's and neither are listed under publications...more >>

Hi All, I am not so proficient in SQL and seek your help. I have a column by the name of Mask in a table, which has text eg. (YYYYYYYNNNNYYYYYYYYYNNYYYY). I wanted to update one particular value in that text. How would my update statement look like? Below is my select statement. select...more >>

hello everyone, I created a function in MSSQL that builds an html coupon based upon the coupon ident (more complex than that, but that's not where i'm having problems!) When the function builds the coupon, it returns the stream as VarChar(8000) I am calling this function in a sproc that ...more >>

Hi Could somebody may explain me how works backup in clusters ? Thanks Adam...more >>

Hi, I'm trying to construct a query (in a stored procedure) which will have a number of selection criteria based on input parameters. There are a number of these parameters whose selection conditions they represent which all have to be true for a row to be returned in the resultset. The ba...more >>

Vb stores an image (bitmap/jpg) in a SQL2000 image field. For some reason it doubles the size by adding 00 for each byte. But sometimes it doesn't add 00 (0000.0000) but 01 or 20 or ?? and also the byte that should be transferd is changed... So SQLImageData = Imagebyte + 00 and sometimes SQLIm...more >>

Hi, is it possible to create a cursor from a dynamic string? Like: DECLARE @cursor nvarchar(1000) SET @cursor = N'SELECT product.product_id FROM product WHERE fund_amt > 0' DECLARE ic_uv_cursor CURSOR FOR @cursor instead of using this --SELECT product...more >>

Hi We received the following in an email from a third-party supplier (who naturally has a solution for the problem as described). It sounds like gibberish to me, but does anyone have any comments? <quote> SQL in its current incarnation hits a performance brick wall when a table contains mo...more >>

hello all, i have this table: CREATE TABLE [dbo].[Table1] ( [person_id] [int] NULL , [dob] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO with these values: insert into Table1 values ('1', '15/12/1975') insert into Table1 values ('1', '01/01/1980') ins...more >>

Hello, I have been researching the use of symmetic and asymmetic encryption in SQL 2005 and I am pretty excited to give it a try. Through examples, I can encrypt the data, but I cant figure out what to do next... What I want: 1. our social security field to be encrypted so that only the perso...more >>

The XML Datatype does not support the case-insensitive search makes the XML DataType (almost) useless, if I stored the xml in the XML column, I certainly want to search it, if I could not performance case-insensitive search, why do I need store the data in the XML column? I try the followin...more >>

Hi, I was hoping someone could confirm the following about the following number 2 SQL query: 1. This extracts the data required given that there is a recording to match the records 2. This should, but im not convinced extract all the remaining records that do not have a matched recording, b...more >>

Hello, if you create this table: create table hello ( int a , int b constraint pk_hello primary key clustered ( a, b ) ) and then insert the following records a,b 1,1 1,2 1,3 2,1 2,2 2,3 3,1 3,2 3,3 and then do select a,b from hello the output seems to be: a,b ...more >>

I have one table used to maintain information on Service Events. Each record contains a Repair, Maint, and Battery checkbox (bound/boolean). Any one of these fields may be checked or left empty. Ex. REPAIR=True, MAINT=False, BATTERY=True I want to generate ONE report that lists all the REPAIRS...more >>

Hi, We are in the process of buying a new server to run mssql. However before this as a tempory fix to using a msaccess backend i believe through odbc i need to address the following issue: SELECT ai.entry_date as CallTime, ai.agent_login as AgentsLogin, ai.ca...more >>

Does anyone know how to how to performance case-insensitive search on XML data type in SQLServer 2005? Or I have to convert all the xml data to lower case before I store it? Thanks in advance. John ...more >>

Gurus. I do not know if it is possible, but here is what I want to do. I want to allow user to page the SQL result, so he could decides to return from row 10 to row 20, or row 100 to 200, without returns the whole resultset. Every time he sends another request, I do not mind to hit the database...more >>

Hi need help My english is not good so ill be short. This is my database create table customers ( customerid int unsigned not null auto_increment primary key, name char(40) not null, address char(40) not null, city char(20) not null, state char(20), zip char(10), coun...more >>

I inherited an existing database application about 6 months ago. I've finished converting it to use SQL Server 2000 as the backend (MS Access 2002 frontend w/ Userforms+VBA code pointing to the backend). In its current state the application makes use of a ton of embedded SQL statements and...more >>

Hi, I'm not a big friend of MSSQL, but I have to do one query I've done for mySQL. But I don't know how... I have to select 'user' from 'db' where first letter is E or N, second is B or 0 and after that there are 6 or 7 digits I know. How can I do that? In mySQL it would be something ...more >>

I am developing an integration process between two databases. One of them is a SQL Server 2000 and the other is using MSDE 2000. The integration process is done in C# (VS2003). The main database is the SQL Server, the MSDE will contain a really small subset of the data found on the main. To he...more >>

Dear MSSQL experts, I use MSSQL 2000 and encountered a strange problem wqhile I tried to use a select into statement . If I perform the command command below I get only one dataset which has the described properties. If I use the same statement in a select into statement (see the second se...more >>

Hi everybody! I have several tables from which I want to exract the SAME value (along with other referenced data). All the values are in the same column within the tables. How can I achieve this? TIA. Andro ************************* example: (piping bill of material where tables rep...more >>

If this is in the wrong group lemme know and I'll re-post it to the correct one. I am using PHP and MySQL. Suppose I have a table named "servicios" with 5 columns and 200 rows. If I want to get the whole table sorted by column 3 (suppose the field name is "nf") I use: SELECT * FROM `servi...more >>

Hi My DB backup and transaction backup of a database keep on failing with the following error: Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'E:\SqlServer\testdb_db_200604221313.BAK' failed, status = 112. See the SQL Server er...more >>

Hi, In SQL 2000 if I wanted to take a complete copy of another running sql database all did was create a new database locally and right-click it and select import and point to another database and click copy everything (stored procedures as well) and it did it for. I can't seem to find the sa...more >>

I am learning SQL Server 2005 and I was told to install a second instance of SQL Server 2005 on my machine. How can I install a second instance of SQL Server 2005 on my machine I already installed SQL Server 2005, I guess this is my first instance. To install a second instance, do I just ...more >>

Hi I'm new to SQl.. I have some monthly data which is being encoded as Varchar...Say for the month of January 2005 it wud look like '200501'. For each of my month I have a coloums which gives me datetime and volume of the job. This is what I'm doing Select Month, Time , Sum(Volume) ...more >>

I have a data file that I converted from Access to SQL Server using the upsizing wizard. I then attached the tables to the Access front end using an ODBC connection. I have one table that is read only for some reason. I'm not sure how that happened, it went through the same procedures as th...more >>

Tools: SQL Server 2K, Excel 2000 Hi, I have an Excel report worksheet with formatted headings. What I want to do is to export data from the SQL server into a specific cell of the excel file. Is this doable? Can somebody give me some direction on how to accomplish this? I appreciate any...more >>

I have a SQL based ERP package. Now I am having an issue on a particular table of people deleting a record (in the ERP system) and no one having any idea of who did it or when. So I thought I would setup a delete trigger so that when a record is deleted from a table it would populate a new ta...more >>

Hi all, I am a newbie with SQL and I have a statement that someone else wrote for me. It works up to a fashion but there seems to be a bug with it (or maybe I didn't make it very clear to start with ;-P). The statement needs to pull in details from a table. If there are more than one recor...more >>

Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Let me explain clearly For example think we are usin...more >>

I'm moving some queries out of an Access front end and creating views out of them in SQL Server 2005 express. In some of the numeric fields, I use nz quite often, ( i.e. nz([MyField],0)) to return a zero if the field is null. Is there anything equivalent to this in SQL Server? Right now I'm ...more >>

In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How can I make this work with SQL and Terminal and 2 different PC's? I have 30 users that need to log on to my SQL database. ...more >>

Is there anyway in SQL Server to rollback an SQL statement which was already executed. I know there is a transaction log but what it contains and how it works is still a mystery to me. Assuming I delete all records from a table - can I somehow undo this? ...more >>

In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How can I make this work with SQL and Terminal and 2 different PC's? I have 30 users that need to log on to my SQL database. ...more >>

hi! I have two tables with same structure. I need to run a select query that will return only the rows from one table that are not in the other. In MySQL it would be select * from table1 MINUS select * from table2. but in MsSql I can not find the apropriate way to do this. Any He...more >>

I've previously used version 7 and 2000. I've recently started to learn ASP.net. I've installed Visual Web Developer 2005 Express and this includes SQLServer 2005 in the installation. The task manager and and the list of services definitely show I've got SQLServer running on my computer. ...more >>

For some reason, I recall having read that SQL Server 2005 would support a datatype that represented date, but not time. (This would be useful for storing things like birthday, where you usually don't care about the time of day). But I've got SQL Server 2005 installed, and there's no such data...more >>

We set up a test box and having been trying to move an entire instance from our production server to this one. I have moved all my created dbs using the RESTORE WITH MOVE. Now I am trying to move the Master, Model, and msdb. This is where I am having trouble. On the production box the dbs ar...more >>

Hi all, I am having issues of efficiency of backing up data from one SQL data base to another. The two servers in questions are on different networks , behind different firewalls. We have MS SQL 2000. On the source data i run a job with the following steps: 1> take trans backup every 4...more >>

Is there possibility to use IF conditions inside SELECT statements? For example, can i write something like this: CREATE PROCEDURE [search] ( @OPTION int, @KEYWORD nvarchar(40) ) AS BEGIN SELECT id FROM projects WHERE title LIKE @KEYWORD IF (@OPTION = 1) THEN (OR description LIKE @KEYWO...more >>

Hi Everyone, I use the following to get records from the last two days in MySql: where date_entered <= curdate() and date_entered >= DATE_SUB(curdate(),INTERVAL 2 day) I'm looking to do the same in MS-Sql server but I'm just not getting it. I've got this so far which does not work: whe...more >>

The IT shop I work in installed MS-SQL Server last week for the sole purpose of converting a large MS-SQL Server database to a format that Informix (our main database engine) can read. MSSQL Server installed perfectly, I can view/manipulate the little "Northwind" sample database, back it up to ...more >>

After executing osql from the command line via the Windows scheduled task interface, the following error is returned: "Timeout expired" The code in the sql is as follows: BACKUP Database DBName to DISK='D:\Files\Backups\DBName.bak' WITH INIT go Is the timeout happening during the back...more >>

Can you please assist me on how to get the 2nd record in case there are 3 or more records of an employee, the query below gets the MAX and MIN BasicSalary. However, my MIN Basic Salary is wrong because I should get the Basic Salary Prior to the 1st Record (DESC)in case there are 3 or more re...more >>

I am creating a report that has call duration and if i run it over a multi-day span the duration is limited to 24 hours and starts over at zero. is there a way to not limit hours? I am usign the following in my select statement: convert(varchar(12), dateadd(s, SUM(ISNULL(Calls.OutgoingCall...more >>

I am hoping this is a quick easy question for someone! :) I am trying (struggling) with moving data from Sql Server to a Lotus Notes table. I am using SQL Server 2000, I have a Lotus Notes linked server (using NotesSQL), and I wasnt to clear the table (delete all records) and then reloa...more >>