what it mean by 'expensive' ? Can give some sample ?

here the sql statement

select title,userid,users.name,manager,manager.name managername,hrid,hr.name hrname

from employee inner join users on

userid = users.id inner join users manager on

manager = manager.id inner join users hr on

hrid = hr.id

But beside...

Thanks !!!!!!

id is null is not applicable in this situations because id is always not null values

Thanks for the replied. Is that mean filegroups only useful if I've multiples data files ? For instance sales data files can group to filegroup sales, marketing data files go...

Hi, Would like to ask your opinion, if I create a database for this new team as below, is that mean any database objects created for that database will go...

Thanks dude !!

I think can run on SSMS... not necessary must in cmd mood

I already found the solutions ...thanks

Thanks for the solutions .. now i having a new issues, i try to summarizing data with rollup in order to get the total amount of durations for each employees,...

Thanks a lot !!!

Hi Goldman,

The UDF was used to broken the list into a result set, with each individual letter as its own row. But it still didn't solve the...

it works !! thanks vry much dude 😀

Hi, this is the solution that i managed to come out

-----------------------------------------------------

select City,

Case When Sun = 0 Then 'NA' ELSE MovieNames + '...