Posts

How to write an email for last day in office

  Subject: Farewell and Thank You Dear [colleagues], As my last day in the office approaches, I wanted to take a moment to express my gratitude for the time we have spent working together. It has been an honor to be a part of such a dedicated and talented team, and I have learned so much during my time here. I have cherished the opportunity to collaborate with each and every one of you, and I am grateful for the friendships that have been formed. Your guidance and support have been invaluable, and I will always remember the positive impact that this organization and each of you have had on my professional development. I want to thank you for your hard work and dedication, and for making this an enjoyable and fulfilling experience. I wish you all the best in your future endeavors and hope to stay in touch. Please do not hesitate to reach out to me in the future. Sincerely, [Your Name] ---------------------------------------------------------------------------------------------------...
Post a Comment
Read more

How to get .jasper file from .jrxml file in Jasper studio?

Image
 Step 1: Design the report  step2: Click on the highlighted button in Jasper Studio Step 3: Cl ick on YT Link for more info
Post a Comment
Read more

How to add image in jasper Report

Image
 Create a jasper report. Drag the image element in details band Click on image expression and add the image location like  "images/PXL_20221230_123635512.jpg" Run the report click on YT Link for more info.
Post a Comment
Read more

Create table in way schema table orders

Image
 Create Table way.orders ( Order_num int, order_date date, Customer_id int, Rep int, MFR varchar(15), Product varchar(15), qty int, Amount money primary key (Order_num) )
Post a Comment
Read more

Insert command into Products in SQL Server

Image
 USE [SqlKiPathashala] GO INSERT INTO [dbo].[Products]            ([MFR_ID]            ,[Product_id]            ,[Describtion]            ,[price]            ,[QTY_IN_HAND])      VALUES            ('REI'            ,1            ,'Ratchet link'            ,579            ,210) GO
Post a Comment
Read more

Write a query to create a table in new Schema?

Image
 Step 1: Create A Schema use SqlKiPathashala Create Schema Way; Step 2: CREATE TABLE Way.Products ( MFR_ID varchar(15), Product_id int not null, Describtion text, price money, QTY_IN_HAND int Primary Key (Product_id))
Post a Comment
Read more

Write a query to practice in Northwind database

  1. WAQ to display average price for all beverages products?   select AVG(isnull(p.unitprice,0)) as "avg product price" from dbo.Products P           join dbo.Suppliers s on s.SupplierID=P.SupplierID   join dbo.Categories c on c.CategoryID=p.CategoryID   where CategoryName='Beverages' 2. WAQ to display unique titles in the employee table?         SELECT distinct e.Title  FROM [dbo].[Employees] AS  e 3. WAQ to display Total Sales for each customer in October 1996 (based on OrderDate).       Show the result in CustomerID, CompanyName, and total sales, sorted in total sales in Decending order      select * from [dbo].[Customers] where CustomerID='SPLIR' select * from [dbo].[Orders] where CustomerID='SPLIR' select * from [dbo].[Order Details] where orderID in ( select orderID from [dbo].[Orders] where CustomerID='SPLIR') select cm.CustomerID,cm.Compan...
Post a Comment
Read more