Viewing 15 posts - 151 through 165 (of 3,232 total)
So, just for giggles, what is going to consume this file? It seems odd that you have to delimit the file AND make the columns fixed length.
So...
October 5, 2015 at 4:16 pm
Number(38) is much larger than integer and I don't think they play nice together with implicit conversions. The error looks like it's happening on your destination component so I'm...
October 5, 2015 at 4:10 pm
Alright, here's an example of an OUTPUT clause on your previous INSERT statement. All this does is take the values that you are inserting, along with the auto-generated IDENTITY...
October 5, 2015 at 11:18 am
I agree with Sean here that the use of TEXT datatype is not good here. Since they are using Text, Sean's query still will not work. You'll have...
October 2, 2015 at 3:53 pm
Couple questions....
First, is there some sort of key value that you are able to use in your target system to determine where to pick up in source? In other...
October 2, 2015 at 3:47 pm
Judging from your INSERT statement, you've got some data coming in from somewhere and getting loaded into InputTable. Can you give us the DDL for that table as well...
October 2, 2015 at 3:35 pm
I'm still not a fan of dynamic procedures with variable table names. You may consider writing the procedure for each table that it will run against and having the...
September 25, 2015 at 12:47 pm
I've done this before where I took an existing mail merge process that needed to be data driven and automated. You can use a Script Transformation and interact with...
September 25, 2015 at 12:40 pm
OK, so if you only want to pull matching rows, that would change the solution to an INNER JOIN.
August 11, 2015 at 9:53 am
I need it to show at the final as
Group Name Category Dimension
123 Test 123 888
456 Test1 123 888
789 Test2 345 777
My code brings you the exact results that you...
August 11, 2015 at 9:40 am
The only thing we're really missing here is that your example result set does not show any items from Table1. So joining into Table1 is actually pointless. Can...
August 11, 2015 at 9:14 am
Looks like a pretty simple LEFT JOIN to me....
DECLARE @Table1 TABLE (Groupid varchar(10), UserName varchar(10) , Category int, Dimension int)
INSERT INTO @Table1
SELECT 'AAA', 'Jon', 123, 888
UNION ALL
SELECT 'BBB', 'Jon', 345,...
August 11, 2015 at 9:07 am
OK, we're close....can you show me, using the sample data you've provided, what the results should look like?
August 11, 2015 at 8:57 am
I would suggest that you consider using SSAS. Developing a cube for your data gives you the control over how the data is put together and how the metrics...
August 11, 2015 at 8:48 am
Can you give us an example of what you want your dataset to look like? Maybe some sample data?
August 11, 2015 at 8:42 am
Viewing 15 posts - 151 through 165 (of 3,232 total)