I develop a shareware desktop application that should work with a small local database. In my searching of a free database I came across the product "Real Isam" which is totally free for using and distribution. Does anyone have any experience with it? What are the drawbacks in comparison to S...more >>

At my last place, they were about to use Oracle Materialzied Views to move data from a server in Europe to our servers in the US. If you want to use Materialized or Indexed Views in 2000 or 2005, could you do it with this same goal? That is, could you use an Indexed view to push data to anot...more >>

I need to return the names of the users who have ticket types of 1 or 2 and 3. The table structure is as such Users ( UserName UserID ) TicketCat ( TicketCatID TicketType ) Requests ( UserID TicketCatID ) Here is my code... select a.UserName From Users a inner join Re...more >>

Hi, I have a table CampaignEntries which has fields: CampaignID ,EntryID and other, I want the EntryID to be unique and continuous starting from 1 within the same CampaignID. Here is the relevent codes I have in an SP: SELECT @NextEntryID = ISNULL( MAX(EntryID),0) +1 FROM CampaignEntries...more >>

Hi Freinds, SQL 2005 How can I know the name of the running job within the same execution ? What I mean is that if you run db_name() you will get the name of the db you are running, I have multiple jobs that are running in different time frames and I have a table to record the steps of each j...more >>

Hi, I see there are two account created under Security. One is NT Authority \ System and another one is NT Authority \ Network Service. What are they? Is the System account part of the Local Windows Sys Admin? How about that Network Service Account, I see it starts SSIS and SSRS. Can I...more >>

Hi! Can this even be done this way? if exists (select [id] from master..sysobjects where [id] = OBJECT_ID ('master..temp_Source_Media_file_count ')) DROP TABLE temp_Source_Media_file_count declare @sql1 nvarchar(4000) declare @db1 varchar(300) set @db1 = 'master' declare cD...more >>

I have two tables, one with orders, another with users. The users can be of type 0 or 1. I am pulling out a list of all orders with the users (type 1) who have created them. However I would also like to the orders that type 0 accounts have left comments in which at the moment is only an INT. I...more >>

Hi There, I need to return a field that increments each time a certain value is found in another field of a select statement. For example: SortID Break Increment 1 # 1 2 Null 1 3 Null 1 4 ...more >>

Hello! I have a registrationdate field in my table. The date-field has both the date and the time. I want to do comparisons on only the date, so I need some nice code to return only the date part. Could you please help? Note: I am not interested in formatting the value, I want to strip the ti...more >>

We have a computational grid that uses a SQL Server database as a temporary storage facility. Inside of the database, I create multiple (thousands) tables that are named uniquely using GUIDs. This is done so that our gid (hundreds of computers) does not get into table contention. After it i...more >>

Assume you have 3 tables to describe a many-to-many relationship. One table contains a list of car models, a second table contains a list of colours, and the third table links models to colours to show availability. In the availability table, I can think of two implementations: 1) An entity c...more >>

I have a column that contains the following values: 1-5RAVC-0004 1-5REVX-0011 10BACV-0507 PLM177-0071 PLM177-0072 PLM177-0075 PLM177-0076 PLM177-0078 I would like to retrieve from the column everything before the hyphen - except if the - is in the second position in the c...more >>

Would anyone mind taking a look at my T-SQL below and tell me if there is an alternative and better way than I've found to take a DATETIME in YYYY-MM-DD HH:MM:SS:MSS format and get just the date and the hour? DECLARE @yyyy AS VARCHAR(4) DECLARE @mm AS VARCHAR(2) DECLARE @dd AS VARCHAR(2) DEC...more >>

Example Source Table A Col 1 Col 2 Col 3 Col 4 01/11/2007 A B 10 01/10/2007 A B 20 01/09/2007 A B 10 01/08/2007 A B 10 01/07/2007 A B 10 01/06/2007 A B 10 Example Results Table B Col 1 Col 2 Col 3 Col 4 01/11/2007 A B 10 01/10/2007 A B 20 01/06/2007 A ...more >>

I working with a web application that calculates a number of formulas. One of the requirements for this app is to commit all the variables that were used to perform the calculations to db. One session can generate anywhere between 1000 and 4000 variables which have to be saved as individual rec...more >>

Hi all, I have a question on how to approach a problem: Suppose you have an application in which the users can keep stock of anything. Every item has is a certain type with certain properties. For example if the user defines 'pc', he would define also the following properties: CPU, Ram...more >>

I use openrowset with stored procedures in query analyzer SELECT * FROM OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','exec myDB.dbo.stp_test1') where fldx = 'some value' this works fine for filtering the resultset of a store procedure. But if the stored procedure con...more >>

I am trying to upgrade SQL Server 2000 to SQL Server 2005 Standard Edition SP2 and am in the process of analyzing the impact on the application in both 80 as well as 90 compatibility modes. I need help regarding solution to a behavioral issue between SQL Server 2000 and 2005 in the context of ...more >>

What is the use of "Regions" in c#? EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

protected System.Data.SqlClient.SqlConnection oConn; Is it the best way or I can write like this: using System.Data.SqlClient; protected SqlConnection oconn; Which is the best way and why? EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

I understand there are certain situations in which the optimizer cannot change the join order of your tables when making a plan, for example if you use the FORCE ORDER hint. What other situations cause this? eg does the WITH NOLOCK hint, or derived tables cause this? Thanks...more >>

Hi! I just can't figure this one out.. I have a SP with the following definition. PROCEDURE dbo.spUpdateNumbersInSerie -- Add the parameters for the stored procedure here @Id int, @StartNumber varchar(20), @StopNumber varchar(20), @Action int AS BEGIN Print @Id END ...more >>

I have a table with ID, datetime and data fields. The datetimes are for every minute without duplicates or gaps. I need to create a report which will tell me if there are any periods of 3 minutes or longer in a single day where the data has been below a certain value and for how long. For exa...more >>

I have SQL server table (RecordedAbsences) with the following structure Empno, StartDate, EndDate, R_Type, Reason This is keyed on Empno and StartDate. I need to import data from an Oracle table (Attendance) with the following structure: Ref, Empno, StartDate, EndDate, R_Type...more >>

I would like to create a type which include constraint on it. I m encounter an error while executing the transact-sql at below Eg. (To ensure the week is between 1 and 52) create type wk7 from smallint add constraint wk7_check (wk7 >= 1 and wk7 <= 52); The system prompt me error and does n...more >>

Hi. I have a dataprovider which gives med data in .xml format based on me calling link like this: http://www.myprovider.com/feed/clientdata.asp?format=xml&clientid=125 How can I trough a Stored Procedure get data from this URL and store it to a local .xml file (on the SQL server)? Furhte...more >>