Viewing 15 posts - 91 through 105 (of 698 total)
excellent - thanks!
January 31, 2013 at 9:10 am
Looks like I may have solved the problem *crosses fingers*.
Basically, just deleted all the IIS websites and all the IIS application pools except the Default Application Pool. Then, went into...
January 10, 2013 at 12:40 pm
Yeah it's completely ridiculous. They announced the new pricing plan today, but even with the new one it's still ridiculous:
Dear Customer,
Windows Azure SQL Reporting pricing is changing effective February...
December 21, 2012 at 9:49 am
Interesting - so for cross-database calls, this approach will not work? In which case, what will need to be done - the calling login will have to have access to...
December 13, 2012 at 11:04 am
I didn't realise any existed - thanks! Going to look in to those and see if they give me any extra information.
December 5, 2012 at 10:37 am
Excellent. Alright, I think that just about covers everything then. Thanks for all the help!
November 19, 2012 at 9:43 pm
They will not be taking out multiple items at a time - each time a user wants to withdraw an item, it occurs as one withdrawl for one item. Thats...
November 19, 2012 at 9:24 pm
Hm - I'm actually kinda surprised that works. I would have thought it would fail because the WHERE condition would evaluate AS
@TableB_ID IS NULL (TRUE) OR TableB_ID (Value OR NULL)...
November 19, 2012 at 11:06 am
Yeah - I've used the Dynamic SQL approach before, and it does work pretty well, but I'm not a huge fan of it. Never knew about the RECOMPILE option though,...
November 19, 2012 at 10:51 am
I'd strongly recommend against trying to use SSIS to do that directly. The .NET scripting environment within SSIS is pretty limited. You should instead write a .NET script separately, and...
November 19, 2012 at 9:39 am
What you're looking for is essentially an UPSERT procedure, or a MERGE.
Here's one way of doing it:
CREATE TABLE #ActiveRecords
(
fund_id INT PRIMARY KEY,
[name] VARCHAR(100)
)
INSERT INTO #ActiveRecords (fund_id, [name])
SELECT
fund_id,
[name]
FROM Fund
WHERE GETDATE() BETWEEN...
November 19, 2012 at 8:47 am
Hm. On thinking about it a bit more, I guess I could use a subquery:
SELECT
A.ID
FROM TableA A
WHERE
(
CASE
WHEN @TableB_ID IS NOT NULL THEN
CASE
WHEN EXISTS (SELECT 1 FROM LinkTable WHERE TableA_ID...
November 19, 2012 at 6:03 am
Hi there - hate to bump a thread, but does anyone have any answers for this?
November 6, 2012 at 1:56 pm
It's certainly that part which is taking the most time. I just don't know how else to go about it other than using the approach I've listed.
October 18, 2012 at 10:33 am
That's pretty much what I thought. Alright, thanks, I'll present the two ideas to my superiors and see which one they go for.
October 17, 2012 at 2:42 pm
Viewing 15 posts - 91 through 105 (of 698 total)