We will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide the DDL (create table) script,...

Quick advice, don't post data as an Excel spreadsheet unless the question is not a database question but a question about Excel!

😎

I'll show you how to post sample data, unfortunately,...

Quick question, can you tell us a tiny bit more about the setup?

😎

Useful information would be something like VMs, managed server instances or managed DB instances!

My guess, by the way,...

Expanding on Phil's good point, we will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide...

Quick question, have you looked at Amazon CloudWatch metrics for Amazon EBS and EventBridge for Amazon EBS?

😎

A quick word of advice; regardless of good intentions, never ever "explore" anyone else's systems without the owner's consent and preferably a GOOJL, Get Out Of Jail Letter, signed by...

Then why not a table with Hotel, "from...

I do...

Could you please tell us a little bit more about your setup?

😎

There are many ways of doing this, each of which is applicable in certain circumstances. Not knowing those will...

Hi,

I have two columns in table1 i.e. hotel1 and hotel1 . Both of them have foreign key of second table2 hotels.

i.e. Table 1 (Book)

hotel1      hotel2

1     ...

I really miss high quality pens and paper notepads 😉

😎

Quick question, is this a managed DB instance or a VM instance?

😎

In my stored procedure, I have something like

WHERE W.Warehouse=@WH1

It works well when it is simple as

EXEC dbo.MyProcedure @WH1='S0'

I need to select multiple warehouses. ...

We will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide the DDL (create table) script,...

Here is an example and a link to a thread that should help you get passed this hurdle.

😎

USE TEEST;
GO
--https://www.sqlservercentral.com/Forums/2003814/how-to-update-xml-data-in-sql-server
/* Create a table (variable) */
DECLARE @XMLUPDATE TABLE
(
 ...