Change datestamp in SQL to new format

See also questions close to this topic

• Why does this Sql query shows the possible changes but does not implement it?

  So, I want to change the prefix of my tables and the following command shows the possible changes that will take place which seems alright but does not seem to implement it.

  SELECT Concat('RENAME TABLE ', TABLE_NAME, ' TO fan_', SUBSTRING_INDEX(TABLE_NAME, 'pc_',-1), ';') FROM information_schema.tables WHERE table_name like 'pc_%' and table_schema='testdbhere'

  Moreover, this isn't a writing privilege issue as changing the tables name individually works perfectly from the same user.
• how to get weeklytotal and yesterday record in mysql in one table

  Hi Everyone i am trying to implement query to get weekly and yesterday data in same table, dummy output i have shared below, if yesterday not exist as per employee_id it should we showing 0 also as per my table week start from monday and end at sunday.please help me out how to query this get weekly_total and yesterday record and one table.

  Table name-dailydata-

  Sample data

  employee_id	date	total
  20	2022-04-25	10
  20	2022-04-26	20
  20	2022-04-27	20
  20	2022-04-28	10
  20	2022-04-29	20
  20	2022-04-30	30
  20	2022-04-31	40
  20	2022-05-01	50
  40	2022-04-26	20

  expected output

  employee_id	weekly_total	yesterday_record
  20	200	40
  40	20	0

  mysql query to get weekly data

  select employee_id,sum(total) as week_total from dailydata where date between '2022-04-25' and '2022-05-01'
  
• Procedure to display the Employees of a specific Department

  Create a stored procedure, to display the lastnames as "Name" from the employee table. The requirement is as below: The name of the Procedure : EmployeesDept

  Name of the argument as Input : DeptNo

  Write the code to create the procedure

  Schema

  I wrote the Query like this but i didnt get expected output

  CREATE  PROCEDURE Employeesdept(@Deptno varchar)
  AS
  Begin
  SELECT lastname as name
  from employee
  where workdept= 'D21'
  end
  

  Expected output:

  Name --------------- Pulaski Jefferson Marino Smith Johnson Perez Monteverde Name ---------------
• Tables won't appear as selectable object after creating it

  SELECT *
  FROM EmployeeDemographics
  
  
  Msg 208, Level 16, State 1, Line 2
  
  Invalid object name 'EmployeeDemographics'.
  

  I'm currenlty watching Alex the Analyst's SQL tutorial and everytime I create a table, close, and restart SQL, the table is not found by SQL. When I use a statement such as FROM the table doesn't appear in the list of selectable objects. When I type it manually, the table_name has red lines under it indicating that it's an invalid object name. When I run the code I get the error message above. I tried refreshing the database and the Intellisense to no avail. Let me know if I should post the code for the table and thanks in advanced.
• count how many people who buy the same item at second time and how many people who did not buy the second item at second time (compare to firsttime)

  Here is the question:count how many people who buy the same item at second time and how many people who did not buy the second item at second time (compare to buying_order = 1)

  We have a table:

  id	item	date	buying_order
  1	1	19990101	1
  1	1	19990102	2
  2	1	19990102	1
  2	2	19990101	2
  2	3	19990103	1

  To be more clear, if id 1 buy item 1 on 19990101, that is the first purchased item so the buying_order is 1. Our concern is know how many people buy a specific item at their first time, and how many people re-purchase that specific item at the second time.

  Here are the logic I have tried, but not work

  SELECT a.id FROM (SELECT id FROM table WHERE buying_order = 1) AS a 
  LEFT JOIN table AS b ON a.id = b.id 
  WHERE b.buying_order=2 and a.item = b.item
  

  Expected result:

  item	first_purchase_customer	second_purchase	second_buy_other_item_count
  1	2	1	1

  For item 1, there are two first purchase at order 1, and there is only one customer buy item 1 at order 2.

  NOTE: The order can be higher than 2, such that order = 3,4,..., but we only care the people who buy or not buy the same item at their second purchase.
• Total up transactions

  I am using SQL Server Management Studio v18.

  I have an original transaction that might get adjusted either by amount or by commission%.

  I want a query to total up the transactions based on ID and company and I want to keep the original transaction's TransType.

  I have full understanding on how to aggregate columns but I don't know how to keep the TransType.

  Original table:

  ID	TransType	Amount	Commission	Commission%	Company	Notes
  555	RE	500	125	25%	Company A	Original Transaction
  555	RT	-400	-100	0%	Company A	Adjustment
  666	RA	500	125	25%	Company A	Original Transaction
  666	AD	0	-100	-20%	Company A	Adjustment
  666	RN	200	40	20%	Company B	Original Transaction

  Final result:

  ID	TransType	Amount	Commission	Commission%	Company
  555	RE	100	25	25%	Company A
  666	RA	500	25	5%	Company A
  666	RN	200	40	20%	Company B