Viewing 15 posts - 13,861 through 13,875 (of 15,381 total)
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...
October 3, 2011 at 2:33 pm
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...
October 3, 2011 at 2:21 pm
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...
October 3, 2011 at 2:14 pm
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...
October 3, 2011 at 1:55 pm
It was pretty obvious from about the third of fourth word it wasn't him. 😉
October 3, 2011 at 1:40 pm
Sean Lange (10/3/2011)
Lynn Pettis (10/3/2011)
Wait, wait for it. Another one plagerized.http://codevc.com/1929_A_The_Dynamic_Tally_or_Numbers_Table.aspx
At least this yahoo gives credit at the bottom with a full link to the "source".
In fact, it appears...
October 3, 2011 at 1:40 pm
Lynn Pettis (10/3/2011)
Wait, wait for it. Another one plagerized.http://codevc.com/1929_A_The_Dynamic_Tally_or_Numbers_Table.aspx
At least this yahoo gives credit at the bottom with a full link to the "source".
October 3, 2011 at 1:33 pm
Lynn Pettis (10/3/2011)
http://sqlanddotnetdevelopment.blogspot.com/2011/02/deleting-large-number-of-records.html
Same...
October 3, 2011 at 1:15 pm
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...
October 3, 2011 at 10:27 am
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...
October 3, 2011 at 9:54 am
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.
October 3, 2011 at 7:36 am
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 3, 2011 at 7:03 am
sqlquest2575 (9/30/2011)
September 30, 2011 at 3:17 pm
K. Brian Kelley (9/30/2011)
For 2000:
SELECT [name]
FROM syslogins
WHERE denylogin = 1
OR hasaccess = 0;
As for your second question, SQL Server...
September 30, 2011 at 2:07 pm
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...
September 30, 2011 at 2:00 pm
Viewing 15 posts - 13,861 through 13,875 (of 15,381 total)