Viewing 15 posts - 421 through 435 (of 5,103 total)
if object_id('tempdb..#t1') is not null
drop table #t1
create table #t1 (SKU# char(5), [Description] varchar(200), SalesDate datetime)
Insert into #t1 ([SKU#], [Description], SalesDate) Values('01110', 'Red Car with stripe', '01/19/2009')
Insert...
February 24, 2009 at 3:56 pm
JeffJ (2/24/2009)
Here they are:)
CREATE FUNCTION [Perf].[udf_GenerateTimeSeries](
@periodStart SMALLDATETIME,
@periodEnd SMALLDATETIME,
@interval VARCHAR(2)
)
RETURNS @tbl TABLE
(
ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Begin_Date SMALLDATETIME,
End_Date SMALLDATETIME
)
AS
BEGIN
DECLARE @start SMALLDATETIME,
@end SMALLDATETIME
IF @interval ='d'
BEGIN
INSERT INTO @tbl
SELECT a.dte...
February 24, 2009 at 3:48 pm
I believe you maybe a victim of "blocking" please ensure table scanning is not happening.
I don't see any other indexes on that table posted ( are there any ?)
February 24, 2009 at 12:26 pm
neil (2/24/2009)
February 24, 2009 at 11:58 am
ritesh (2/24/2009)
mentioned. However there were options in set article properties as "Drop existing object...
February 24, 2009 at 11:50 am
rudy komacsar (2/20/2009)
... also ... it is an industry that is not easily outsourced overseas as wel !!!
Hmmm... EXCELLENT point.
February 23, 2009 at 3:10 pm
This thread is "NOT getting worse" any more 😀
February 23, 2009 at 3:09 pm
Eswin (2/19/2009)
Can anyone please tell me the command to close a session after that particular process has finished executing.
I am not talking about Kill process, i want...
February 23, 2009 at 2:14 pm
Josh Duncan (2/23/2009)
February 23, 2009 at 2:12 pm
Does that property mean that it will keep the object intact and only ADD the data from B, and NOT remove the already populated data?
FROM BOL
sp_addarticle:
[ @pre_creation_cmd =] 'pre_creation_cmd'
Specifies what...
February 23, 2009 at 11:18 am
It is possible and a bit complex but don't get discouraged 🙂
The First thing is to track the "new" values you probably want to isolate those values in a lookup...
February 23, 2009 at 9:42 am
If using row_number() make sure you have "uniqueness" in your over() part or the results can be non-deterministic!
February 23, 2009 at 9:35 am
dynamic sql is always the answer to these but are you sure you want to do that on the server ?
February 23, 2009 at 9:31 am
Shark Energy (2/23/2009)
Set up Pull subscription From Server A to C with snapshot to start it...
February 23, 2009 at 9:22 am
Viewing 15 posts - 421 through 435 (of 5,103 total)