Configuring SSRS to work in a Cluster
I have set up a cluster with two nodes and have installed SQL in the cluster which is working as
…I have set up a cluster with two nodes and have installed SQL in the cluster which is working as
…How to merge 2 columns namely First Name and Company name such that I want to be displayed in the
…SQL passwords hashed
When I am in SSMS and I create a new login and I enter a password, is that
…This version works:
ALTER LOGIN Billy
 WITH PASSWORD = 'Password99!';
  
This version does not:
 DECLARE
HI Everyone
I would like to be able to loop through a set of records and if a value exists (either Y
…Going to try and explain this one the best I can.
 Label
 Casablanca_Records
Mercury_Records
…How do I write a query in SQL Server to return all months between two datetime fields?
Example:
Start
…Hi
I would like some help on how to write my query in SQL. The examples I have given are based on a
…SELECT
    column_name,
    data_type
 FROM
    information_schema.columns
 WHERE
    table_name = 'trjtud_rec';
MS SQL database restore
Hi Experts,
I am trying to get the count of hours between a given date/time field and 12 midnight.
The
…Hello Experts, I need to write a cursor and a recursive CTE in SQL. I'm using Snowflake.
Here's
…Accession Question.docxThe accession Code below may or may not have a following code for a patient.
…I have a spreadsheet that I need to import into a SQL table. One of the fields is DOCNUMBR.
In the
…Hello Experts, I have the following table:
| ID | PLACE_OF_SRVC | SRVC_CATGY | CATEGORY | PROC_CD | SEQ | 
| A241880451 | Home | 
iSeries: When I add a FOR EACH ROW … UPDATE timestamp column to a table, does that column get
…Trying to use VS2022 for database schema comparison.
 Installed [Data storage and processing]
 With all
Dear experts,
Just to a give a brief background:
Current status:
I have sort of understood python
…Hello, everyone.
SQL Server 2019
1 database
7 tables.
(In case it is needed, I am developing this under
…Hi all,
I have a requirement where I need to pull all Azure SQL Servers and Databases, and return
…