Quick question and bear with me hear, but why do you need the cursor, the inner sql has no exec statement?

😎

This should get you started, two different methods.

😎

USE tempdb;

GO

DECLARE @TDATA TABLE

(

Id INT

,Calling VARCHAR(12)

);

INSERT INTO @TDATA

(

...

Phil Stratford (6/12/2014)

---

Actually, it seems like using IDENT_CURRENT is a terrible idea in the context of my question. As you've pointed out, it returns the last IDENTITY value produced...

Koen Verbeeck (6/13/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t:...

My 2 cent on this, as this is a one-off exercise, let the wizard do...

In T-SQL there are two main options, either use a system stored procedure sys.sp_defaultdb or ALTER...

JustMarie (6/12/2014)

---

The DBAs keep my database servers running and happy. In return I keep them informed of things that may impact (or may not) the database servers.

Going to have...

Second thought:w00t:

why not backup straight to the network drive? No need to write the backup locally!

😎

Sathvik (6/12/2014)

---

Hi All,

Recently we have migrated sql server 2008R2 server to 2012, But after migration one of the stored procedure is taking 2mins execute in 2012 server. It took...

Quick thought, wouldn't it be simpler to have an SSIS package for shuffling the backup files around, no need for XP_CMDSHELL etc.

😎

Throwing in an other 2c, it is much worse when duties and responsibilities fall between the different groups than occasional clashes or issues. And it definitely isn't about who's [put...

Eric M Russell (6/12/2014)

---

Hollywood should make a film called "A Day Without a DBA" just to show the ignorant public (and cocky app developers) what a total global disaster it...

Have a look at this article

Tally OH! An Improved SQL 8K “CSV Splitter” Function By Jeff Moden[/url]

😎

liudi (6/11/2014)

---

Hi all, I'm new to this forum, and really need your help.

Recently I got a 1.3TB table, has 2.7billion rows and 25 columns running on MSSQL. When trying to...

What is the Recovery Model for the database?

😎