Yes I know it, that's why I try to cleansing it, do you have any idea how to do it using TSQL

Please post your table structure and some sample data and what is your desired output

May be this will help you

declare @abc_test as table (

id int ,runs int ,date1 datetime

)

insert into @abc_test ( id ,runs ,date1 )

values

('24','1','2013-12-05 10:00:01.000'),

('24','2','2013-12-05 10:00:02.000'),

('25','1','2013-12-05 10:00:03.000'),

('25','2','2013-12-05 10:00:04.000'),

('25','3','2013-12-05 10:00:06.000'),

('26','1','2013-12-05 10:00:07.000'),

('26','2','2013-12-05...

Once I will test it and let you know

i am not sure what you are doing, anyway here is my contribution hope this will help what you want to do

USE tempdb

GO

IF OBJECT_ID('dbo.T1' ) IS NOT NULL

BEGIN

DROP TABLE dbo.T1

DROP...

Thanks,

Please mark as solution for the posts which gives you a desired result, keep it in mind, my solution is not elegant, since I am using...

might not be the elegant one but it is a solution

WITH SampleData(PERSON, [DT], [HRS], [DOW]) AS

(

SELECT 1234, CAST('03/31/2014' AS DATETIME),...

just a curiosity?

may i know why are you using processing instruction?

for your vb.net code

OMG ,

What a merge statement?

My small suggestion

execute the using part separately and find the low performing area then

analyse the query as per your tables and indexes you...

hi there, it is almost same with Stuart Davies's but the logic is different

my solution is avoid the summation two times the other solution using two times grouping and...

ON T.CT_YEAR in

(

case

.[DBO].[FN_GET_YEAR]

(

CAST

(

C.[YEAR] AS VARCHAR(4)

)

+ '-01-01'

)

when 'L' then 'L'

when 'C' then 'C'

when 'O' then 'O'

else 'N'

end

)

AND T.CH_CODE = C.PROJECTID

...

Well try this one i am not sure what you want do

but to my best

Create a Dos batch file using the following batch script

ECHO :ON ERROR Exit>>"All in...

how about this one

DECLARE @test-2 AS TABLE (Code nvarchar (2),Amt numeric(18, 0))

INSERT INTO @test-2

VALUES

('09',1000), ('09',12000), ('09',1300), ('09',1400), ('09',1500),

('10',2000), ('10',2100), ('10',2200), ('10',2300), ('10',2400), ('10',2500),

...

create a case when expression on the base cte like this

CASE

WHEN t.[DATA] LIKE 'GA%' THEN 1

...

well it's a llittle tricky

DECLARE @User AS TABLE ([UserId] [int] NOT NULL, [Active] [bit] NOT NULL,USerName VARCHAR(10))

DECLARE @UserReporting AS TABLE ([UserId] [int] NOT NULL, [ReportingUserId] [int] NULL)

INSERT...