It is a very nice script! I like the use of the variable, instead of a cursor. I definitely just swiped this script, thanks for sharing it 😀

One thing I...

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in it,...

nitinuniyal (4/3/2012)

---

[font="Tahoma"]Thanks for the Reply..

But what i want is to mail the results in Excel format, if I only define the SP in query then it will only give me...

Gerbera (4/4/2012)

---

I have a huge nodes in XML. So my SELECT statement goes little long..

My approach : -> XML column to recordset, For Each Recordset-->Dataflow(XML Source from Variable to...

It sounds to me as if your proposed archive-table will, after the each set of staging data has been added to it, will be the superset of all emails that...

I am just getting up to speed in bits and pieces on SQL 2012. From Introducing SQL Server 2012 AlwaysOn Failover Clustering by Jonathan Kehayias instance-level impacts can be tracked...

Very true, just having a discussion here 🙂

Preferred in the sense...

I like your idea about bringing SERVER2's data into tempdb on SERVER1. That should scale up just fine too. Thanks for having a look.

Fair enough, but an IDENTITY would still be the preferred way to generate a new file's ID provided gaps in the sequence were tolerable. Managing you're own ID-generation scheme can...

nitinuniyal (4/2/2012)

---

Hi All,

I am tryig to run the below query but its failing while running. I am trying to send the query results in excel via dbmail.

[font="Courier New"]EXEC msdb.dbo.sp_send_dbmail

@recipients=N'nuniyal@shb.com.sa',

@body= 'Hi...

MSBI Learner (4/3/2012)

---

Scenario: We get EmailNames from our Source Systems and adding them in a table at Staging. Now whenever any new email gets added to the existing emails, I...

I...

TeraByteMe (4/3/2012)

---

This seems to work and has the added benefit of incrementing the ID by one which will work nicely with my next insert statement:

CREATE PROCEDURE [dbo].[spGenerateID] ...

TeraByteMe (4/3/2012)

---

Quick and probably easy answer for most of you. I want to created a stored procedure that simply is run and returns the max ID value from a table....

rarara (4/3/2012)

---

2) the files are different sizes - would having them exactly the same (as recommended in a few places) allow a round-robin utilisation and so prevent the error, or...