I must have forgotten to fix the text after copy-paste.

Should be

The above query cannot be a part...

SELECT CONVERT(DATE, DT.[time slot]) date,

CONVERT(VARCHAR(20),DT.[time slot], 108) + '-' + CONVERT(VARCHAR(20),DATEADD(n, 30, DT.[time slot]), 108)

FROM (SELECT dateadd(n, datediff(n,0, GETDATE())/30*30, 0) as [time slot]

) DT

Is it what you're after?

SQLCurious (6/1/2016)

---

When an ampersand is used without any spaces around, say for e.g.

DECLARE @UnparsedString VARCHAR(MAX) = 'This|is|a|short&Sweet|sentence')

I get the following error...

Msg 9411, Level 16, State...

Did you check sp_configure 'user connections'?

jc85 (6/1/2016)

---

Date (start_time)--report_item----EN (lang)---BM (lang)

00:00 - 00:30-----Noisy----------------------3------------- 0

00:00 - 00:30-----No Dial Tone-------------6--------------2

00:30 - 01:00-----Noisy----------------------1--------------2

00:30 - 01:00-----No Dial Tone-------------0------------- 7

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

My query is able to output the result as above but it...

It goes like this:

Declare @StartDate datetime, @EndDate datetime

Set @StartDate = --beginning of the month

Dateadd(mm, datediff(mm,0, @Date), 0)

SET @EndDate = -- end of the month

...

You may take the performance optimisation to the extreme, minimising the number of checks required for "ordinary" logons:

BEGIN

IF ORIGINAL_LOGIN() = '<the restricted user>'

-- if it's not...

jc85 (5/31/2016)

---

WHERE month(b.start_time) = @Loc_Month

AND year(b.start_time) = @Loc_Year

Is there any other way to avoid using function in WHERE clause in this scenario?

It doesn't have huge impact on query speed but...

Jeff Moden (5/30/2016)

---

It's stupid. Even NOTEPAD supports UTF-8 but SQL Server does not until 2016.

https://msdn.microsoft.com/en-us/library/ms188365(v=sql.105).aspx

You can, however, pre-convert the file to UTF-16 to import. Supposedly, the code at...

SQL Server does not understand UTF-8.

Convert the file to UCS-2 and then BULK INSERT will load it correcty.

In the article...

Glad it helped.

Thanks for the feedback.

I'd recommend a clustered index on ann_ReportItem like this:

CREATE NONCLUSTERED INDEX [ix_RItem] ON [dbo].[ann_ReportItem]

(

[report_id] ASC,

[call_flow_name] ASC,

[source] ASC

jc85 (5/29/2016)

---

I have modified the query to execute successfully based on my limited knowledge.

However it did not return correct output, can you advise which part of the query need...

Clustered index must be set up on column(s) used for range selection.

Always.

You select by the range of dates.

So, your clustered...