What is the error you are getting?

Steve you are abosolutly correct but the thing is i want to prevent it in development enviornment as App deve offen create the diagrams which different names & i want...

It would be great if you put any example for better understanding 🙂

Well I suggest all depends on your business requirement, if you business supports multi language the you should go with NVARCHAR.(I guess you have the knowledge of difference between VARCHAR...

hey sorry Jack, for duplicate post its my bad.

thanks for your suggestions...:-)

yeah it would be a suggetion to create "CASCADE DELETE" on child table in the scenarion you have mention but do remember to verify do you have any cyclical...

You can explicitly grant the permission to the user to modify the stored proc by usering "GRANT" statement.

i dn't think so you need to user CTE for it it can be done by following way(as mentioned by you only)..

declare @tbl_User table( UserID INT, Username varchar(10), LoginName varchar(20))

declare...

Vijaya,

I must appreciate for explanation you hvae provided. As you said, (*** The current batch of statements is composed of all statements entered since the last GO....***) I have one...

You should always know why this is working if you dn't know ask experts

in below examples it creates the procedure with name 'GO' just like 'CREATE PROC uspGO' it takes...

Why you are going for so many joins, you can achieve this by simple query...

DELETE b

FROM ADIM_ASSOCIATE_CONTRACTOR_RawImport b

JOIN ADIM_ASSOCIATE_CONTRACTOR a ON a.EMPLOYEE_NUMBER = b.EMPLOYEE_NUMBER AND a.[REHIRE_DATE] = b.[REHIRE_DATE]

I think below example will give you better performance ...

CREATE TABLE tmpProduct

(

ProductIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductNameVARCHAR(10)

)

CREATE TABLE tmpProductSales

(

ProductSalesIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductIDINT,

TotalAmtMONEY,

BalanceAmtMONEY

)

INSERTtmpProduct(ProductName)

SELECT'Pr0duct' UNION

SELECT'Pr0duct2' UNION

SELECT'Pr0duct3' UNION

SELECT'Pr0duct4'

INSERTtmpProductSales(ProductID, TotalAmt, BalanceAmt)

SELECT1,...

rfugikawa (1/21/2009)

---

Use the "Foreach Loop Container" object.

- Set the folder;

- set the files (*.xls);

- Retrieve file name = fully qualified;

- In Variables Mapping, set a variable with index = 0;

-...

before suggesting any design have you done any worked out on any design?

While installing SQL 2k5 have you choose the option for upgrading...?