Viewing 15 posts - 6,241 through 6,255 (of 11,678 total)
You can use a derived column transformation to change the format of the date field.
Use the SUBSTRING function and convert the result the the appropriate datatype.
November 12, 2012 at 5:01 am
UPDATE Target
SET Address2 = Source.Col_Addr2
FROM
Table1 Target
INNER JOIN
Table2 Source
ON Target.Address=Source.Col_Addr1
WHERE Target.Address2 != Source.Col_Addr2
...
November 12, 2012 at 3:53 am
Yes, you can add more conditions there.
By the way, your last condition should be
AND
Target.Address2 IS NULL
And you need to add a space between "source" and "on".
This link might...
November 12, 2012 at 3:48 am
Add the WHERE clause
AND Target.Address IS NULL
November 12, 2012 at 3:34 am
It's possible, but redundant.
on Target.Address=Source.Col_Addr1
AND Target.Address IS NOT NULL
is the same as
on Target.Address=Source.Col_Addr1
When Target.Address is NULL, this join condition returns false, so including Target.Address IS NOT NULL won't make a...
November 12, 2012 at 3:19 am
Jason-299789 (11/12/2012)
So the simplest way to do this is a Single Update (I'm guessing at the join and update column as they are missing in your code, but it gives...
November 12, 2012 at 1:07 am
It depends on the operations as Randy mentioned - it needs to be possible in the SSIS expression language - but if it can, SSIS will be better, as you...
November 12, 2012 at 1:00 am
You can use the ACE OLE DB provider to read Excel 2003 and Excel 2007 files.
This driver is used normally for the Excel 2007 files, but due to backwards compatability...
November 12, 2012 at 12:57 am
If all the flat files have the exact same structure: yes. Use a For Each Loop with a dataflow inside and expressions on the connection managers.
If they don't have the...
November 12, 2012 at 12:52 am
UPDATE t1
SET ColAddr2 = t2.Col_Addr2
FROM
TABLE1 t1
INNER JOIN
TABLE 2 t2
ON t1.T1_Address = t2.Col_Addr1
November 12, 2012 at 12:51 am
This seems to be the case: only CU1 and CU2.
Mind that this is the CTP release of SP1.
http://sqlserverperformance.wordpress.com/2012/11/07/sql-server-2012-service-pack-1-released/
November 12, 2012 at 12:46 am
In SSRS itself, not much has changed, the most the integration with SharePoint.
You now have Data Alerts, updated renderers for Word & Excel and if you install SP1, you can...
November 12, 2012 at 12:39 am
This might be an issue with Management Studio, not with SQL Server itself.
Try simulating a heavy workload with SSIS or with BCP, and see what happens.
November 12, 2012 at 12:36 am
You can use the UPDATE statement (you can join multiple tables together in an UPDATE statement) or the MERGE statement.
If it's really complex, you can add in a common table...
November 12, 2012 at 12:23 am
Viewing 15 posts - 6,241 through 6,255 (of 11,678 total)