Hi Marino,

you can increase Connection TimeOut bu using below mentioned steps:

1. Open your Data Source by double clicking.

2. Click Edit button.

3. Click on Advance button to open Advance Properties dialogue...

While setting default value of parameters consider two things:

1. If its integer then use =Value (here Value means any default value)

2. If its string then use...

Yep...

Nigel may be right.

But if you are not using the First(Fields!Name.Value) Then probably you can handle the NULL value in your stored procedure like ISNULL(FieldName,'')

But the data you mentioned clearly show that request is submitted three times without rejected...

3245Submitted To X2008-06-06 12:13:25.450

3245Submitted To X2008-06-06 12:13:30.433

3245Submitted To X2008-06-06 12:13:38.513

And then request is rejected..

3245X Rejected2008-06-06 12:33:43.003

3245X...

DECLARE @T Table (DeptID int,DeptName varchar(50), ParentID int)

DECLARE @DeptID int

SET @DeptID = 3

INSERT INTO @T

SELECT 1, 'HR', 0 UNION

SELECT 2, 'Finance', 0 UNION

SELECT 3, 'Production', 0 UNION

SELECT 4, 'Enterprise',...

Alternatively you can use sytem view

[sys.syslockinfo]

you can Execute system stored procedue [sp_lock]

Dear Friend,

I think the simplest query for your question is as mentioned below:

-------------------------------------------------------------

Select T2.RetailerID, T2.RetailerIDTheirs

From TableA T1

Inner Join

(Select *,Rank() Over (Partition By RetailerID Order by RetailerIDTheirs) As...

Dear Friend,

Could you explian the problem in detail?

I am not able to understand what time you want to calculate since same request is sumbitting multiple times..

/*

Dear Friend,

Try below mentioned code....

----------------------------------

*/

declare @startdate datetime

declare @enddate datetime

declare @ward varchar(20)

set @startdate = '20071201'

set @enddate = '20071231'

set @ward = 'AAA'

if (select count(ward) from NPI_Table where monthname = getdate()...

Dear bitbucket,

Just copy and paste the T-SQL code written in my post and just execute it. You 'll get right answer.

Alternativelty you can copy the second option and remove single...

I am sure that only second answer is correct and its only one choice.

--Execute this query to see the result

declare @t table(EmpName varchar(100), DateOfLeaving datetime)

insert into @t

Select 'Abc','10-10-1999' UNION

Select 'Bcd','11-11-1998'...

Thanks a lot Jason Hall

Thats what I wanted..

Thanks ramses2nd 

but what I need is a database script (query) to achieve the task.

Most welcome if have you could provide sql query.

OK guys!

Here I'll explain my problem with an example:

I created following function:

CREATE

Function [dbo].[GetSplitedValues]

(

@CommaSeparatedString

varchar