I think what you are trying to do is call SPB and inside that proc you want to call SPA?

Create Procedure SPA

@Name varchar(10),

@ID int output

As

Insert Into A

Values(Sat)

set @ID=scope_identity()

Create ProcedureSPB

@Name varchar(10),

@Bnum...

To say that codevc is sketchy is a gross understatement. They blatantly steal others work and repost it. They even have some of the stairways articles. http://codevc.com/1054_A_Stairway_to_Transaction_Log_Management_in_SQL_Server_Level_1_Transaction_Log_Overview.aspx

Maybe you can change...

You have all kinds of bad data in here. You have records in table1 with questionIDs that dont exist. You even have two records in table1 that are identical. If...

How about if you post some ddl, sample data (insert statements) and desired output based on your sample data? The query for this is really pretty simple but your description...

It was pretty obvious from about the third of fourth word it wasn't him. 😉

In fact, it appears...

At least this yahoo gives credit at the bottom with a full link to the "source".

Lynn Pettis (10/3/2011)

---

Am I seeing some sort of pattern here? Here is another one but there are some variations, the code samples. The words really look like mine.

http://sqlanddotnetdevelopment.blogspot.com/2011/02/deleting-large-number-of-records.html

Same...

Pretty pathetic actually that this person somehow thinks this makes him/her look smarter. These types typically get a decent job and then let go because their company either figures out...

This really is not the same as his other question. http://www.sqlservercentral.com/Forums/Topic1184615-391-1.aspx

In this case he wants to update the parent record when a child is inserted.

To accomplish just create an insert...

When you select are you using SSMS? If so you need to change your output to text instead of grids. The grid does not show carriage returns.

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all the MVP's...

sqlquest2575 (9/30/2011)

---

Hello Friends, I've a question on Access to sql db conversion datatype change. In access i have datatype as Decimal places as "Auto" what should be the...

K. Brian Kelley (9/30/2011)

---

Sean, that query is 2005 and above. 🙂

For 2000:

SELECT [name]

FROM syslogins

WHERE denylogin = 1

OR hasaccess = 0;

As for your second question, SQL Server...

I would agree that I would start with the sproc. Unless you are talking about millions of rows in the base tables 19 seconds sounds way too long. If you...