Just to be sure, does this mean anyone hired in February isn't eligible for benefits until 4/1?

😎

Just a guess, but is this what you are looking for?

SELECT TOP (5)

ShipCountry,

SUM (OrderTotal)as [Total Order],

SUM (OrderTotalExVat) as...

This is what you are probably trying to do:

declare @SQLUpdateCmd varchar(max);

set @SQLUpdateCmd = 'UPDATE EDW_STAGE..tbComm_3Months_Ago SET ' +

...

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...

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,

...

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...

VSTE -- Visual Studio Team Edition.

😎

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...

rbarryyoung (8/5/2008)

---

Well, this works in the sense that...

jpowers (8/5/2008)

---

jim.powers (8/5/2008)

---

Personally, when I get to the point where I can retire, I have no plans of un-retiring. Technology does move far to fast and I feel like I'm...

Check the schedules. Make sure there aren't two schedules assigned to the maintenance jobs.

😎

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...

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)

Another solution is to use a tool to...

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.

😎

jim.powers (8/5/2008)

---

Personally, when I get to the point where I can retire, I have no plans of un-retiring. Technology does move far to fast and I feel like I'm already...