Viewing 15 posts - 4,351 through 4,365 (of 9,715 total)
Is SSIS integrated with Powershell?
May 31, 2012 at 12:06 pm
DOH!
Nevermind. I found the issue. I got my subtraction in the end length wrong.
Code is now:
(DT_STR,10,1252)SUBSTRING(AllOtherData,382,FINDSTRING(AllOtherData,"~",3) - 382)
May 31, 2012 at 11:18 am
There is no guarantee this would be faster, but try a WHILE loop (using your records as a decrementing counter) and see if that has any better performance than a...
May 31, 2012 at 8:04 am
Sean Lange (5/31/2012)
May 31, 2012 at 8:01 am
SKYBVI (5/30/2012)
Brandie Tarvin (5/30/2012)
SKYBVI (5/25/2012)
I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of...
May 31, 2012 at 4:23 am
just_myles (5/30/2012)
ooohh instrumental, detrimental, potato, potatoe 🙂
Hee.
Anyway I do have a bunch of questions though.
So ask. @=)
If they're related to the article, ask here. If they're related to general job...
May 31, 2012 at 4:14 am
I don't know if this will work on any MS Access past version 2003, but try changing your MS Access front end into an .adp instead of an actually database....
May 30, 2012 at 12:31 pm
L' Eomot Inversé (5/30/2012)
GilaMonster (5/30/2012)
Too snarky?http://www.sqlservercentral.com/Forums/Topic1306465-334-1.aspx
No. If he can't read what he's been referred to he's beyond help. Just giving him the answers wouldn't be useful.
Well, I...
May 30, 2012 at 12:18 pm
SKYBVI (5/25/2012)
I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of the solutions :-
1)...
May 30, 2012 at 12:04 pm
In your examples, there isn't a single instance of a summed amount that comes to a decimal total above 50. In normal rounding, anything below 50 rounds down to the...
May 30, 2012 at 10:34 am
Please post the code you are using for calculating these numbers. It helps me if I have a visual of what you're doing.
May 30, 2012 at 9:19 am
Grrr.
I love my job, I really do. I work with great people and the company is awesome... But it annoys me that I don't have time anymore to really dig...
May 30, 2012 at 8:59 am
GSquared (5/30/2012)
Can't you add an SQL Script task to check for rows to export before you run the file-create step? Worth doing?
Are you talking about a Execute SQL Task...
May 30, 2012 at 8:17 am
WheeHaw! Quantum computing, here we come!
and the first article in that paragraph:
http://www.nature.com/news/not-quite-so-elementary-my-dear-electron-1.10471
May 30, 2012 at 5:50 am
Okay, I have to ask. What brands / years do you consider to be "a good red"?
May 30, 2012 at 4:16 am
Viewing 15 posts - 4,351 through 4,365 (of 9,715 total)