Viewing 15 posts - 8,806 through 8,820 (of 9,720 total)
The code is correct, however, I think (and I haven't had a chance to test it yet because I'm solving other problems) the issue is the difference between the datatype...
May 27, 2008 at 11:01 am
I'm not sure a function is needed for an insert. The left outer join suggestion is a good one, though.
Usually what I do is...
Insert into MyTable (col1, col2, col3)
(Select...
May 24, 2008 at 8:38 am
Thanks for the info, jjarupan. I'll take a look at it. @=)
May 21, 2008 at 5:10 am
FYI: Todd's solution worked for getting rid of the #13119 error message on the toolbox.
Of course, it took a while for VS to reinitialize the toolbox after I...
May 20, 2008 at 5:51 am
Oh, the reason I needed the bucket names.....
I can now do a JOIN between the Staging table and the DimCoverageBucket table on the BucketName so that I get...
May 17, 2008 at 11:42 am
As soon as my current code run quits, I'll try that, buuuttt.....
Are you saying the parens around the OR part of the statement aren't working correctly? I put in...
May 16, 2008 at 5:26 pm
I didn't look at my code before I submitted the post. The forum screwed it up. Let me try again.
ISNULL(RetroDate) == FALSE && (RetroDate lessthan (DT_DATE)"01-01-1900"...
May 16, 2008 at 4:38 pm
Will do.
Also, just a note. My build problem doesn't seem to exist in other solutions, not even the one I created from scratch and moved my "problem child" existing...
May 16, 2008 at 3:46 pm
And if there wasn't already a result set partially loaded, I'd agree with that.
You know how when you do a SELECT the results start loading as soon as...
May 16, 2008 at 11:35 am
Jim,
I appreciate your opinion, but I hate doing the half-day to full-day's worth of work uninstalling two programs and re-installing them if there is another perfectly logical explanation for the...
May 16, 2008 at 11:30 am
I was able to re-run my query without any problems. In fact, I haven't even closed out that session of SSMS yet. And haven't seen any additional error...
May 16, 2008 at 11:22 am
Other people are using BIDS with no problem on their PCs. I don't have time for a reinstall. My project is due Monday.
I finally closed the project out,...
May 15, 2008 at 5:49 pm
DOH! I was looking at the wrong transformation task.
Thanks! That helps. @=)
May 12, 2008 at 5:04 am
Ah. I thought you had the subreport as a column instead of as a row.
Nevermind. @=)
May 9, 2008 at 11:54 am
Why does the subreport have to be a column? Why can't it be a row?
May 9, 2008 at 11:30 am
Viewing 15 posts - 8,806 through 8,820 (of 9,720 total)