Check ur Question Complete Context before post because this will missguid many peoples who do not know detail

In Your Qustion nvarchar used double bytes as length define and Computed column...

Congragulate all 3 persons who were awarded MVP's and are members of sqlservercentral group.

Also want to start yearly award according to this website postings to increase compition and users availability.

Yes you can remove duplicate record by three ways:

1. group by using row_number()

2. drived table using row_number()

3. having class with count function

for more detail see help or sent me...

this is for default value

SELECT cdefault FROM syscolumns

and identity

@@Ident_Current ('TableName')

all possible ways are discussed above but think about

not in using top

select top 10 *

from table

where id not in (select top 20 id from table)

and cte...

Group BY filter distinct records on base of Group Columns.

Distinct filter records on base of all columns in select.

For more information go to sql server central help.

Yes You can do with as all above says or use ## to use it in procedure

One thing i forgot to say that

temp table has some records restrictions so be careful of that

Hi

Use Access import vizard and this problem will not happen using DSN conntion

Hi Mr,

First of All clear you xml thinking to pass large data it will not make any problem even on web.

XML is the easiest way to insert record for this

But...

Hi All,

every one gives finest solution but one different solution that i use in my code is xml based

like

Declare @vxml xml

set @vxml = '

...

Hi patpat,

You want to pass date parameter to SP.

SP get date in as string and because it evaluate this in a valid date formate so if you want to pass...