Steve:

You mentioned the IF NOT EXISTS statement. I'm wondering if I can use it. But how would it work?

So I put my SELECT statement inside the IF NOT EXISTS statement...

Hey Steve,

Thanks for the sp_send_dbmail command. I actually logged back on to post that message because after some research I found out I could use that. I configured my database...

Btw.. not sure if anyone clicked on the links but the BCP link actually led to an MSDN article about Creating Indexes with Included columns... or is that where it's...

Oh yeah.. I tried registering as well.. nothing would work. I'm not sure what was causing the problem and really don't have the time to look into it. I guess...

Okay, just so if someone as unfortunate as me stumps at this point... just re-install your .NET Framework (in my case 2.0) and everything will magically start working.. well not...

Try again..

Hi mr,

If I understand you correctly then you could put any hardcoded values after the SET @VariableName keyword.. and that would be your parameters being passed. So if you wanted...

Okay.. anyway.. realised all I had to do was drop the schema first.. :rolleyes:

Nerve-wracking indeed! I'm amazed Microsoft (the developer of the nuts & bolts of the windows OS after-all) hasnt freaking made their uninstall windows application a little more dynamic!

I had to...

Most definitely Lynn. I guess i'll have to read abit about CTE tables over derived tables.. Thanks for the information 🙂

Great yeah.. I will definitely try to use JOINS more than the where clause. I happen to alternate for some reason, but I'll try to stick to JOINS... I guess...

Hey Thanks buddy.. yes not your fault... I'm sorry I didnt let you know that it wasnt the only thing I was working with.. but is your query more efficient?

It...

Hey Glen... Thanks for the information... it not only correct my problem but also I learned soemthing new..........

Sorry.. i'm kinda new to SQL development..

THANK YOU!

Whats the difference between Column names and Field Names? I thought both were same

SELECT CalDay5.Yr AS C0,

CalDay5.CalDt AS C1,

Loc.Alias,

COUNT(Loc.Loc_PK) AS LocsReported,

CalDay5.PerOfYrNbr AS C3,

CalDay5.WkOfYrNbr AS C4,

REPLACE(S.name,'ZAXBY/','') AS POS,

--LR.BusDt,

LR.AdjNetSales,

LR.CompCurrSales,

LR.CompHistSales,

SELECT CASE WHEN LR.CompCurrSales IS NULL THEN 0 ELSE (('LR.CompCurrSales'-'LR.CompHistSales'/'LR.CompHistSales')*(100))...