Viewing 15 posts - 1 through 15 (of 62 total)
I had tried that. The table is 8 million rows right now and even trying to limit it to a specific unique ID the server basically locks up on the...
February 1, 2018 at 5:10 am
I'm not sure what version of SQL that my BI tool rides on (Sisense). I was looking through it for any solution and the only thing I found was self-joins...
January 31, 2018 at 5:41 pm
This is maybe not the right forum/version as I don't have the "lead" function that I can use/find. Is there a true "SQL" based solution using something like the self...
January 31, 2018 at 3:02 pm
Thanks for the reply, however I'd actually already set that up, for that very reason.
Just not sending externally, and the other issue is the fact that it sends...
July 7, 2010 at 1:20 pm
pduplessis,
Yours is slightly more complex than mine, (I think your developer and myself both found/modified the same code snippet for this), but what I'm running into that doesn't work correctly...
June 10, 2008 at 8:19 am
It's not that. You are correct however that filenames is a string array, however my problem isn't transferring the file.
It's that I'll send the file up/down and it will...
June 10, 2008 at 6:08 am
There is no need to check for bye, etc.
This is using the following line:
http://ftp.ReceiveFiles(fileNames, "DOWNLOAD_PATH", True, False)
It's all very basic overall and should be handled gracefully by Microsoft,...
June 10, 2008 at 5:29 am
All of my reports are internally used, so I just did the horribly bad route and changed the login to a domain account with rights to everything and left it...
March 5, 2008 at 12:12 pm
Bad assumptions and logic were what you might have missed.
I was trying to use an order by clause to give me the data in the order I wanted it and...
January 23, 2008 at 11:40 am
Kenneth,
That would be a good way to accomplish this task and one I hadn't thought of honestly.
But what I was talking about was using @@Error to try to catch the...
January 21, 2008 at 8:26 am
Yeah, there is supposed to be a way to trap this error in TSQL and handle it programmatically (I was talking SSIS for a different aspect of fail/success). But...
January 21, 2008 at 7:33 am
I've tried to find a way to handle it multiple times and ways, but I've never found out how to actually capture it and programmatically ignore it.
Granted, I use SQL...
January 21, 2008 at 7:09 am
Jeff,
That's actually a bit of a misnomer in that it won't fail.
You're correct, it does end up going through, however it shows to the client that an "error" occurred. ...
January 21, 2008 at 6:53 am
Here is what I think is happening, but not sure how to prove it.
The table being imported into is indexed against duplicates based on cust_id field.
What I'm thinking is that...
January 18, 2008 at 12:23 pm
Viewing 15 posts - 1 through 15 (of 62 total)