O srry, because I would like erverthing in seperate column:

dbname | schema | Table/view |

db              dbo            xxxx

That not really the solution, but I have something but not complete:

 SELECT DISTINCT [name] AS SYN_NAME,
  LEFT (REPLACE(REPLACE(base_object_name ,'[',''),']',''),
    CHARINDEX('.', REPLACE(REPLACE(base_object_name ,'[',''),']',''))-1)...

Any help? ?

• This reply was modified 3 years, 5 months ago by  GG_BI_GG.

A, so you are forced to specify it. It is not possible to call all fields without specifying (*) (inside ITEM) and get every column back as you call...

Thanks for the helping answers . Is there a possible way to get it in all colums in table format (So I dont want to get only an specific colum)...

• This reply was modified 4 years, 8 months ago by  GG_BI_GG.
• This reply was modified 4 years, 8 months ago by  GG_BI_GG.

The question is: How can I get to the closest startdaterate with customerdateticket?

I just find out datediff but I dont think you can fixed with MIN/MAX

select datediff(DAY,...

Tnx for the reactions. I will try the reactions and testing it out what will be suit in the solution.

Srry put the wrong group

Product Table look like in the Picture.

I have fix the = sign, but get now the following error. Picture:..

Hi Guys,

Still no anwsers

I just  had make a documentdb in azure cosmosdb but I want still try a monogodb for this project mabye...

Someone with anwsers??