Jacek Wojnar

Good point Daniel. I forgot about it. Thanks :-)

Hello, first, use this formatting: MM/dd/yyyy secondly, the numbers must probably have leading zeros Regards

yes, sure :-) add this condition: WHERE DATEPART(dw,DateData) NOT IN (1,7)

Hi Bartek, thanks! It still workaround but nice to know that :-)

ad. 2 - if your service is in safe mode, try update the license information and restarting the service.

Hi Raluca, have you tried restarting the webcon serivce and do you have this option checked?

Interesting... I have no error in the third/next step (even if I have nothing to choose and the previous choice is remembered). Maybe it's a version issue (I checked on 2023.1.2.99)

Hi Mark, I'm afraid that the 2d code contains the element ID but not the hyperlink. but I may be wrong...

Hi Daniel, I just tested it - it looks ok :-) 1. choice at the first step 2. step two - after entering (no change or error) 3. step two - when trying to change 4. configuration

hi, yes, it's possible :-) step IDs marked on the screen

I Attached steps how I did it, and query: WITH DateRange(DateData) AS ( SELECT CAST('2015-01-01' as date) as Date UNION ALL SELECT DATEADD(d,1,DateData) FROM DateRange WHERE DateData < CAST('2015-01-12' as date) ) SELECT DateData FROM DateRange What version

what error do you have?

yes - function may be a better solution but sometimes it is not possible to modify/add anything to the database :/

I'm sorry, I forgot. Here's a little workaround ;) you have to first add a query, e.g. "SELECT NULL as datedata", next configure column mapping and save configuration. Then you can replace the query and it works (you just have to cancel the warning)

I have something like this and it works :-)

thanks Daniel - nice trick :-) Unfortunately, I need to copy it to SSMS more often (I know, I can use notepad++, but it would be easier if these empty lines simply did not exist ;))

Hi, I know it's a workaround but you can make a global constant :-)

ad 1. thanks - so there is hope :-) ad 2. I always have this problem when copying from the expression preview (1). When I copy from the editor it's OK (2)

Hi, I would have two ideas/requests (probably simple) regarding the SQL editor 1. The SQL query editor should have a monospace font 2. The SQL query after copying to SMSS/notepad has unnecessary newlines. Is it possible not to add newlines? regards

Is it possible that the window in Designer Studio for adding/edit user group has a flexible [Users] field and a locked [Group owners] field size. The opposite of now. There are usually more users than owners ;) Additionally it would be good if the users were also sorted alphabetically. Regard