Can you post the DDL of the table involved and some sample data?

Hi,

What is the error message that you receive from this?  I have tried using the cursor with the following and have not managed to recreate the problem...

DECLARE @count

I believe that you can detach the MSDE database file and attach it to the SQL Server 2000 installation...

Check out:  http://support.microsoft.com/kb/325023

Find "detach...

Hi,

This is what I believe are causing one of your errors:

is_dup is not in your DECLARE @TEMP_duplicates TABLE statement

As for the...

You say you have a working query which you then want to JOIN another table and add a WHERE clause... Could you store the results of the initial query in...

Here goes, two feet first straight in to the unknown!!!

Try using a derived table subquery like this:

SELECT     ISNULL(COUNT(derivedCustomers_Trade.TradeCustomerID), 0) AS PCCount,

           dbo.UkPostcodes.Postcode,...

Can you post the SQL for the stored procedure in question, and it's calling procedure?

That'll help us to help you.

Paul,

You could try using CHARINDEX (take a look in BOL) like this:

SELECT myCol FROM myTable WHERE CHARINDEX( ' ', myCol, 1 ) > 0

There is a space in between...

Okay, I think I've got it... Try this as your derived table:

(select

  sec_prod_group,

  p.date_start,

  qty_sold

 from

  depot_items i 

  LEFT join depot_pos_item_sum p

         on i.idx_item = p.idx_item

 where sec_prod_group in ( 'Metal', 'Blue' )

) ...

I don't think that this is possible, although depending on the complexity of the UDF, you might be able to use a computed column.

I'm a bit confused as to why you would want a dynamic caption, if you could explain more about the problem, there may be a better way around it...

Can you post the DDL (data definition language) of the tables used, ie the CREATE statements? Only include the columns necessary if there's any issues with exposure. Also some example data...

Hi, you'll need to post the DDL (data definition language) of your table and be a bit more specific about your problem...

Are you...

I've replied to your post in the other thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=337136

Please try to post each problem in only one thread...

I don't if this is the quickest way, but it's how I do it (!!)...

1. Open Enterprise Manager and expand the group, server etc.

2. Right-click on Data Transformation Services.

3. Click...