right but now that the name is wchar... take your sample cube and pull it into excel.

Try to sort the user count.

Now imagine several records where they are the same...

2008R2 RTM

If you set the type property of the Name column of a dimension to integer you don't get a big red error?

http://www.cryptoknight.org/img/SSAS_Dimension_Error.jpg

Blah my website is misbehaving... :/

In the DSV user_count has a datatype of smallint System.Int16

When I change the DataType on the User Count attribute NameColumn property from Wchar to SmallInt I get a red squiggly...

And you are of course correct.

I'm still a little upset that

'1234567890%' is not like '1234567890 '

though come to think of it... in the opposite order it...

Hi Michael, this would work except that I'm passing...

DDL is as follows

CREATE TABLE [Agn_Info](

[ai_agn_seq] [int] NOT NULL,

[ai_type] [int] NULL,

[Ai_Name] [varchar](35) NULL,

[Ai_cust_id] [char](7) NULL,

[Ai_mac_id] [char](8) NULL,

[ai_doris_id] [char](8) NULL,

[ai_ts_id] [varchar](12) NULL,

[ai_lic_id] [varchar](12) NULL,

[Ai_attn] [varchar](35) NULL,

[Ai_Street1] [varchar](35) NULL,

[Ai_Street2] [varchar](35) NULL,

[Ai_City] [varchar](20)...

Derrick Smith (10/4/2010)

---

Ok, did some more research/testing and I see an issue now.

Out of curiosity..you set the phone number as:

SET @Phone =...

It shouldn't matter... I've got at least 2 dozen other search queries that do that exact thing.

However, I swapped them out for @xVARIABLE

same issue...

I've decided I hate the actual dynamic...

Not getting an error...

If I was... I could track it down.

Not getting any records back when I pass in a phone number I know should return them.

In this case we're talking about what is a massive catch-all query.

The trick here is to build different execution plans for each pattern of query generated, not a specific plan...

I'm trying to use parameterized dynamic SQL.

i.e.

http://www.sommarskog.se/dyn-search-2005.html

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Not using Parameterized Dynamic SQL is just plain bad.

using

SET @WHERE = @WHERE + N' AND (REPLACE(LocalPhone,''-'','''') LIKE '''+@Phone + '%'' OR REPLACE(SecondPhone,''-'','''') LIKE '''+@Phone...

Thanks... if you have line comments you'll also probably want to replace the N' ' with

N' ' + nchar(10) + nchar(13)

That way each line gets put onto its own...

Try something like this

DECLARE @cmd nvarchar(max)

SELECT

@cmd = COALESCE(@cmd + N' ' + [sqlrow],[sqlrow])

FROM

table_with_sql_in_it

ORDER BY

lineorderfield

EXEC sp_executesql @cmd

If the parameters are optional... dynamic SQL is your best bet.

http://www.sommarskog.se/dyn-search-2005.html

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

I've done this with SQL 2000, of course it's much easier with SQL2005+ because you can using nvarchar(max) to hold...

Those are interesting table names.

Please post the actual update statement... sometimes there are parts of it you don't suspect that actually cause the issue.

Generifying the query doesn't help us help...