Viewing 15 posts - 586 through 600 (of 3,232 total)
I didn't try to retrofit this into your query, but this example should show you one way to get the results you are looking for. Basically, this allows you...
March 25, 2010 at 1:02 pm
So the data source is a text file? Is it using a flat file connection manager? If so, open up the connection manager and go to the Advanced...
March 25, 2010 at 12:50 pm
This is yet another example of, 'it depends'. I wouldn't say to stay away completely as partitioning definately has it's place and advantages.
March 25, 2010 at 12:27 pm
From what you've described, your code should still return a 'Y'. See this example:
DECLARE @Table TABLE (Col1 varchar(10))
INSERT INTO @Table
SELECT 'CC' UNION ALL
SELECT 'CC' UNION ALL
SELECT NULL
SELECT MAX(CASE WHEN...
March 25, 2010 at 12:13 pm
I would recommend any option that does not involve triggers. Triggers fire within the scope of the transaction so using a trigger to populate a table in another database...
March 25, 2010 at 12:02 pm
Well, first you'll need to figure out which performance counter that you'd like to monitor. I'll leave that to you. There are a few perfmon counters that are...
March 25, 2010 at 9:50 am
I believe that there's a performance counter for replication latency, correct?
If so, create an alert for that Performance Counter Object and set it to file for > 2 min.
March 24, 2010 at 3:33 pm
To create an OnError Event Handler:
1. On the Control Flow, set the focus on the task that you would like to create the event handler on.
2. With the task selected,...
March 24, 2010 at 2:56 pm
Sounds good. I'm glad you've got it working.
March 24, 2010 at 9:59 am
What exactly are you trying to do? Are you getting an error, if so, what is it?
March 23, 2010 at 4:50 pm
You say that the job
failed at the end and stop processing all other files
What task did it fail on? Since you have this inside a loop container, you...
March 23, 2010 at 4:49 pm
So you want 1 day's worth of data beginning with yesterday >= 1:00 AM and up until today <= 12:59 PM?
This should do it:
DECLARE @Table TABLE (RowID int IDENTITY(1,1) NOT...
March 23, 2010 at 4:24 pm
We went there about 5 years ago, back when we only had 2 kids, for a family vacation. We stayed in Rapid City and hit Rushmore, Reptile Gardens, Crazy...
March 23, 2010 at 2:27 pm
It's in Keystone, SD. The nearest 'big' town is Rapid City, SD, which is about 1/2 hour away. I was born just outside of Rapid City, at Elsworth...
March 23, 2010 at 2:19 pm
I figured so, but this thread is now so long I didn't want to go back and re-read them all.
I get to SF at least monthly (I'm in...
March 23, 2010 at 12:18 pm
Viewing 15 posts - 586 through 600 (of 3,232 total)