Viewing 15 posts - 9,166 through 9,180 (of 13,876 total)
Same as any other view.
July 30, 2014 at 6:22 am
It's going to be tricky for a newbie, because the data seems to vary by 'type' and some techniques are required to get you through that.
Do you know what your...
July 30, 2014 at 6:14 am
Koen Verbeeck (7/30/2014)
Create a Subscription View (Master Data Services)
+1 - beat me to it.
July 30, 2014 at 6:10 am
What is the nature of this data - a flat file?
And you want to clean the data as part of an import to a db - is that right?
July 30, 2014 at 3:28 am
Koen Verbeeck (7/29/2014)
INSERT INTO db1.dbo.attendance_details(employee_no,date_of_attendance,present,shift_type,marked_by)
SELECT employee_no,date_of_attendance,present,shift_type,marked_by
FROM db2.dbo.attendance_details
WHERE date_of_attendance IN ('2014-07-01','2014-07-02');
Might need to tweak your filter a bit:
--
WHERE date_of_attendance >= '2014-07-01' and date_of_attendance < '2014-07-03'
July 29, 2014 at 1:52 am
Here is how I would try to do it.
Do an INSERT to your identities table such that it generates all of the idents you need in one hit.
Then use an...
July 28, 2014 at 7:49 am
Things are going wrong with this line, clearly:
select @newid, otherstuff, otherstuff1 from @temp where @i = idx
Does the actual version of the code select its data from multiple tables, by...
July 28, 2014 at 7:32 am
alezar (7/28/2014)
I'm working on the conversion of a group of DTS to SSIS and the function of a part of them is to export data from an Oracle database to...
July 28, 2014 at 5:06 am
Not sure whether it will work, but I think your regex may be incorrect.
string toreplace = "[\uFFFC]";
Can you try removing the square brackets?
string toreplace = "\uFFFC";
July 21, 2014 at 8:28 am
Gary Varga (7/21/2014)
--Personally, I'd much rather upscale a solution based on Access than one based in Excel.
Let's see whether anyone takes the bait 😉
July 21, 2014 at 8:05 am
Sergiy (7/18/2014)
Koen Verbeeck (7/17/2014)
Sergiy (7/16/2014)
Koen Verbeeck (7/16/2014)
So it is 100% possible to decouple the primary key from the indexCan you illustrate how?
Easy peasy. I draw a table diagram in Visio...
July 18, 2014 at 12:21 am
podmate (7/17/2014)
Now that I am building ETL apps in SSIS, I long for the days when I could script out my ETL process and did not have to deal with...
July 17, 2014 at 11:42 pm
Still nothing resembling a question.
July 17, 2014 at 9:40 am
susmitha117 (7/17/2014)
To extend further i followed this link belowI did the same way but first for loop executes but doesnot loop with the one inside
Please help
You have not asked...
July 17, 2014 at 8:53 am
Viewing 15 posts - 9,166 through 9,180 (of 13,876 total)