I did the steps you mentioned but there are some problems.

1- Bugfix link is not working. Please provider valid link

2- I have created ODBC driver for with free table directory....

try this one

i want to delete the duplicate records based on regno and leavetypeid. Output should be like this:

Delete from

(

Select rank() over (partition by regno,leavetypid order by regno) as...

check out this one also.

http://sqlservercoollinks.blogspot.com/2009/03/using-case-in-where-clause-utilizing.html

Hi,

I Don't have sql server right now but you can achive this using coleasce

read this blog http://sqlservercoollinks.blogspot.com/2009/05/returning-comma-seperated-values-in-sql.html

Declare @vComma Varchar(max);

Select @vComma = COALESCE(@vComma+';','') + column1+Column2+column3 from table1

select @vComma

select @@VERSION

this will tell you what version is running on your machine

to check versions

click on

connect --> goto "browser for more" from servername -- > on local server you will...

I think it is normal behaviour. But set

right click column index,

go to options

set auto update statistics to True

and

auto reindexes to ture

this will help

It seems to be OK. Only need is to generate links

please clear your answer in sql server terms.

most possible answer no restriction on edition with authentication.

most suitable way is to use your own usename and password or sa...

it depends on your results. try to rebuild your index and then try again. when you run query after closing your current session then it will take time. But after...

I think you are using SQL Server 2005 Reporting Services.

Use simple query to return resultset and an extra column that return month portion of the date column.

select *,datepart(mm,yourcolumn) as...

First convert the chardate into date format then you can apply all date functions you want.

convert(datetime,chrdate,103)

if you have only problem of calling procedures by mutlipul users then use NOLOCK in your query.

i think you want that all , seperated values must be returned in table format.

use following function to do this.

select * from fn_split('321,3AY,3LH,3PU,3PR,3SP,3JH,3VN,3VR,3VT,3VU,3VV,3VW,3VY,3UW,3WA,3WD,3WI,3WM,3WY,3WZ,3XB,3XJ,3XK')

create function [dbo].[fn_split](

@STR varchar(8000),

@spliter char(1)

)

returns @returnTable...

You are almost there very good first attempt. you are missing only one line.

use follwoing template

DECLARE confreghistcursor CURSOR

FOR

SELECT

OPEN confreghistcursor

FETCH NEXT FROM confreghistcursor INTO @createdbyname, @registrationsetupidname, @weeksout, @extendedamount

WHILE @@FETCH_STATUS=0

BEGIN

INSERT...

Use this query. i dont remeber table names so using sample query

Select top 1 [column list]

from table1 inner joni table2 on table1.column2=table2.column2

order by table2.date desc

if you want latest record from...