Polling Interval

Mar 27, 2007

Hello

I was wondering where I can change the polling interval settings in sql server management studio..

It appears to be different from the one in Enterprise Manager.
very little info can be found on the Internet

Thanks!

Worf

View 3 Replies


ADVERTISEMENT

SQL 2012 :: 15 Minute Interval Report Between Two Dates With Total For Each Interval

Jul 21, 2014

I'm trying to create a report which will give me a break down of how many unique vehicles have been seen between two dates via a 15 minute interval and what Lane they were seen. My current script looks like this

SELECT l.Name [Name], count(l.Name) Total, p.Created
FROM PlateReads p
inner join Lanes l on p.Lane_ID = l.ID
where LicencePlate in (Select Plate from LPRnet_MelAir_C.dbo.TempVehiclePlates)
group by Name
Name being the Lane they were in and the Total being the amount of times a unique vehicle has been seen and p.Created being the date they were seen (thats what I need the interval powered off)

Ideally the output would look like this

16/03/201408:00 to 08:15Bus Lane 15
16/03/201408:00 to 08:15Elevated Road150
16/03/201408:00 to 08:15Public Pickup75

16/03/201408:15 to 08:30Bus Lane 13
16/03/201408:15 to 08:30Elevated Road120
16/03/201408:15 to 08:30Public Pickup55

All the way to 12/04/2014

I’ve got it so it says Lane and Count just can’t get the interval part

View 5 Replies View Related

SqlCacheDependency Without Polling

Jul 20, 2006

I've been having trouble getting the SqlCacheDependency to work without polling (which is set up through SqlCacheDependencyAdmin or aspnet_regsql). If you check out the documentation it says things like:
Microsoft:

View 18 Replies View Related

Polling Of A Database

Jan 7, 2008

 
I  have  a sql server database which is a huge database(let us call as database 1)  and highly secured. I create another database which is small in size (let us call as database 2).  I create tables in database2 which requires input from database1.  In order to achieve this i create views in database2 for the input from database1. Now when ever records are added in database1 view needs to be updated. Now here is tehq query.
1. when ever records is inserted in database1 views needs to be updated in the database2. how can i achieve this ?
2. if the answer is triggers or if are there are any ways to deal with it please let me know
 

View 1 Replies View Related

Polling SQL For Data

Feb 6, 2000

I have an application which needs recently inserted records from SQL Server. SQL Server gets raw data from third party and makes summary out of it. This summary needs to be read from SQL Server whenever it is ready. The application currently polls the DB and gets the data. Instead, Is there a way to get the summary pushed from SQL Server to application. Your help is highly appreciated.

View 2 Replies View Related

Polling In 2005

Dec 19, 2006

Hi folks,

Somebody got an idea about how to implement the following in SQL 2005? Or does anybody know of an example posted somewhere for this? In my opinion it's such a common problem, someone somewhere is bound to have written something about this somewhere (but I could nog find it).

We've got a table in a database and regularly an event happens that inserts a record in this table. At that moment a signal should be given to a .NET-service (in the form of a XML-message) which will do some intelligent stuff with this info.

In SQL 2000 I would implement a polling mechanism that every 10 secs (or some other appropriate interval) would do a select on the table to see if anything had changed. But with all the new features in 2005, I'm of the opinion that this could be done differently.

I've been looking at:
Notification Services, but this looks a bit like overkill for such a simple demand.
Query notifications from the Service Broker. But this is also a bit much because deletes are also a cause for a notification. Also all the articles I found are dealing with cache expiration. (Afterthought... maybe SELECT MAX(id) will work as defined query)


Ofcourse it would be nice if the signal is queued somewhere when the receiving service is temporarily not available.

Thanx in advance,

Lex

View 2 Replies View Related

Polling Changes On A Db, And Copying Changes To Another Db

Apr 3, 2008

Hi all, I'm in the process of cleaning up a very VERY poorly implemented system. One of the problems I'm tackling consists of :

1 - Database A
2 - Database B (different schema than A)
3 - A task which regularly polls A, checks for updated/new records and inserts them (with some transformation) into B

As you can imagine, the overhead of the polling is killing the system. What I want to know is :

What is the best way for A to notify B whenever there are changes to a particular table on A ?

I'm running 2000 but we will most probably upgrade to 2005.

thanks in advance to everybody
Omar

View 13 Replies View Related

Polling A Queue Sitting On Other Server

Nov 29, 2007

Hi,
I want to achieve the following. Please let me know if it is possible or not. If not reasons.

There are 2 servers A and B. Server B has one service and queue available and some data is available in the queue. The data in the queue is online and being received by some other database. Now I want to access the data in the queue in server B from a service which is residing in Server A.

In short I want to continuosly poll the Queue on Server B from Server A. Please let me know whether this is feasible or not.

waiting for your earliest reply.

Thanks,
Balram.

View 7 Replies View Related

Newbie Question: Table Polling And Select Query In A Loop

May 2, 2007

Hi,



I am a newbie in SSIS.

Can anybody please help me in the following.



Here is the task that I want to achieve:



1. continously poll a db table every 1 minute,

if the value of a paticular cell in the table has changed since last poll,

then initiate the second task



2. do a select query that picks about 10,000 new rows off another db table,

the 10,000 rows should then be stored in a in-memory dataset.

Every time the poll initiates a new select query, it should insert the new rows to the existing in-memory dataset.

thus if the select runs for 2 times in 2 minutes, the the in-memory dataset would contain a maximum of 20,000 rows.



3. Then I want to apply a set of transformations on the dataset and then finally update some db tables, push some records to the ssas database. (push mode incremental processing)



which sub tasks can be achieved and which cannot.

if not, Is there a workaround?



Please do provide some specific links that accomplish some of these similar tasks.



I have tested some functionality, like

doing a full processing of a ssas database.

reading from a database table and inserting into a flat file.

I tired to use the ExecuteSQLTask, and i also assigned the resultant to an user:variable. the execution completed succesfully but I am not able to see the value of the variable change. also I am not able to use the variable to figure out a change in previous value and thus initiate a sql select. or use the variable to do anything.





Regards

Vijay R



View 6 Replies View Related

Unable To Connect To SQL Database 'MySite-Cache' For Cache Dependency Polling.

Dec 27, 2007

 Im getting this error when trying to set up a cache dependency...are there any special permissions etc?From CS:SqlCacheDependency dep = new SqlCacheDependency("MySite-Cache", "Products");Cache.Insert("Products", de.GetAllProductsList(), dep); From connectionStrings.config:<add name="SiteDB"         connectionString="Data Source=localhost,[port]SQLEXPRESS;Integrated Security=true;User Instance=true; AttachDBFileName=|DataDirectory|ASPNETDB.MDF" providerName="System.Data.SqlClient" />Also tried this using my machinename<add name="SiteDB"         connectionString="Data
Source=<machinename>,[port]SQLEXPRESS;Integrated Security=true;User
Instance=true; AttachDBFileName=|DataDirectory|ASPNETDB.MDF"
providerName="System.Data.SqlClient" /> From web.config:       <caching>          <sqlCacheDependency enabled="true" pollTime="10000">              <databases>                  <add name="MySite-Cache" connectionStringName="SiteDB" pollTime="2000"/>              </databases>          </sqlCacheDependency>                </caching> EDIT: So making progress I can't seem to get the table registered for cache dependency:The sample i have says"aspnet_regsql.exe -E -S .SqlExpress -d aspnetdb -t Customers -et"and the command line response is "Enabling the table for SQL cache dependency..An error has happened.  Details of the exception:The table 'Customers' cannot be found in the database."Where does this "Customers" table come from? There is obviously not an application specific "Customers" table in aspnetdb I'm confused probably more by the example than anything.... 

View 3 Replies View Related

Calculating Interval

Mar 16, 2006

If two records containing datetime stamps are SELECTed, how can the interval between them be quickly calculated?

View 8 Replies View Related

SQL Interval Count

Feb 1, 2008

Does anybody know what's the best way to do a count with a 1 day interval? This to me seems like the best approach, my data looks like this

work order, analyst, analysis, dateanalyzed

080154705, ZT, Special, 1/31/2008 9:35:00 PM
080154706, ZT, 8260B, 1/31/2008 10:07:00 PM
080154706, ZT, Special, 1/31/2008 10:07:00 PM
080154706, ZT, Special, 1/31/2008 10:39:00 PM
080154706, ZT, Special, 1/31/2008 11:11:00 PM
080154706, ZT Special, 1/31/2008 11:43:00 PM
080165001, ZT, 624, 2/1/2008 4:30:00 AM
080165001, ZT, 624, 2/1/2008 5:02:00 AM
080166901, ZT, 624, 2/1/2008 12:50:00 PM
080166801, ZT, 624, 2/1/2008 2:51:00 PM
080154711, ZT, Special, 2/1/2008 10:39:00 PM
080124711, ZT, Special, 2/1/2008 10:11:00 PM

What I would like is to have my data displayed as follows:


Analysis, myCount, dateanalyzed
Special, 5, 1/31/08
Special, 2, 2/1/08
624, 4, 2/1/08
8260B, 1, 1/31/08

As you can see, I will need to count the number of occurences for analysis for each day, such as Special has 5 and 2 for those two days, we can have difference analysis done each day done. A Union Join will not work because the table is huge and I will need to do at least 30 days. Is interval the best approach, I plan to use Access but can do it in SQL Server if necessary.




View 4 Replies View Related

How To Group By Time Interval

Oct 1, 2007

Hello ,I have a stored procedure that group a series of event by day. My table Tevent has a timestamp column for every event.Tevent structure:idevent| event| DatetimeEvent
I just found out that I need to group the result by production shift of the day , therefore I have to group the result  for everyday from 8 AM until 2 AM the next day.Any idea of how to group by time interval?Thanks

View 4 Replies View Related

Run A SP With A Datetime Interval From A Table

Nov 9, 2007

Hello,
I have something i called a deletelist, inside this list is items that is waiting to be deleted.
The deletelist looks like this:username nvarchar(20),itemtype int,deletedate datetime
The SP that runs once everyday and deletes post is called Data_DeleteFromDeleteList.
Inside of this SP i have afew delete functions like this one:DELETE FROM reg_user WHERE (username = (SELECT username FROM data_deletelist WHERE (deletedate < getdate() AND itemtype = 0)))
Now i want to add a new delete function to this list, this function is to execute a SP when the itemtype occurs, like this:SELECT EXEC [dbo].[Data_CompletlyDeleteAUser] @UserName = username, @QResult = @QResult OUTPUT FROM data_deletelist WHERE (username = (SELECT username FROM data_deletelist WHERE (deletedate < getdate() AND itemtype = 2)))
any idea of how i can rewrite this function so it works??in this SP im not using the @QResult for anything, thats in another SP
At the end of this SP, i just delete all the old records from the deletelist like this,
DELETE FROM data_deletelist WHERE (deletedate < getdate())

View 2 Replies View Related

Scheduling A Job To Execute At A 10 Second Interval

Feb 1, 2001

I have a stored procedure that needs to executed every 10 seconds (either
at a fixed 10 second interval or 10 seconds from the completion of the stored
procedure). I initially assumed that the SQL Server Agent in SQL Server
7 would allow me to schedule a recurring job at this interval but it appears
that the lowest resolution for scheduling recurring jobs is minutes. The
task needs to begin when SQL Server starts and then run repeatedly.

I would appreciate any suggestions for resolving my problem.

Thanks

View 1 Replies View Related

How To Get Sum Of Column Values On Interval

Mar 1, 2015

I am new to this group and to Sql query also. My requirement is the following

I have a table with these values...

colacolb colc cold
16:01 1 2 3
17:01 1 3 4
18:01 5 6 8
16:01 8 2 1
17:01 9 5 1
18:01 3 5 1
16:01 4 6 1
17:01 2 3 5
18:01 8 4 3

Now I want to get the SUM of colb, colc on each interval between 16:01 to 18:01...

View 4 Replies View Related

Interval Data Type

Jan 17, 2007

I'm trying to migration a database from PostgreSQL to SQL Server, but i've found a problem with interval data type, SQL server does not have an interval data type, can someone help me please? I need the solution ASAP due to work deadline =(

View 2 Replies View Related

Group By Time Interval

Mar 5, 2008

Hello,

I'm trying to create a group by a set (but can change it later on) time interval.
What I mean by this is the following. I would like to group my data by 5 second intervals, and perhaps have a count for it as well - but that's not required.

For example I have the following data:

PRODUCT, DOOR, TIME_LOCATED
-------------------------------------
chips, 1, 3/5/2008 12:33:30 PM
harddisk, 1, 3/5/2008 12:33:30 PM
tea, 1, 3/5/2008 12:33:31 PM
software, 1, 3/5/2008 12:33:31 PM
chips, 1, 3/5/2008 12:33:32 PM
chips, 1, 3/5/2008 12:33:33 PM
chips, 2, 3/5/2008 12:33:34 PM
software, 1, 3/5/2008 12:33:40 PM
tea, 1, 3/5/2008 12:33:40 PM
software, 1, 3/5/2008 12:33:41 PM

Result in 5 second intervals (so group by values between 3/5/2008 12:33:30 and 3/5/2008 12:33:35)


Something like this?, or does have somebody a better idea?

PRODUCT, DOOR, TIME_LOCATED, COUNT
-------------------------------------------
harddisk, 1, 3/5/2008 12:33:30 PM 1
tea, 1, 3/5/2008 12:33:31 PM 1
software, 1, 3/5/2008 12:33:31 PM 1
chips, 1, 3/5/2008 12:33:33 PM 3
chips, 2, 3/5/2008 12:33:34 PM 1
software, 1, 3/5/2008 12:33:40 PM 2
tea, 1, 3/5/2008 12:33:40 PM 1

THANKS!

View 6 Replies View Related

Group By Time Interval.

Jul 20, 2005

I have a table(work_order) with time as varchar(5).The values in table looks like thiswork_order_id rtim1 08:152 08:453 10:134 14:56and so on...I want to count how many work orders for every half an hour.The result should look like thisHours Count8 108:30 159 349:30 03and so on....really 8 hours means the work_orders issued (rtim)between 8:00 AND 8:30.Any Help is Appreciated.Thankyou.Jaidev Paruchuri

View 4 Replies View Related

Commit Interval In OLE DB Driver

Jul 2, 2007

Hi,



I am trying to develop a custom destination component. Is there a way to enable transaction / commit interval in OLE DB drivers?



Thanks,

Vipul

View 1 Replies View Related

Interval On A Datetime Column

Feb 13, 2008

Hi, I have a table with 3 columns ( Id int, theValue float , aDate datetime). I want to select the number of rows (count) for which the interval of aDate is less than 7 seconds. Is there a way to achieve that in a single query.

PS: This query will be perform on a dataset, that means that I can't use cursor.


Thanks

Sylvain

View 5 Replies View Related

Convert Datetime Interval

Oct 1, 2007

I am currently using the code below to convert data collected in 1 minute intervals to other time intervals (e.g., 5 minute intervals). The code works fine except for one thing. I would like the DateTime value in the new interval to coincide with the end DateTime value of that interval rather than the ceiling DateTime value (the values of Field1 thru Field4 must be extracted from existing data). The problem occurs when there is no data for a particular 1 minute time period. An example might make this more clear (in this case 1 min data is converted to 5 min data).

'2007-09-30T08:01:00'
'2007-09-30T08:02:00'
'2007-09-30T08:03:00'
'2007-09-30T08:04:00'
'2007-09-30T08:05:00'
Above values are used to create a 5 min interval record with
DateTimeValue for this record (in DestTableName) = '2007-09-30T08:05:00'
That's how it should work. However, missing data causes a problem
in the next 5 min time interval.

'2007-09-30T08:06:00'
'2007-09-30T08:07:00'
'2007-09-30T08:08:00'
'2007-09-30T08:09:00'
Missing value at '2007-09-30T08:10:00'
Above values are used to create a 5 min interval record with
DateTimeValue for this record (in DestTableName) = '2007-09-30T08:09:00'

Instead, I want the DateTime value in DestTableName to be '2007-09-30T08:10:00'

The values in Field1 - Field4 in DestTable have to be drawn from existing data; the only 'artificial' data would be the DateTime time value needed to coincide with the time interval.



USE tempdb;


IF OBJECT_ID('#Data') IS NOT NULL

DROP TABLE #Data;

IF OBJECT_ID('#Grouped') IS NOT NULL

DROP TABLE #Grouped;


DECLARE @dtStart datetime, @dtEnd datetime, @dtDivisor integer;


SET @dtStart = '2007-07-01T08:01:00';

SET @dtEnd = '2007-09-30T16:30:00';

SET @dtDivisor = 5


Select

[DateTime],

[Field1],

[Field2],

[Field3],

[Field4],

CEILING(DATEDIFF(minute,@dtStart,[DateTime])/@dtDivisor) Frame

Into #Data

From

[SourceDbName].[SourceSchemaName].[SourceTableName]

WHERE

(convert(varchar, [DateTime],126) BETWEEN '2007/07/01' AND '2007/09/30') AND

(convert(varchar, [DateTime],114) BETWEEN '08:01:00' AND '16:30:00')

Select

Frame,

MAX(t1.[DateTime]) [Max_DateTime],

MIN(t1.[DateTime]) [Min_DateTime],

MAX(t1.[Field2]) AS [Field2],

MIN(t1.[Field3]) AS [Field3]

Into #Grouped

From

#Data t1

Group By

Frame

Select

Opn.[DateTime],

[Field1],

[Field2],

[Field3],

[Field4]

Into

[DestDbName].[DestSchemaName].[DestTableName]

From

( Select

G.[Frame],

G.[Max_DateTime] as [DateTime],

D.[Field1],

G.[Field2],

G.[Field3]

From

#Data D

Join #Grouped G On D.[DateTime] = G.[Min_DateTime] And D.Frame = G.Frame

) as Opn Join

( Select

G.[Frame],

G.[Max_DateTime] as [DateTime],

D.[Field4]

From

#Data D

Join #Grouped G On D.[DateTime] = G.[Max_DateTime] And D.Frame = G.Frame

) as Cls On Opn.Frame = Opn.Frame And Opn.[DateTime] = Cls.[DateTime]

View 5 Replies View Related

T-SQL (SS2K8) :: Add Job Interval And Time To Script

Mar 18, 2014

I need to add the Job Interval and Time to the following script:

SELECT DISTINCT 'CYP_BI' AS Server,Jobs.Name AS Job_Name, Jobs.description AS Alias,
'Enabled' = CASE (Jobs.enabled)
WHEN 0 THEN 'No'
WHEN 1 THEN 'Yes'
ELSE '??'
END,

[Code] .....

This query contains the job interval and time but when I add it to the first script I can't get my syntax right:

SELECT DISTINCT
'CYP_BI' AS Server,
S.name AS JobName,
S.description AS Alias,
'ScheduleName' = left(ss.name,25),
'Enabled' = CASE (S.enabled)

[Code] .....

View 8 Replies View Related

T-SQL (SS2K8) :: Packing Interval With Priories?

Jul 29, 2015

I'm trying to consolidate time intervals.

It's like the packing date and time intervals tsql challenge from Itzig Ben Gan.But unfortunalty I have to cope with time intervals priories, e.g. if one time interval with a higher prio overlaps a time interval with a lower one something like this:

time interval 1 prio 2: [--------------]

time interval 2 prio 1: [---]

result: [---][---][----]

I can't get this aligned, but my point is that from the 2 intervals above you get one interval result with the classic packing solution but because of the higher priority of interval 2, I should get 3 intervals as a result.

IF OBJECT_ID('dbo.Sessions') IS NOT NULL DROP TABLE dbo.Sessions;
CREATE TABLE dbo.Sessions
(
sessionid INT NOT NULL,
actid INT NOT NULL,
starttime DATETIME2(0) NOT NULL,
endtime DATETIME2(0) NOT NULL,

[code]....

View 2 Replies View Related

Time Interval For Hour And 30 Minutes

Sep 4, 2007

Time Interval for hour and 30 minutes
--------------------------------------------------------------------------------

Hi Everyone

I Have column in sql server databas as "HHMMSS" and data as and i am doing a substring to get values for hours and minutes. since my calculations based on hour interval and 30 minutes interval


for ex: Now i want to show all the transaction done b/w 6 to 7 am or pn.

and for 30 minutes interval i have get the calculation as transactions done b/w 6:00 to 6:30 and 6:30 to 7:00 either it's am or pm. now how i can write my sql statements that calculates hour and 30 minutes intervals
HHMM
-------------
06:43
09:26
09:26
11:58
12:25
18:17
20:45
00:43
00:53
16:47


Thanks
Phani

View 7 Replies View Related

Count Rows In A Date Interval

Jul 20, 2005

I have a problem that I can't quite get started on solving.I have a table of asset statuses. Each time the asset status changes, anew row is inserted into the table.CREATE TABLE dbo.Tbl_EMStatusHistory (EMStatusID int IDENTITY (1, 1) NOT NULL ,EMSessionID int NULL ,AssetID int NOT NULL ,AssetStatus int NOT NULL ,StatusComment varchar (250) NULL ,StatusDate smalldatetime NOT NULL ,InsertUser sysname NOT NULL ,InsertDate smalldatetime NULL ,CONSTRAINT PK_EMStatusHistory PRIMARY KEY NONCLUSTERED(EMStatusID))Here is some sample data:EMStatusID AssetID AssetStatus StatusDate DeviceType4772622624OUT2003-10-05Monitor3810022624IN2003-10-16Monitor4726122624OUT2003-10-25 Monitor3819322624IN2003-11-02 Monitor3917122624RV2004-05-02 MonitorFor asset 22624, the current (most recent) status = RV. Before that, itlastchanged status on 2003-11-02, when it was IN. So it was IN from2003-11-02 to2004-05-02.I need to produce a report that counts the devices by type that were INon a given report date,like so:ReportDateMonitorsTransmitters05/01/2004342605/02/2004373005/03/2004393205/04/20043531The end user supplies the date range.I am unsure how to approach this. I came up with oneEinsteinian-Newtonian method that involved three temp tables, a gardenhose, and a duck, and it was getting uglier by the minute. Has anyonehad experience with a requirement like this? Thanks, Dave"Are you thinking what I'm thinking, Pinky?"*** Sent via Devdex http://www.devdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Oledb Destination Commit Interval

Apr 11, 2007

Hi



How can commit interval for OLE DB destination be set when the data access mode is not "fast load".

What happens in oledb destination in case of a failure in package? How does the roll back happens. I mean how is the commit point set in oledb destination? I know about the transaction options which are at the package level.



Thanks,

Vipul

View 4 Replies View Related

Setting The Timescale Interval To The First Of The Month.

Oct 17, 2007

I have a SSRS report where I am displaying the data for 3 years in a column chart. I am trying to get the x-axis labels to be the first of the month. e.g. using UK date syntax 01/01/07;01/02/07 (1st Feb); 01/03/07 .....

If I check 'numeric or timescale' I get the result I want in 6 month steps when I would like monthly steps. If I use an interval value that does not help as months have different number of days. So an interval of 30 means I end up display 02/03/07 when I want 01/03/07

Can anyone confirm how I can change the label frequency from 6 months to 1 month?

Regards

Leo

View 1 Replies View Related

Reading Data At Specific Interval

Nov 29, 2006

Hello there

I'm having data store in database at interval of 2sec.

hence if i read data for 1 week(7days) it returns me huge amount of data

so what i want to do is to read data at some varying intervals e.g 30 sec or 50 sec for perticular datetime range

Please tell me suitable query to have such selected data base

Thanks in advance

AVD

View 1 Replies View Related

Conflict Table Cleanup Interval

Nov 9, 2006

What replication parameter sets the interval in which data in the conflict tables is deleted in SQL Server 2000 SP4?

View 5 Replies View Related

Maximum Conversation Timer Interval

Apr 27, 2006

I'm using conversation timers successfully to fire events at a predetermined time in the future, but I'm running into issues when using an interval of considerable size. I set the conversation timeout like so:

set @Timeout = DATEDIFF(SECOND, GETDATE(), DATEADD(MINUTE, -(@TimeOffset), @FollowUpDateTime));

if (@Timeout < 0)

set @Timeout = 1;

// begin dialog

begin conversation timer (@FollowUpConversation)

timeout = @Timeout;

In this case @Timeout was 94693494.

In the SQL error log I see the following error: "Invalid subcommand value 94693494. Legal range from 1 to 2147483."

I thought I may check the @Timeout value and simply set it to 2147483 if it is larger than 2147483, but I was wondering if there was a reason the upper limit was so small.

Thanks,

Chris

View 10 Replies View Related

Returning A Count On A Time Stamp Interval

Mar 11, 2008

I have a table (tbl_entries) in my db that has a timestamp field (startDate). What I need to do is run a query that counts the number of records on a 15 min interval.

something like

start_date
2008-01-01 00:00:00.000
2008-01-01 00:00:00.000
2008-01-01 00:00:00.000
2008-01-01 00:01:00.000
2008-01-01 00:01:00.000
2008-01-01 00:01:00.000
2008-01-01 00:14:00.000
EVERY THING ABOVE HERE IS IN GROUP 1
2008-01-01 00:35:00.000
EVERY THING ABOVE HERE IS IN GROUP 2
2008-01-01 01:01:00.000
2008-01-01 01:03:00.000
2008-01-01 01:03:00.000
2008-01-01 01:04:00.000
EVERY THING ABOVE HERE IS IN GROUP 3
2008-01-01 01:29:00.000
EVERY THING ABOVE HERE IS IN GROUP 4
2008-01-01 01:41:00.000
EVERY THING ABOVE HERE IS IN GROUP 5
2008-01-01 02:25:00.000
2008-01-01 02:28:00.000
2008-01-01 02:31:00.000
2008-01-01 02:33:00.000
EVERY THING ABOVE HERE IS IN GROUP 6
Hope this is enough Info

View 3 Replies View Related

Execute Query With Interval Date - Out Of Range Value

May 14, 2015

I have problem to execute query with interval date.

If try this query I don't have problem and the output is correct:

Code:
SELECT * FROM dotable
WHERE
dotableDate BETWEEN CONVERT (datetime, '01/01/2015', 121)
AND CONVERT (datetime, '09/01/2015', 121);

Instead if try this I have error:

Code:
SELECT * FROM dotable
WHERE
dotableDate BETWEEN CONVERT (datetime, '25/01/2015', 121)
AND CONVERT (datetime, '28/01/2015', 121);

[Err] 22007 - [SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved