Viewing 15 posts - 11,596 through 11,610 (of 13,870 total)
Koen Verbeeck (2/21/2011)
To find the real issue here, you'll have the post the error messages, as they are currently missing.
So you're not happy with the "just set the maximum error...
February 21, 2011 at 7:50 am
Not sure about that trigger idea - nice thought, but won't it just end up doing the same RBAR updates, albeit on the server?
February 21, 2011 at 7:48 am
Send all of the rows you will be updating to a staging area (as INSERTs), then perform a single T-SQL update at the end.
February 21, 2011 at 6:28 am
You could try playing around with custom date formats where you specify the format in code, eg
Now.Date.ToString("yyyyMMdd")
February 21, 2011 at 4:16 am
Guys, I was looking for an old post of mine and came across this one, only to see that I never said thank you :blush:
So let me remedy that: thank...
February 17, 2011 at 12:28 pm
Randheer (2/17/2011)
This is the questions which other than the general indexes questions.
--
This index question does not scan.
February 17, 2011 at 11:00 am
Looks to me like your derived column expression would work for dates formatted as YYYYMMDD, whereas your dates are in MMDDYYYY format - so you just need to change the...
February 17, 2011 at 1:37 am
You have merely repeated your first question. Saying that you want something 'as output' does not mean anything to me. Are you trying to populate a lookup table with missing...
February 16, 2011 at 2:33 am
You have given your suggested input data, but the desired output is unclear to me.
Are you saying that you want table A to contain all of the values in table...
February 16, 2011 at 2:25 am
umajanaa85 (2/15/2011)
Anyone else give me an idea to get...
February 15, 2011 at 4:38 am
If someone gave me a spreadsheet containing hundreds of thousands of rows on multiple sheets, it would be effectively useless to me. What is the requirement? Get users to open...
February 15, 2011 at 3:58 am
Unless the offending text fields have their own delimiter, eg:
"kdfjgasdg, dasfsjfg ", 5,10,"dkjhkh, asdkjhaksdj"
There is not much you can do, other than asking whoever provides the information to help (by...
February 15, 2011 at 3:08 am
IMO this might be simpler if implemented in a Script Task.
February 15, 2011 at 2:29 am
Use SUBSTRING instead of LEFT to achieve the same thing.
February 15, 2011 at 2:25 am
It would seem not. But have a look here - someone has already written it for you.
February 10, 2011 at 1:32 pm
Viewing 15 posts - 11,596 through 11,610 (of 13,870 total)