It does not give any error.

declare @frequency nvarchar (50)

declare @hours real

set @frequency = 'biweekly'

set @hours = 45

select case when @frequency = 'biweekly' then

    case when @hours > 80 then 1...

Is it so hard to open BOL?

EXECUTE

Executes a scalar-valued, user-defined function, a system procedure, a user-defined stored procedure, or an extended stored procedure. Also supports the execution of a...

Are you sure?

To get statistics for number or total amount of last week orders you don't need to match up those orders to customers, unless you are not sure some...

It may be any of non-printable charachters.

It's just the way EM displays presence of such charachters.

So, to display only right orders you need to include Customers into all select statements querying Orders. Are you sure it will not affect performance?

And if you allow to delete...

Everybody talks about DELETEs.

But what about SELECTs?

Should "well tested procedures" allow to display orphaned objects?

I believe not.

How you can ensure it?

SELECT ....

FROM ...

Where ObjectId not in (select ObjectId from...

Probably you need to read some topics from "user-defined functions" in BOL, especially about table functions.

Hope it will help.

RAISERROR inside trigger will rollback whole trigger transaction.

That's why you cannot see any result. It works as prescribed.

SELECT IDENTITY(int, 1,1) as ID

Cusip, UserBondFlag, Par, Price

INTO #Table

FROM TableTest

SELECT * FROM #Table

I see at least wrong syntax:

cast(col3 as varchar(20))

I have tried on my tables:

exec sp_columns 'Address', @Column_name = 'Id'

IF @@RowCount = 1

select GetDate()

exec sp_columns 'Address', @Column_name = 'No_Id'

IF @@RowCount = 1

select GetDate()

Works fine.

Check your tables.

Isn't it easier just to update statistics?

In most cases people really need not what they ask for.

Actually, the right way is to do something like this:

ALTER FUNCTION dbo.Initials

(@FirstName varchar(200),

@MiddleName varchar(200),

@LastNamevarchar(200) )

......

and call this function in select from whatever table...

Doctor is a person playing role of doctor.

Patient is a person playing role of patient.

Nurse is a person playing role of nurse.

Etc.

Organisations actually don't have first or last names. Your...