kirkdm01 (1/24/2012)

---

I have a cte that loops through the records creates a list and i pass a parameter of @ParamterID in a select statement but the set operations says incorrext...

This should be easy if you post the DDL and sample data in a readily usable format

You will get a tested solution back

Please check the link in my signature on...

From whatever I could understand, I have made some changes

Check if this is what you need

select 0 as IntUserID, 'Select...' as chrFullname

union all

Select U.intUserID, U.chrUnAllocatedUser

-- there should be some...

There is also an option in Tools->Options->SQL Server Object Explorer->Scripting->Table and view options->Script indexes

Set the value to "True" and then try scripting the table, you should get the script of...

I don't think there is a way to create a FOREIGN KEY linking a column in a table to 2 columns from 2 different tables

You will have to use TRIGGERS...

babak3334000 (1/17/2012)

---

Ok very Good

I quickly...

SQL Kiwi (1/16/2012)

---

It's not, but unless you have a...

SQLRNNR (1/16/2012)

---

Kingston Dhasian (1/16/2012)

---

In that case you can use the INFORMATION_SCHEMA.COLUMNS view, and create a Dynamic Script that will update all columns with bit data type

Try it and get back...

In that case you can use the INFORMATION_SCHEMA.COLUMNS view, and create a Dynamic Script that will update all columns with bit data type

It will be better if you follow Jason's...

UPDATETableName

SETColumnName = 0

WHEREColumnName IS NULL

sqldba2k8 (12/15/2011)

---

in software industry most of the working people are fake.

genuine people have their own knowledge to get the job.

I am working in developement platform.now i want to move admin...

Please post the DDL and some sample data along with the expected output. Also specify the columns that need to be checked for the existence of duplicates. If you provide...

You haven't given the description of your problem

Also post the DDL along with some sample data and the expected result

This will help people to give you tested solutions for your...

What value would you like to insert for the other columns like sex, averageage, maximumage and minimumage?

You will need an ORDER BY in your sub-query for the TOP 1 to work poperly.