It's working

Adelia, what are you're struggling with?

You've been given a function which gives you all the right numbers, all you need is to incorporate those numbers into a string of...

Calculate the minutes and seconds the same way you did the years, months and days - using DATEDIFF.  Formatting of the type you describe is best done in the...

Hi Sergiy,

Just created your Tally Generator. Consider this,

DECLARE @date1 datetime, @currentDate1 datetime
SET @date1 = '8/26/2019 06:23:45 PM'
Set @currentDate1...

Thanks to all of you

SQL Server doesn't store, and thus doesn't know, the "last accessed date" for each db.

After SQL starts, when any index is accessed, an entry for that db and index...

The SQL would look like the following... 😀

   WITH ctePreAgg AS
(--==== Pre-aggregate the relevant columns to make display easier.
 SELECT  DBName  ...

Both of you is correct. I'm wrong giving an output of explanation

Sorry. PST row become column

Hi Lowell,

I execute as follow

insert into [dbo].[master_profile]([profile_name], [profile_ic_no])
select [NAMA], [NOKP_NEW] 
from [dbo].[EMPMAS_DATA]

insert into [dbo].[master_individual]([profile_id], [identification_no])
select 
  MyLookup.profile_ic_no, 
  MySource.[NOKP_NEW] 
from [dbo].[EMPMAS_DATA] MySource
INNER JOIN [dbo].[master_profile] MyLookup...

Hye all,

My below T-SQL is that accurate calculation?

SELECT  
get_customeVal_3 = ISNULL( SUM( CASE WHEN year_num = 2015 AND chart_code <> '36101' AND chart_code <> '39102' AND...

SELECT 
 [WeightDte],
 [WhatWeight],
 LEAD([WhatWeight],1) OVER (
 
 ORDER BY [WeightDte] desc
 ) LastWeight
FROM 
 [dbo].[WeightStory]
 Order by [WeightDte] desc


WeightDteWhatWeightLastWeight
-----------------------------------------------------
2019-10-17 08:00:00.00097.90098.600
2019-10-16 06:57:00.00098.60098.400
2019-10-15 07:58:00.00098.40099.500
2019-10-14 16:00:00.00099.50099.200
2019-10-12 11:00:00.00099.200NULL

Yippieeeeeeeeee. Thanks John...

• This reply was modified 5 years, 2 months ago by  Adelia.

Hello John,

SELECT 
 [WeightDte],
 [WhatWeight],
 LEAD([WhatWeight],1) OVER (
 PARTITION BY WhatWeight
 ORDER BY [WeightDte] desc
 ) LastWeight
FROM 
 [dbo].[WeightStory]
 Order by [WeightDte] desc


WeightDteWhatWeightLastWeight
--------------------------------------------------------
2019-10-17 08:00:00.00097.900NULL
2019-10-16 06:57:00.00098.600NULL
2019-10-15 07:58:00.00098.400NULL
2019-10-14 16:00:00.00099.500NULL
2019-10-12...

Your writing is valuable. Thanks