Yes, I was trying to get a head count by date.

I will use the calendar table and try this.

Appreciate your help.

Thank you very much Luis.

Multiple races are allowed to help identify individuals of many races - for e.g., dad could be one race and mom could be another.

Thanks

Thank you Lucky for your prompt reply. I have now started the SQL Server agent - however, when i schedule for it to backup, it just does not do...

This gives me 6 rows altogether - I need to be able to select 6 cons_id for each emp_id..Any ideas?

Thank You for your quick reply Remi. I did exactly what you said. But was not very sure on how 'to make sure that it registers in the trace'. I...

How do I 'start a trace' and go back to it?

Please advise.

Thanks

I don't think soundex will work - if the first names are the same but last names are different soundex will still consider it a match, am i right?

Can some...

Am aware of the design concerns - The license table is coming from an external source - am trying to get a list of members in my database that are...

set nocount on

create table #temp

(product_id int not null,

 prod_desc char(1) null)

insert into #temp

select 1, 'A'

insert into #temp

select 1, 'B'

insert into #temp

select...

I was able to get option 2 to work. However, what Remi suggested brings only one line of output - Farrell's method works without a glitch. How is the efficiency...

I tried the second method suggested - this pulls all the descriptions - however, has it in the reverse order - C,B,A instead of A, B, C - any ideas?...

I tried the first script as below - picks only one description - am I missing something?

CREATE FUNCTION  dbo.concatdesc(@product_id INT)

RETURNS VARCHAR(8000)

AS

BEGIN

 DECLARE @Output VARCHAR(8000)

 SET @Output = ''

 SELECT @Output...

I was installing MS SQL Server 2000 Standard Edition on Win 2003 Server- ignored the error message and proceeded - did not have a problem. The Microsoft Site does say...

Thank you both - I have SQL Server loaded locally on my machine - to get some work done before the server arrived and was just a stop gap option....