Viewing 15 posts - 706 through 720 (of 3,232 total)
You'll need the following tasks:
1. ExecuteSQL task - this is the first task in your control flow. This should query your table and return the results into a variable...
January 20, 2010 at 12:00 pm
Some of this depends on how you want to summarize and display the data. Let's rewind a bit.
Can you provide an example of how you want your final result...
January 20, 2010 at 10:55 am
You mean a count and sum of only negative variances?
January 20, 2010 at 10:42 am
nikki123 (1/20/2010)
insert into dbo.Billingselect * from [112.64.104.210,3824 ].fttpreports.dbo.Billing
Check your table DDL. The error tells you exactly what to look at.....number of columns (including order) and data types.
Your...
January 20, 2010 at 10:40 am
SQL_NuB (1/20/2010)
not sure if this the best way but i did this.(RequiredCompletionDays - DATEDIFF(dd, COALESCE(tbl1.Opendate,tbl?.YourOtherDateColumn) , tbl1.ClosedDate)) as variance
and it returned my correct number.
Yep, that's exactly how you have to...
January 20, 2010 at 10:34 am
SQL Server does not recognize when you use a column alias within the same query. You have to fully define NumberOfDays in your calculated column.
SELECT DATEDIFF(dd, COALESCE(tbl1.Opendate,tbl?.YourOtherDateColumn) , tbl1.ClosedDate)...
January 20, 2010 at 10:33 am
If so, try this:
DECLARE @Table TABLE (W int, X int, Sequence int, Z varchar(10))
INSERT INTO @Table
SELECT 1,1,1,'text' UNION ALL
SELECT 1,1,2,'><' UNION ALL
SELECT 1,1,3,'text' UNION ALL
SELECT 1,1,4,'text' UNION ALL
SELECT 1,1,5,'><'...
January 20, 2010 at 10:21 am
In order for you to know what is between the values, you must specify how they are ordered. Is it safe to say that each WX value is ordered...
January 20, 2010 at 10:17 am
Do you mean that your NumberofDays calc needs to test for OpenDate being NULL?
If so, use COALESCE. Since you have not specified where that second date column comes from, I...
January 20, 2010 at 9:37 am
Kit G (1/20/2010)
Sober
Huh, kind of ironic, but this was your 420th post......
For the record, I am not pointing this out to promote 420 logic...just thought it was interesting (I'm sober...
January 20, 2010 at 9:29 am
To be honest, I'm not real familiar with working with Microsoft ACCESS. I chimed in because I've worked with schema separation. Where is the stored procedure located?
January 20, 2010 at 8:39 am
Well, if you've already got the data in a staging table, you may consider doing as Jack suggests and just move it with T-SQL. If the data is already...
January 20, 2010 at 8:26 am
Good info Lowell. I had wondered if that could be done with triggers and I looked into that before I posted my reply. I looked at the DDL...
January 20, 2010 at 8:13 am
I don't think there is a way to retrict the source of a login, but you can set up a SQL trace so that you can monitor how and where...
January 19, 2010 at 4:07 pm
Duplicate post, please follow this thread here
January 19, 2010 at 3:27 pm
Viewing 15 posts - 706 through 720 (of 3,232 total)