Viewing 15 posts - 316 through 330 (of 495 total)
Create a SELECT....FROM clause that will produce the rows you want. Then change that to an UPDATE statement with the same WHERE clause. If you can select the...
August 23, 2010 at 10:15 am
No, this isn't an SSIS issue. SQL Agent can't verify that the job owner exists and has rights. I have seen this often and never found a reliable...
August 23, 2010 at 10:12 am
That's a server level setting, not a DB level setting. You can only restrict user connections at the server level. And it's global, meaning maximum number of SPIDs...
August 23, 2010 at 9:04 am
If you get that error, you probably haven't taken the first full DB backup yet. You have to have at least one full DB backup before taking log backups,...
August 23, 2010 at 8:16 am
Do you have another box you can use to try the same thing? Sounds like your client tools install is corrupt possibly.
August 23, 2010 at 7:55 am
Main difference I see in a practical sense is memory caps. 32 bit is limited to the old 2 GB threshhold without AWE and you have to use AWE...
August 23, 2010 at 7:54 am
And just as an aside keep in mind also that SQL 2008 R2 is only going to support 32 CPUs in the Datacenter Edition; if you get R2 Enterprise your...
August 23, 2010 at 7:50 am
Don't rely on the dropdown. Type in the server name, and if applicable the instance name or port, of the server straight into that field. If the server...
August 20, 2010 at 2:06 pm
That's because the syntax as the other poster wrote it won't compile if used as provided. I assume he meant that to be implemented differently than wrote it.
Did the...
August 20, 2010 at 1:48 pm
Oh, DUH! My bad.
Try this...
INNER JOIN (
SELECT ItemID, MAX(DateExpected) AS DateExpected
FROM InventTrans
GROUP BY ItemID
) G ON a.ItemID = g.ItemID
Sorry about that.
August 20, 2010 at 1:29 pm
Huh. Well what do you know....
Of course, it also must have the same name, so if you don't explicitly name the PK at creation time you have to locate...
August 20, 2010 at 1:26 pm
Well, you have to drop the primary key in order to drop the clustered index, if the primary key was created PRIMARY KEY CLUSTERED. And of course that means...
August 20, 2010 at 12:57 pm
Sure don't see that in R2 BOL, and you'd think that would be the most official list.
August 20, 2010 at 12:44 pm
And if you just want the last three months....
INNER JOIN (
SELECT ItemID, MAX(DateExpected)
FROM InventTrans
WHERE DateExpected > GETDATE() -90 -- or however you want to form the WHERE clause
GROUP BY...
August 20, 2010 at 12:30 pm
How about....
INNER JOIN (
SELECT ItemID, MAX(DateExpected)
FROM InventTrans
GROUP BY ItemID
) G ON a.ItemID = g.ItemID
August 20, 2010 at 12:28 pm
Viewing 15 posts - 316 through 330 (of 495 total)