I have three Tables which I want to Join . I wrote down the Inner Join Query...

I have two tables named order and order_line...orderline is related to order by orderid.Calculates the sum of...

I have a table with employees. I'd like to display the email for all records horizontally placing...

Thanks for the quick replies, i thought my question was pretty clear - the COALESCE and...

Hello SQL guru's

i have an order by statement like so:

ORDER BY
Suppliers.Descr,
ItemGroups.Descr,
Items.Descr,
Sum(TOTALINV.NGUQOH),
ITEMS.UNITCOST,
Items.SupplierPartNumber,

which returns the expected rows
if i...

create table #testing(
[order] nvarchar(100),
country nvarchar(100),
colour nvarchar(100),
amount int
)

insert into #testing
values('testingOrder1','UK','red',10),
('testingOrder1','UK','red',20),
('testingOrder1','UK','red',30),
('testingOrder2','US','blue',50),
('testingOrder2','US','green',50)

select * from #testing

how can i count distinct partition...

I want create a Function as follow,

CREATE function [dbo].[GetSmsId]()
returns INT as
BEGIN
  
---- Create the variables...