Viewing 15 posts - 1,261 through 1,275 (of 5,685 total)
avdhut.k (7/23/2012)
Hi,How to pass value to variable Of OLEDB Source of data Flow Task.
I am using SQL Command As Data Access Mode.In that I written an Dynamic Query.
Are you...
August 22, 2012 at 1:27 pm
Alan Kwan (8/22/2012)
Then is it possible to to write an SQL that will summarize the table into what I want? (permanately turning the table into a summarized table)
Are you familiar...
August 22, 2012 at 1:18 pm
Alan Kwan (8/22/2012)
Thanks for the quick reply!
Easy question with enough example to make sure I wasn't confused, the kind of question we all prefer. Keep 'em comin'. 😉 ...
August 22, 2012 at 1:06 pm
Lynn Pettis (8/22/2012)
August 22, 2012 at 1:04 pm
mishka-723908 (8/22/2012)
I understand and completely agree, but are there any other options? I dont see any but just add a column in the future when necessary.
Dead on target. The...
August 22, 2012 at 1:01 pm
Indianrock (8/22/2012)
August 22, 2012 at 12:56 pm
WayneS (8/22/2012)
I think it was something along the line of "It depends on what your definition of "is" is."
Yeah, that was always suspect. Asking for definitions of congress/court on...
August 22, 2012 at 12:54 pm
No, the schema doesn't allow for that. What you'd either do is maintain it using an ETL process or you wrap the table with a view that would be...
August 22, 2012 at 12:52 pm
chrisph (8/21/2012)
August 22, 2012 at 12:15 pm
As already mentioned table valued parameters are a great tool here, but if you want a simpler input (but more work at the proc level) XML or comma delimited strings...
August 22, 2012 at 12:12 pm
where dbo.ClientEnrollment.Void is null and dbo.ClientEnrollment. Enrollment_Date between
'''+convert(char(10),@FromDate,101)+''' and '''+convert(char(10),@ThruDate,101)+''''
Nope, this is injectable. Look up sp_executeSQL, and in particular parameterization. Any time you're directly including a variable into...
August 22, 2012 at 12:07 pm
Just on a side note, be careful with indexed views, particularly top 10 views and the like. On paper it doesn't look like they'll cost much overhead, they're only...
August 22, 2012 at 12:02 pm
There's a lot of material out there about Key/Value or EAV builds. They CAN be useful if you're sure your data will be homogeneous across all the values. ...
August 22, 2012 at 12:00 pm
The only reason to not use partitioning for access speed is if your entire schema is ORM controlled (I've seen this, it's not pretty) or if you're concerned about restore...
August 22, 2012 at 11:56 am
That shouldn't be too hard, actually, you merely only map the columns you need in the OLEDB destination to the table(s) in question. However, of a more critical issue,...
August 20, 2012 at 1:30 pm
Viewing 15 posts - 1,261 through 1,275 (of 5,685 total)