By the way you're describing this - I'd recommend NOT making this a pure SQL approach. I certainly see storing the data there, and having the consequences of tier...

iBar (7/31/2012)

---

Hi L' Eomot Inversé,

One thing you might have missed OR may be i could not understand in your reply is the flexibility for future enhancement.

For example:

In first approach,...

Just for references - I just tested out a fairly extreme case.

if exists (select object_id from sys.procedures where name='MattnoCmt')

drop procedure MattnoCmt

if exists (select object_id from sys.procedures where name='MattCmt')

drop...

I've had a few cases where a lot of the searches were basically "ends with" searches. The best way to implement that is using a persisted computed column with...

You're going to want to use a combination of CROSS (or OUTER) APPLY to turn the multiple nodes inside of some of the hierarchies into a virtual table of sorts....

Steve Jones - SSC Editor (7/30/2012)

---

SQLPhil (7/30/2012)

---

An interesting observation there Steve. Unfortunately I've seen too many examples where bad managers are promoted...

Grant Fritchey (7/30/2012)

---

Ian Scarlett (7/30/2012)

---

I think you can (not that I'm advocating it)...

USE tempdb

GO

CREATE PROCEDURE obj_cursor...

That was kind of the point of my previous comment. If the insert or...

opc.three (7/26/2012)

---

Welsh Corgi (7/25/2012)

---

I was trying to determine which option for importing SQL Server into SQL Server was fastest.

I would have assumed that a Stored Procedure would be faster nut...

Welsh Corgi (7/25/2012)

---

I thought that it could be as simple as a return code to indicate that there was an error.

This procedure will be executed in an SSIS Package.

If someone...

While I'm sure that there are other reasons - here are a few:

- a heap's nonclustered indexing relies on a "heap row ID", which is basically a compound identifier...

anthony.green (7/26/2012)

---

Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.

Gone with John's responce as its the simpler to impliment,...

From BOL:

Specifies that Service Broker message delivery is enabled at the end of the restore so that messages can be sent immediately. By default Service Broker message delivery is disabled...

Well if you're concerned that the numbers will NOT be the same (or you want to verify), then insert it into a temporary table of some sort, and verify that...

It's a bit of a circular argument, but per BOL, select @@ROWCOUNT returns the number of rows affected by the previous statement. The last statement is an INSERT so that's...