1730 0
Download and Install SQL Server Management Studio (Step by Step)
In this article, I have mentioned how you can download and install SQL Server management studio (SSMS) in your local pc and how to use SSMS.
Type
Article
1552 0
Import CSV file to MySQL (Query or using Workbench)
In this article, I have mentioned how we can import data from CSV to MySQL using query or using MySQL Workbench import wizard.
Type
Article
1451 0
Delete (Drop) Database in SQL Server
In this article, I have provided step by step procedure to delete or drop database in sql server using SSMS or using drop database using SQL query.
Type
Article
1323 1
I have deleted my database by accidentially in sql server 2017 is there is any way to recover it?

Hi, I have deleted my database by accidentially in sql server 2017 is there is any way to recover it? Thanks.

...
Type
Question
1264 0
Convert Int To String (varchar) in SQL Server
In this article, I have mentioned how we can convert Int to string (varchar) in SQL Server using examples
Type
Article

1255 0
Change theme in SQL Server Management Studio (SSMS, Dark Mode)
In this article, I have mentioned how we can change SQL Server Management Studio (ssms) to dark mode theme, with little changes.
Type
Article
1220 2
How to check if Columns exits in SQL Server table?

Hello, I am still learning SQL and SQL Server, so I would like to know how can I verify or check if a column exists in the database table using SQL Query in SQL Server?

...
Type
Question
1191 0
SUM and JOIN 2 columns with different tables but do not SUM Qty

Good day!

Need help to SUM and JOIN 2 columns with different tables but do no want to SUM qty and duplicates row result

here's the sample data tables;

 

Transfer Shipment table;

TransTO - TransFROM -  ItemNo   -   Desc   -   Desc2   -   VariantCode   -   Qty

Location1      HO                Item01         Active      Black         Variant01             5           <------ Delivery

Location1      HO                 Item01         Active      Black        Variant01             5           <------ Delivery

HO                Location1       Item01         Active     Black        Variant01             2          <------ Pull-out

HO                Location1       Item01         Active      Black       Variant01             1            <------ Pull-out

 

Sales Entry table;

Loc Code   -   Item No   -   Variant Code   -   Qty

Location1       Item01          Variant01            -1       <------ PSales

Location1       Item01          Variant01            -1       <------ PSales

 

Item Entry table;

Loc Code   -   Item No   -   Desc   -   Desc2- VariantCode-   Qty - EntryType  - DocNo

Location1       Item01         Active     Black         Variant01      4         2           ItemAdj0001   <------ PAdj

Location1       Item01         Active     Black         Variant01      1          2           StrAdj0001       <------ PAdj

Location1       Item01         Active     Black         Variant01     -1          1           MSales0001     <------ MSales

Location1       Item01         Active     Black         Variant01     -1           1           MSales0002     <------ MSales

Location1       Item01         Active     Black         Variant01     -1          3           LocAdj0005      <------ NAdj

Location1       Item01         Active     Black         Variant01     -1          3           BtqAdj0008      <------ NAdj

 

SUM and JOIN (the sql query result should be like this)

Loc Code  - Item No - Desc  - Desc2 -VarCode- Delivery -PAdj- Pull-out - PSales - MSales - NAdj  -  Total

Location1    Item01   Active    Black   Variant01     10            5           3             -2             -2         -2            6

 

here's my sql query code;

...
Type
Question
1150 0
How to update table variable in stored procedure from another user defined function in sql?

Scenario : User defined function return one table. If that table contains at least one row,one column in the table variable from another sp should get updated.

Should I use cross join on UDF to update table variable?

sql

...
Type
Question
1095 0
Extract String after a character or before character in SQL Server
In this article, i have mentioned how we can Extract String after a character or before character in SQL Server with examples
Type
Article

Page 9 of 11