Hi Paul

Very nice and powerful solution! I'm taking my hat off to you!

Anyway I had fife years in my project this ugly bit-masks (but we needed only 64 options). Since...

Hi!

Thank you very much; other people can learn a lesson from you! It is nice to see that somebody really wants help and make his own effort!

It’s almost done! I...

Thanks! Some test data would be perfect!

Greets

Flo

Seems that no sample data are available.

For everybody who wants join the topic

I attempted to create some test data with first investigated requirements... Feel free to correct it 😉

I mapped...

Hi

This may indicate the factor to be optimized. 😉

Is it possible that you provide the CREATE statements of the tables iv40600, iv00101, iv30300 and POP30700?

Best would be some sample data...

Hi

Just for information. How many rows will this return:

Declare CurDepartamento cursor FAST_FORWARD READ_ONLY for

SELECT distinct USCATVLS_3, USCATVLS_2 FROM VW_DET_ALM_POR_TIENDA where uscatnum = 3

The count of rows you handle in...

Hi Tomm

You wrote "merged"... I know this feature is SQL Server 2008; for the sake of completeness.

Hope you allow to palm your sample data!

DECLARE @Result TABLE (Id INT, Name VARCHAR(50),...

Hi David

This is quiet similar to another post:

http://www.sqlservercentral.com/Forums/Topic686470-338-1.aspx

There you can also find a very good solution from Bob Hovious.

Greets

Flo

Hi

Have a look to the windows services. There should be a MSSQLSERVER or a MSSQLEXPRESS. You can start the service and connect to the server.

Greets

Flo

Hi

I think there is an authentication problem. If you have a look to your attached error message you see in last row that your Access application either tries to connect...

Thank your for the feedback!

Greets

Flo

Hi

We also handle Arabic text (and most other languages) within our database. We used NVARCHAR and everything works just fine.

Greets

Flo

JacekO (4/3/2009)

---

Florian Reischl (4/2/2009)

---

David,

What about this:

SELECT *

FROM mytab

WHERE col1 = ISNULL(@col1, col1)

AND col2 = ISNULL(@col2, col2)

...

Hey Paul

Thanks for that!

😎

I wish the developers at my workplace were as SQL-literate. I particularly like...

Hi Bob

Very nice solution with the string-bitmap! 😉

@ J-F

Nice approach over an external file!

My bad, I did not use that for a long time, it got me saying stupid stuff...