thanks everyone for the suggestions

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments .Its a default instance and the only...

After all that coaching...

Have a look at my second post in this thread, for example.

https://www.sqlservercentral.com/forums/topic/sql-server-count-query

• This reply was modified 1 years, 5 months ago by Phil Parkin.

>6,000 points and can't be bothered giving us consumable data?

Eirikur, many thanks for the offer.

Excellent timing on your part, by the way, as I solved my...

Would anyone be prepared to help me with a few (seemingly) simple DAX questions?

I've been reading up and searching for answers, but can't seem to find the right way to...

I build and maintain databases using VS projects, but have configured VS to open .SQL files in SSMS – so a combination of the two.

I agree 100%. It has the...

Check out the SQL Server Agent/Operators node in SSMS and it should help answer your question.

To add to the response above, note that it's always a good idea to explicitly state your question(s), rather than expecting readers to go into detective mode as they try...

A formatted version of the OP's query:

SELECT service_form_name = selected_sfs.sfName
      ,age = c.agingDays
      ,documents.document_id
   ...

Calling Excel from SSIS is possible, though it requires Excel to be installed on the server next to where SSIS is running and I would not encourage that.

I cannot think...

Dear Friends,

Would be grateful if anybody can advise why one of my servers, doesnt allow a connection anymore from SSMS on my terminal. The IP address is the unchanged....

I wanted to test this, but after running the two 2022 installation files (from here), the PQ connector did not appear for me in VS2022. Can't see anything which...

The image you have posted is of an OLEDB Destination.

What does your source look like? Does it have output columns?