Viewing 15 posts - 11,581 through 11,595 (of 13,857 total)
Koen Verbeeck (2/21/2011)
Phil Parkin (2/21/2011)
Not sure about that trigger idea - nice thought, but won't it just end up doing the same RBAR updates, albeit on the server?
If you implement...
February 21, 2011 at 1:54 pm
anjanwahwar (2/21/2011)
February 21, 2011 at 1:40 pm
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
Viewing 15 posts - 11,581 through 11,595 (of 13,857 total)