How can someone give an estimate on this?

It depends on too many...

401,415,793 is about 400 million. It's not even close to 40 billion.

Anyway, why would you want to select that amount of rows in SSMS?

Are you executing that directly in SSMS?

It's 40 billion (you sure it's not million?) rows, did you expect it to go fast?

If it's in SSMS, return data as text instead...

PL/SQL is Oracle 😉

Mostly by...

You would do this with SSIS. Behind the scenes, the import wizard uses SSIS. In the last step you can choose to immediately run the package or to save it....

Very interesting question, thanks.

CREATE PROC dbo.myProc

@ReportingViews varchar(50)

@User varchar(50)

AS

SET @ReportingViews = CASEWHEN EXISTS

(

SELECT 1

FROM USER_PRFL up

INNER JOIN BSP_LOB_Grp_Lookup bl ON bl.BSP_LOB_GRP = up.User_Group

INNER JOIN IMPACTED_LOB il ON il.BSP_LOB_CD = bl.BSP_LOB_CD

WHERE BSP_LOB_GRP =...

Following you...

John Mitchell-245523 (10/18/2013)

---

I don't think it's a performance issue, but it is a maintenance nightmare. Some third-party vendors encrypt their stored procedures so that you can't copy or change...

SQL006 (10/18/2013)

---

thanks for the clarification.

Is...

Indeed. There's a big difference...

At my next event - the Belgian SQL Server Days - I will meet other speakers I've never met before, such as Thomas Larock, Karen Lopez, Mark G Stacey, Alex...

I haven't used SQL Server 2000 a lot, so I don't know if this is possible:

Script all the jobs in SQL Server

DECLARE @myRow VARCHAR(10) = 'ADC. DCD.';

SELECT ISNULL(REVERSE(STUFF(REVERSE(@myRow),CHARINDEX('.',REVERSE(@myRow),1),1,'')),@myRow);

ps: please read the first link in my signature on how to post questions (table DDL, sample data, desired output). It will help you...

Nice question, thanks.