I'm glad to help!

I cannot see you have posted a table. Just formatted/indented text.

Have you read forum...

You stored proc returns SEQNO in the recordset.

Not very well written proc I would say, crap actually.

To get the above value from it, you should execute this proc and...

avdhut.k (5/14/2013)

---

Hi,

I had requirement,I want a report in sql server 2008 as follows,

Total PayDate Amount

2000 ...

cyberdaemon (5/13/2013)

---

another option iam thinking right now is to create a udf that will call this executable sp. and the result will be call to my sp that will update...

sp_helpuser

avdhut.k (5/14/2013)

---

Hi,

I had requirement,I want a report in sql server 2008 as follows,

Total PayDate Amount

2000 20110401 1000

...

Using FOR XML PATH is most common technique to achieve string/row concatenation.

So, what is your question?

dwilliscp (5/13/2013)

---

I do not have permissions on the server.. and there is a lot of red tape to get anything installed.

However I did use the SQL provided... with a few...

It has nothing to do with SQL.

It's a problem with your application configuration file.

Try to clear down \bin\Debug and \bin\Release folders.

After, build check what config file is copied there...

michael.higgins (5/13/2013)

---

SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

FROM sys.sql_dependencies d

INNER JOIN sys.objects o

ON d.object_id = o.object_id

INNER JOIN sys.objects p

ON d.referenced_major_id = p.object_id

Worth a...

What tool do you develop with? .NET?

If so, check your build configuration. Debug vs Release

Install RedGate DB search - it's free!

http://www.red-gate.com/products/sql-development/sql-search/

First of all: it's really hard to work with code which looks like vietnamese noodles.

I've tried to add some indentation there:

ALTER PROCEDURE [dbo].[spreport]

@pSiteSeqId VARCHAR(MAX),

@pStartDate DATETIME2,

@pEndDate DATETIME2

AS

BEGIN

...

another way of doing it without windowed function:

SELECT pl.ID, usr.FirstName +' ' + usr.Surname as Createdby, pl.ProspectGuid, pl.MobileNumber as CTN, pl.Firstname + ' ' + pl.Surname CustomerName,

Convert(varchar(10),pl.CallBackDate, 103) as...