Viewing 15 posts - 1,561 through 1,575 (of 2,038 total)
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...
April 4, 2009 at 4:49 am
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...
April 4, 2009 at 4:33 am
Thanks! Some test data would be perfect!
Greets
Flo
April 3, 2009 at 3:27 pm
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...
April 3, 2009 at 2:35 pm
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...
April 3, 2009 at 1:27 pm
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...
April 3, 2009 at 1:14 pm
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),...
April 3, 2009 at 12:59 pm
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
April 3, 2009 at 12:36 pm
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
April 3, 2009 at 12:13 pm
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...
April 3, 2009 at 12:11 pm
Thank your for the feedback!
Greets
Flo
April 3, 2009 at 11:21 am
Hi
We also handle Arabic text (and most other languages) within our database. We used NVARCHAR and everything works just fine.
Greets
Flo
April 3, 2009 at 9:57 am
JacekO (4/3/2009)
Florian Reischl (4/2/2009)
What about this:
SELECT *
FROM mytab
WHERE col1 = ISNULL(@col1, col1)
AND col2 = ISNULL(@col2, col2)
...
April 3, 2009 at 9:34 am
Hey Paul
Paul White (4/3/2009)
Flo,Awesome script - nice job!
Thanks for that!
That's some neat SQL for a 'developer' π
π
I wish the developers at my workplace were as SQL-literate. I particularly like...
April 3, 2009 at 9:27 am
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...
April 3, 2009 at 8:38 am
Viewing 15 posts - 1,561 through 1,575 (of 2,038 total)