Viewing 15 posts - 49,666 through 49,680 (of 59,078 total)
I've not tried this because the production environment I work in is stuck in 2k... but nice short too-the-point article. Thanks. And, I agree... I wish it worked...
June 26, 2008 at 5:38 am
Catalin Enescu (6/25/2008)
with(nolock) on select statement are useless
Alright... you need to tell us why you say that... useless for what?
June 26, 2008 at 5:32 am
pduplessis (6/26/2008)
:DAwesome Jeff...
Thanks!
but Venki specifically asked how to do this in SSIS (call a SP from his package), which I am trying to get him to avoid.
Ummmm.... Nope... YOU...
June 26, 2008 at 5:30 am
*hides from the RBAR police*
Heh.. nah... "we" see all RBAR 😛
The problem with even that solution is that the op said "no intermediate tables"... @TestCount qualifies as an...
June 26, 2008 at 5:21 am
Ah... got ya...
Nope... I don't know, at the machine language level, what the memory address of vtable in SQL Server is.
June 26, 2008 at 5:15 am
That worked much better... but I gotta get some shuteye... I'll take a whack at it after I get home from work tomorrow...
June 25, 2008 at 10:23 pm
bpbhalerao (6/25/2008)
Hi All,thanks a lot for all your help. I created one function for this which will calculate the total no. of Mondays or Tuesdays... etc.
2 way street here... would...
June 25, 2008 at 10:21 pm
Heh... not good. It looks like you replaced all of the commas with tabs... DTS is trying to turn it into 11 columns because of things like the second...
June 25, 2008 at 9:52 pm
venki (6/25/2008)
Your suggestions are always welcome. No body responded for this one yesterday that's why I deleted it.
I have kept it for halfen hour and taken back. Now I...
June 25, 2008 at 9:44 pm
pduplessis (6/25/2008)
For the SSIS bit.
1) Create connectionmanager to your data
2) Create a preparation SQL task which basically deletes the data, as per the delete statement
3) Create a dataflow. OLEDB source...
June 25, 2008 at 9:41 pm
Aw crud... Bill, some of the rows have some commas in the actual data which pretty much screws up "easy". Could you recreate the zip file using Tab delimited...
June 25, 2008 at 8:38 pm
Good to see you too... and thanks for the book data in a format that I can actually load easily 😀
Do you have an example set of words that you'd...
June 25, 2008 at 6:32 pm
How are the words being passed and do you have a wad of example book titles we can test with? See the link in my signature for the best...
June 25, 2008 at 5:45 pm
Rashmi,
How often is the hierarchy going to change?
June 25, 2008 at 5:41 pm
We have lots of embedded tabs
That would certainly be a fly in the ointment. Thanks for the feedback.
June 25, 2008 at 5:30 pm
Viewing 15 posts - 49,666 through 49,680 (of 59,078 total)