John,

Yeah I get that.

What I was hoping for was the OP to give us more detail, whether he's using SSRS or a Web Page or whatever to present the...

John Mitchell-245523 (8/26/2010)

---

I think your requirement would best be fulfilled in your presentation layer rather than in the data layer. I would recommend Reporting Services for presenting data in...

Hint:

CASE WHEN ROW_NUMBER() OVER(PARTITION BY ledger_name ORDER BY ledger_name) = 1 THEN

finance.tbl_Ledger_Master.ledger_name

ELSE

''

END

This small change to SwePeso's version will handle values shorter than 13 chars:

CREATE FUNCTION dbo.fn_JulianDateConversion

(

@JulianDate VARCHAR(13)

)

RETURNS DATETIME

AS

BEGIN

...

Then have a read of this[/url]

A cautionary note.

Take care with the error handling in the solution using sp_getapplock, you could get into an infinte loop.

In most cases the WHILE statement should read:

WHILE @SUCCESS = -1

...

Other...

Woah! No need for anything that complex, try this:

SELECT CompanyName, x =

(

SELECT

CASE WHEN ROW_NUMBER() OVER(ORDER BY USER_ID) > 1 THEN ',' ELSE '' END + USER_ID FROM...

Suspect it just needs some parentheses as follows:

AND (TENPER.[TENANT-ORDER] IS NULL

OR TENPER.[TENANT-ORDER] = '1')

Do you mean you've added new columns to the table definition or just inserted new rows into the table?

If you've just added new rows then you need do nothing. However...

The procedure name is sp_addextendedproc

Guys,

In case you hadn't noticed, you're replying to a post that's nearly 2 years old. 🙂

Here's a slightly more succinct version inspired by code from this article http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

SELECT t1.col1,

(

SELECT

...

It's because of rounding, run this:

SELECT CAST (GETDATE() AS numeric), CAST(GETDATE() AS NUMERIC(28,12))

The http://<server>/Reports URL is the Report Manager with all the nice icons menus etc.

The http://<server>/ReportServer URL is used to access reports directly by URL.

Yes, it is. Really 🙂