I just posted an answer to this in your other post here:

http://www.sqlservercentral.com/Forums/Topic839275-338-1.aspx

There were a couple of issues I found. One was that the insert statements were trying to insert into an identity column. You need to put this in...

you can always put a unique index on the fields within the table. What is the Primary Key to the table. You might/should be able to use that

The script errors out because there is no ccim_users schema. I removed that and the procedures compiled, but won't run because the tables are missing. Can you provide...

Can you provide Table Layouts and sample data? See the first link in my signature block to see how to post to this forum

I used a symmetric key and a certificate to get around storing the password anywhere. You can also encrypt the stored procedure, but you better have a backup of...

what have you tried so far?

You have to use the "with schemabinding" option when creating the view. This option prevents any changes to the tables that are referenced in the view. There are...

Looking at the proc itself, it only takes one parameter. It wouldn't be the first time BOL was wrong.

CREATE PROCEDURE dbo.sysmail_help_configure_sp

@parameter_name nvarchar(256)...

It's got to do with trying to convert decimal values to integers. Using Nabha's example, try running the following. The Round is performing an implicit conversion for you.

CREATE...

if that's the output you're expecting, then you will need to use a CTE or recursive funtion, which you have already done.

kabaari,

this code is wrong. Your original query used these 3 tables:

tbl_assembly_production

tbl_assembly_holds

tbl_Assembly_hold_defects

You provided a table layout for tbl_assembly_holds, but the inserts are wrong since...

Your script doesn't work. Only one table is created, it errors out on the Foreign Key and the inserts fail. Can you provide a valid script for all...

Sounds like your SSMS settings need to be tweaked. I was able to run all 4 queries and brought back data. Look in the menu under Tools.Options. ...

select MgrID, EmpID, EmployeeName

from emp e

where MgrID in (select EmpID from emp b

where b.EmpID = 1)