Am I wrong but we need to make the assumption that SQL Server ensures some kind of unicity constraints.

Therefore, in case of error, I will need to test the error...

Thank you very much.

I just had a look at some sample and came across the following page: [/url]

If I look at the code sample (4th bullet point), I see:

--Insert Child...

I finally found the solution...

Simply use the following:

SELECT COALESCE(( sqlstatement), 0)

For example

SELECT A.*, Score = 100 * ( SELECT COALESCE( ( SELECT ftt.RANK FROM tbl_description TD INNER JOIN...

Thanks for your reply but the example you gave does not give any score if keywords are present or not and, I would like to weight the results, also by...

I am still there but as an observer 😉

Thanks so much to both of you. It's working perfectly.

Unfortunately, I don't have any control on the database structure, since it is part of an HP product.

As regard your sentence: "then you can use the ROW_NUMBER() function, partitioning by...

Here is the requested script:

USE [TEST_DB]

GO

/****** Object: Table [dbo].[tbl_ASSIGNMENT] Script Date: 05/25/2011 13:42:43 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tbl_ASSIGNMENT](

[PM_NUMBER] [varchar](50) NULL,

[ASSIGNMENT] [varchar](50) NULL,

[TIME_MODIFIED]...

Stefan Krzywicki,

I mean that it will create many records for each reservation. Meaning the database will grow...

GSquared, because I can't find a way of building a SQL statement that would satisfy the following requirement:

I there anything available between date1 and date2.

If I take the following...

I use Julian Dates to obtain an integer value which makes the query faster...

Why would you have any other idea/solution?

In fact I was thinking about something like the following:

see the following table definitions:

CREATE TABLE [dbo].[b]tbl_reservation[/b](

[key_id] [bigint] IDENTITY(1,1) NOT NULL,

[house_id] [bigint] NOT NULL,

[julian_day] [int] NOT NULL,

[status] [tinyint] NOT NULL,

CONSTRAINT...

Thanks a lot for your answer. I switched the data and it now works.

Didier

In fact I did however, since my web site is multi-lingual, I need to provide a means of "phonetic" searching across several languages. Correct me if I am wrong but...

You saved my day...

Here is the modification I needed to apply to the User-Defined function:

CREATE FUNCTION dbo.fct_ListToTable (@list as varchar(8000), @delim as varchar(10))

RETURNS @listTable table (

Valuevarchar(8000) COLLATE...