no idea.....why dont you post CREATE TABLE / INSERT DATA and your expected results as I and others have already asked......not as an...

without set up scripts of r create table / insert data....here is a guess

WITH cte_st

AS (

SELECT

S.GroupID

,...

please post CREATE TABLE and INSERT DATA statements for example data. Then, show the query you have built so far and a sample of the desired output of the final...

select dateadd(dd, datediff(dd, 0, getdate()), 0)

select dateadd(hh,16,dateadd(dd, datediff(dd, 0, getdate()), 0))

gazy007 (7/2/2015)

---

I am not getting any data when I add 2015 and 2016 line as it carries on for 3 minutes and then I cancel the query.

I am not 100%...

DECLARE @filepath VARCHAR(1000)

SET @filepath = 'D:\ArchivedRecordings\From_DEFR4C7K1OP01\2004141507_2004141489_eed88bc8da41c8e458777675.xml '

SELECT REVERSE(LEFT(REVERSE(@filepath),CHARINDEX('\', REVERSE(@filepath), 1) - 1)) as filedetails

karthik82.vk (7/2/2015)

---

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...

seems the answer resides here

http://www.sqlservercentral.com/Forums/Topic1699249-3077-1.aspx

karthik82.vk (7/1/2015)

---

Hi All,

I found the solution...

;WITH cte

AS (

...

why does 20141026 need to be converted 2014-10-21?

do you have any ID column that defines the order of data in your table?

please confirm that is defintely a SQL 2012 version

just a thought......move the "grand total" into the report footer section and not in the detail section.

google will be your friend if you are not sure how to do this...

why dont you just query the original table....or...

J Livingston SQL (6/26/2015)

---

farrukhhameed786 (6/26/2015)

---

Hi

You mean the below table script?

In spread sheet the data and time is separate, yes I want to show it separately. The date and...

farrukhhameed786 (6/26/2015)

---

Hi

You mean the below table script?

In spread sheet the data and time is separate, yes I want to show it separately. The date and time is together...

farrukhhameed786 (6/26/2015)

---

Hi Experts

I want to write a query on hour basis.

My time always starts from 0:00 hrs and end on 24:00 hrs.

1. I want to subtract the data on...