Dear Boles,
Yes, windows have some AWESOME  function. but my Production OS is windows 2008 and SQL server 2008R2.
I tried it but get an error.
and bound function is...

Dear Boles,
My query works fine and served their purpose till now. but now they need more requirements:
First Requirement:
this is a SMS text quiz program. winner select as...

Last 2 column of figure-1, 2
is EndDate and EndTime

Dear Eirikur Eiriksson
Here I attached a zipped file.
SQL script  with data.

Dear twin.devil

I already changed. and yes it works.

Thanks a lot.

CREATE TABLE [dbo].[tbl_traffic](

[transactionID] [uniqueidentifier] NULL,

[Date] [date] NOT NULL,

[hour] [varchar](50) NOT NULL,

[status] [varchar](100) NOT NULL,

[count] [int] NULL,

[lastupdate] [datetime] NULL,

CONSTRAINT [PK_tbl_traffic] PRIMARY KEY CLUSTERED

(

[Date] ASC,

[hour] ASC,

[status] ASC

)WITH (PAD_INDEX =...

CREATE TABLE [dbo].[tbl_traffic](

[transactionID] [uniqueidentifier] NULL,

[Date] [date] NOT NULL,

[hour] [varchar](50) NOT NULL,

[status] [varchar](100) NOT NULL,

[count] [int] NULL,

[lastupdate] [datetime] NULL,

CONSTRAINT [PK_tbl_traffic] PRIMARY KEY CLUSTERED

(

[Date] ASC,

[hour] ASC,

[status] ASC

)WITH (PAD_INDEX =...

Table 1

CREATE TABLE [dbo].[tbl_OutBox_Charging](

[TRAN_ID] [uniqueidentifier] NOT NULL,

[OUT_MSG_ID] [bigint] NOT NULL,

[IN_TRAN_ID] [varchar](36) NOT NULL,

[END_USER_ID] [varchar](18) NOT NULL,

[ON_BEHALF_OF] [varchar](15) NOT NULL,

[REFERENCE_CODE] [varchar](10) NOT NULL,

[TRANSACTION_OPERATION_STATUS] [varchar](7) NOT NULL,

[AMOUNT] [varchar](6) NOT NULL,

[CURRENCY] [varchar](6) NOT...

Thanks for your reply and effort. but my asking is not as your scripts. please PM me your email. I will give you my job history image. i can't upload...

Dear Lowell,

yes, I just learned and made a CLR procedure but how CLR procedure reads that web side? would you please show some code/example which read the web page.

another asking...

dear Grant Fritchey,

thank you 4 your prompt reply. i found the issue what i mention in my query. when my server was 2000 and i was creating jobs and define...

Dear SSC Journeyman

thank you for your quick response.

i actually want to show a report which will publish in facebook

the main application is deal with SMS quiz competition and all...

Dear Experts Please Help.

solve this issue