Actually, the message is from the parser. After you run this and get that error you will notice that #AEMQuotaYTD does not really exist.

Create an empty table and use...

Try Sql Server Express "a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005" (MS's words).

http://www.microsoft.com/sql/editions/express/default.mspx

Right off the bat the UNION looks suspicious because v_formulary_status_drug_label_assoc_detail_3 is in the not exists part too. By itself UNION is going to remove duplicates.

What indexes do you have? Is...

Simple workaround for testing is to make a job step that deliberately fails and run it. Something like select 1 from ThisDoesNotExist

select

case when DateDiff(dd,vpm300.adm_ts, Isnull(vpm300.dschrg_ts,getdate())) < 150

then

DateDiff(day, vpm300.adm_ts, Isnull(vpm300.dschrg_ts, getdate()))

else 0

end

from vpm300

You don't need to cast to an int. DateDiff() returns an int. Not sure how "not to include a...

Try using INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE or INFORMATION_SCHEMA.CHECK_CONSTRAINTS. There are a few other similar views that will be helpful. See BOL.

Try brackets around your servername

insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID)

select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from [haa-sql1].imisTest.dbo.Resident

Is C: the sql server's C: or one on your pc?

If xp_cmdshell is enabled try

master..xp_cmdshell 'bcp Ejemplo1..MyTestFormatFiles format nul -c -t, -f myTestFormatFiles.fmt -T'

There should not be a space...

What is the definition of the clustered index?

Can you get the dbo.GetChildren(42) function out of the where clause? Put the result in a temp table and join it.

The main advantage of unicode types is that they can handle more characters from more alphabets than non-unicode types which can be important if you are building something that can...

select @STR = @STR +','+ + fld_index FROM [nili].[dbo].[table_index] where table_index in (select distinct fld_index FROM [nili].[dbo].[table_index] )

should be

select @STR =

Take a look at Performance Tuning: Concatenation Functions and Some Tuning Myths

By Jeff Moden, 2008/01/01

http://www.sqlservercentral.com/articles/Test+Data/61572/

The first error message is self-explanatory. (SELECT fld_index FROM table_index GROUP BY...

It depends on how you are doing the encrypting and decrypting in the first place. If your users have to run a procedure to do each thing, then restrict permissions...

declare @TeamAvgHoldTime int ---<<< or decimal as you need it

select @TeamAvgHoldTime = sum(AvgHoldTime )/sum(TotSCI)

from #tmp

select @TeamAvgHoldTime

update t set TeamAvgHoldTime = @TeamAvgHoldTime

from #tmp t

If the column1 + 25 years date just a starting point that can be changed by inserts and updates then it can't be a computed column. Use a trigger as...