both provide the ability to substitute a null for a known value, but COALESCE is overloaded with a param array,...

not enough info Laura; we'd really need the specific error that occurs to offer solid advice; what does "causes SSRS to shut down" mean to you? that that one report...

I saw you've been making the same request for a long time. I had shown you in another thread on the same issue an english number-to-words example that you could...

you can use a CASE to decide which value to insert:(note you said update, but it's really an insert in your example)

INSERT INTO dbo.myNewTable

SELECT

RTRIM(LTRIM('Art')),

RTRIM(LTRIM('Incidents')),...

an important piece of this puzzle is the account the SQL service is running under. Even though YOU...

don't declare one of the variables as varchar(max); use a defined size instead; no error occurs when you do this:

declare @bak_source varchar(255), @bak_dest varchar(255), @xcopycmd varchar(1000)

set @bak_source='"\\qa\d$\Full_2010.bak"'

set @bak_dest='"\\dev\d$\Data"'

set @xcopycmd='xcopy '+...

eek! SeanLange beat me to the punch on this one! you got some payback on that one, way to go Sean.

Nope; that's a limitation of a CTE; it can be used only for one statement.

if you get rid of the pseudocode, and show us what you are actually doing, we...

lol happens way to often lately!

type faster! i guess it's a race now.

a CTE is available just for the next statement in the query, so if it really needed to exist twice, you'll need a temp table.

You're not really doing anything that...

rather than the AVG, i think you want the MIN([Sch Start]) for the earliest, or the MAX(([Sch Start]) for the latest date.

since you have a VPN, your machine is effectively on their network right?

what you'll want to do is fairly straightforward, the process is the same as you would do locally.

connect...

--snip edited wrong answer!--

Joe you cannot make the aliases for the columns dynamically(at least not directly) , so you have to revert to dynamic SQL to do it instead...building the command, then executing...

this happened to me as well; a partial install kept me from redoing or uninstalling.

i googled "completely uninstall sql2005" and found this link at microsoft that gave the annoying...