Which path did you take?

Taking the function call out of your query would help.

ALTER Procedure [dbo].[GetIPdetails]

@IP VarChar(15)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

...

DaveDB (1/24/2014)

---

I completely disagree with the use of cursors. They are heavy and slow and anything that you can do in a cursor you can be accomplished in a loop...

It shouldn't be homework as I recognize this from a previous thread http://www.sqlservercentral.com/Forums/Topic1532233-338-1.aspx

You...

Here's an example using CROSS TABS. It's shorter than the Pivot option, but you need to understand what the code is doing.

DECLARE @sql NVARCHAR(MAX)

SELECT @sql =STUFF((SELECT ',SUM( CASE WHEN p.ProductID...

I would suggest that you take a look at dynamic cross tabs. Seems easier to work, especially when several columns and aggregates are involved.

http://www.sqlservercentral.com/articles/Crosstab/65048/

Here are 2 examples based on...

I would suggest that you take a look at dynamic cross tabs. Seems easier to work, especially when several columns and aggregates are involved.

http://www.sqlservercentral.com/articles/Crosstab/65048/

That's because when SQL Server is "reading" the code, it won't find a reference to Table_B alias until it gets to Table_B.

Check the following article: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

It explains how to solve your problem.

If you have any specific questions, feel free to ask.

I'm not sure how would you automatize your process as you haven't given a source for your calculations.

I can get to your expected results but I'm not sure that would...

Here's an option. I added comments trying to explain what it's doing. If you have any questions, feel free to ask.

SELECT --This formula adds the difference of months between base_date...

hi,

As you may notice, this forum is basically for SQL Server users and most of us would come with a solution using T-SQL instead of PL/SQL. would that be fine...

Will the year always come at the end of the string? Or would something like "Microsoft Office 2003 Professional Edition" is possible?

The reason is because the solution can be simplified...

Thanks for the article Jeff. It's always good to have a nice explained reference.

It's hard to think of a solution without some sample data and expected results. everything is possible, you just need to provide more information. Check the article on my signature...