Viewing 15 posts - 1,186 through 1,200 (of 2,452 total)
farrukhhameed786 (7/4/2015)
Hi Sean/ LuisWhat's the final solution ?
no idea.....why dont you post CREATE TABLE / INSERT DATA and your expected results as I and others have already asked......not as an...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2015 at 12:49 pm
without set up scripts of r create table / insert data....here is a guess
WITH cte_st
AS (
SELECT
S.GroupID
,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2015 at 12:40 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2015 at 11:01 am
select dateadd(dd, datediff(dd, 0, getdate()), 0)
select dateadd(hh,16,dateadd(dd, datediff(dd, 0, getdate()), 0))
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2015 at 5:25 am
gazy007 (7/2/2015)
I am not 100%...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2015 at 1:20 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2015 at 12:15 pm
karthik82.vk (7/2/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2015 at 11:14 am
Lynn Pettis (7/1/2015)
Forum etiquette would have you post the answer to your question as it may help others with a similar problem.
seems the answer resides here
http://www.sqlservercentral.com/Forums/Topic1699249-3077-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2015 at 11:27 am
karthik82.vk (7/1/2015)
I found the solution...
;WITH cte
AS (
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2015 at 10:18 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2015 at 5:30 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2015 at 1:49 am
I have a table that writes daily sales each night but it adds the day's sales to the cumulative total for the month
why dont you just query the original table....or...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 29, 2015 at 9:29 am
J Livingston SQL (6/26/2015)
farrukhhameed786 (6/26/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2015 at 11:04 am
farrukhhameed786 (6/26/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2015 at 9:51 am
farrukhhameed786 (6/26/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 26, 2015 at 8:53 am
Viewing 15 posts - 1,186 through 1,200 (of 2,452 total)