Viewing 15 posts - 24,406 through 24,420 (of 26,490 total)
Just to be sure, does this mean anyone hired in February isn't eligible for benefits until 4/1?
😎
August 6, 2008 at 12:29 pm
Just a guess, but is this what you are looking for?
SELECT TOP (5)
ShipCountry,
SUM (OrderTotal)as [Total Order],
SUM (OrderTotalExVat) as...
August 6, 2008 at 10:48 am
This is what you are probably trying to do:
declare @SQLUpdateCmd varchar(max);
set @SQLUpdateCmd = 'UPDATE EDW_STAGE..tbComm_3Months_Ago SET ' +
...
August 6, 2008 at 10:41 am
The following is code from one of our jobs that looks for a name change and send an email if appropriate. Look at the logic, and see if you...
August 6, 2008 at 10:30 am
Of course, here is some rough code I threw together that may help you figure out what you need to do.
create table #Header (
HeaderID int,
...
August 6, 2008 at 10:16 am
Can you put together a sample set of tables (create statements), sample data (as insert statements so we can copy, paste, and execute to load the tables), and the expected...
August 6, 2008 at 10:00 am
VSTE -- Visual Studio Team Edition.
😎
August 6, 2008 at 9:28 am
rbarryyoung (8/5/2008)
Lynn Pettis (8/5/2008)I think, in this particular case, it has to do with the INFORMATION_SCHEMA views. I played with them in SQL Server 2000, and for those to...
August 5, 2008 at 3:27 pm
rbarryyoung (8/5/2008)
Andras Belokosztolszki (8/5/2008)
One solution is to add the stored procedures to the master database, and add sp_ prefix to their names(bad practise)
Well, this works in the sense that...
August 5, 2008 at 2:48 pm
jpowers (8/5/2008)
jim.powers (8/5/2008)
August 5, 2008 at 10:57 am
Check the schedules. Make sure there aren't two schedules assigned to the maintenance jobs.
😎
August 5, 2008 at 9:14 am
Could you provide more detail? What would really help is if you could provide the DDL for the tables (create table statements) (or at least the key columns for...
August 5, 2008 at 9:12 am
Andras Belokosztolszki (8/5/2008)
(bad practise)
Another solution is to use a tool to...
August 5, 2008 at 9:06 am
Cost: $50.00 (USD)
Well worth the investment!
Edit: I bought it when SQL Server 2005 first came out. Comes with the x86, x64, and Itanium versions.
😎
August 5, 2008 at 9:00 am
jim.powers (8/5/2008)
August 5, 2008 at 7:37 am
Viewing 15 posts - 24,406 through 24,420 (of 26,490 total)