Hi J,

The reply I got from the Stackoverflow forum helped me to get the solution but not the answer for my scenario. In the answer I got Tanner has included...

Hi,

I will close and remove this post as this has become a duplicate one.

Answer has been found and hence closing the post.

Hi All,

I found the solution...

;WITH cte

AS (

...

Hi,

Its not working

i tried with the date as 20101020 and time as 0030.. below is the code

declare @i int,@T smallint

select @i = 20101020

Select @T=0030

select dateadd(minute,@T%100,(dateadd(hour,@T/100,

CONVERT (datetime,convert(char(8),@i))

)))

However i am getting the...

Hi,

Its a type mistake... I have updated the data...

I am using sql 2012...

Hi All,

I updated the data to reflect the correct ones

Hi,

The dates and times I posted is just a sample of one record of a candidate. I will have different times for each candidate like what I posted here. The...

Hi,

Your solution works fine..

However I cannot have the myTime < '08:10:00' value always as '08:10:00'.

Is there any workaround for this?

Hi Both,

I just updated the post. its a typo from my end.

I tried LEFT JOIN and FULL JOIN however i am getting only one row.

the category table has a...

Hi All,

I tried changing the length of @tbl_style variable from 1024 to 2000. However i am getting the same error. The @tbl_style variable has to do nothing with the...

Hi Aravind,

Please find the code for dynamic header choosing in Pivot Table

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT ', ' + Parameter AS [text()]

...

Hi Piet,

I have created a dynamic pivot, that will create row headers automatically from the table without predefining them.

My only concern now is joining this pivot table with my tbl_para_data...

Hi Aravind,

Thanks for your help. I have already Figured this out...

Hi,

Please find my code...

SELECT pivottable.[Parameter 1], pivottable.[Parameter 2], pivottable.[Parameter 3]

from

(

SELECT Param_ID, Parameter

from lu_Parameter

) as st

pivot

(

max(Param_ID)

FOR Parameter in ([Parameter 1], [Parameter 2], [Parameter...