Viewing 15 posts - 751 through 765 (of 2,452 total)
Nallya (5/5/2016)
Its for single record I have 10 million records in table.and space betwwen two values is not fixed .
somewhre its 3 to 10
please see this article that shows how...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2016 at 4:06 am
saroj9958 (5/4/2016)
can I have any Idea for this.Saroj
yes, I am sure you can.
but before this can be easily delivered......can you please provide sample table scripts/insert data/expected results....examples and links...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2016 at 1:33 pm
wwwnlc111 (5/4/2016)
I need to show SQL job execution for last 30 days at what time, this mean I have Date and time.
Now question how I can take Time (hh:mm) for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2016 at 7:53 am
DECLARE @calendardate datetime
SET @calendardate = '20160901'
SELECT fiscal_year = CASE
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 3, 2016 at 1:40 pm
sunil.mvs (5/2/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2016 at 10:13 am
to the OP
you have marked my code as correct but havent posted any comments?
would be interested to know how you are getting on. ??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 1, 2016 at 10:32 am
jasona.work (5/1/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 1, 2016 at 9:15 am
Phil Parkin (4/30/2016)
Then ensure that regular backups are in place.
Then...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 30, 2016 at 9:42 am
Jacob Wilkins (4/29/2016)
J Livingston SQL (4/29/2016)
Jacob...dont seem to get the results expected from your code in comparison to mine.....have I misread your code:
You didn't misread it, but the sample data...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2016 at 3:19 pm
Jacob...dont seem to get the results expected from your code in comparison to mine.....have I misread your code:
-- create some test data
USE tempdb
GO
IF OBJECT_ID('tempdb..tempdata', 'U') IS NOT NULL
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2016 at 2:52 pm
my test script......responses appreciated !
-- create some test data
USE tempdb
GO
IF OBJECT_ID('tempdb..tempdata', 'U') IS NOT NULL
DROP TABLE tempdb..tempdata ;
WITH ctetrans as (
SELECT TOP 5000000
BusName = CHAR(Abs(Checksum(Newid()))...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2016 at 1:19 pm
Jacob Wilkins (4/29/2016)
J Livingston SQL (4/29/2016)
Hi Jacob.....on a larger data set I am getting
A TOP or FETCH clause contains an invalid value.any ideas please?
Ah, most likely you have a NULL...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2016 at 1:09 pm
Hi Jacob.....
on a larger data set I am getting
A TOP or FETCH clause contains an invalid value.
any ideas please?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2016 at 12:41 pm
maybe.....
CREATE table #temp (SysKey int identity(1,1) ,BusName varchar(9) ,BusType varchar(6) ,StartDateKey Datetime ,EndDatekey Datetime)
Insert into #temp (BusName,BusType,StartDateKey,EndDatekey)
Select 'A' ,'AC', '20130401', '20130402' union ALL
Select 'A' ,'AC', '20130403' ,'20130404' union ALL
Select 'A'...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2016 at 2:17 pm
Rod at work (4/28/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 28, 2016 at 8:25 am
Viewing 15 posts - 751 through 765 (of 2,452 total)