I can see that you have edited your sample data, but only the part that I quoted in my last post. From what I can see, there are still issues...

You're Welcome Sapen. 🙂

You can use the following script to query the Error Log and get result for all Database backups and restores:

Declare @ArchiveNum Int

Declare @Arch_Temp Table(ArchiveNo Int, Date DateTime, LogFileSize BigInt)

Declare...

I understand the requirement but you're Sample Data is not correct. The above quoted part shows that the table...

Attaching an Excel sheet is not called providing readily consumable sample data. Please check the link in my signature and post sample data as shown in the link. This time...

This would also work fine for your requirement:

Create Table Ex

(Id Int Identity(1,1),

Value NVarchar(5) )

Create Table Ex1

(Id Int Identity(1,1),

Value NVarchar(5) )

Insert Into...

That was a really nice catch Mr. Moden..........I came up with the exact same query as Dwain......never thought of the scenario that you mentioned. I guess this foresight comes with...

From what I understood from reading your requirement and looking at the image you uploaded....i have come up with the following....I think it should work for you:

Select Employee, MIN(Effect_Date) As...

"sp_MSforeach.." procedures are undocumented and according to Microsoft are for Internal use only.

If what you are trying to do is an Adhoc requirement then it is fine to use...

Yes, Inserting a few million records just takes a few seconds.....I have a feeling you are getting data from one table....performing RBAR operations on the data and then Inserting the...

You can understand the a-z of Indexing at the below link.....hope it helps:

Stairway to SQL Server Indexes[/url]

The pleasure is all mine Mr. Moden......I have learnt a lot from the articles here at SSC.....and its a pleasure that i could recommend a few of those to other...

Jeff Moden (11/2/2012)

---

BriPan (11/2/2012)

---

i am doing query part

but for the quick response below are the steps

1)use split function fn_Split(search google you will get this one)

2)apply this split function on...

kingdonshel (11/2/2012)

---

Having the same problem, could you please give a better explanation for your fix or a possble example. Don't understand, I am getting the same problem of the OK...

You can get it as follows:

Declare @SampleIDs Varchar(100)

Set @SampleIDs=(Select SampleIDs From Sample1 where AutoID=1)

;With CTE

As

(

Select Item from dbo.dbo.DelimitedSplit('1,3,4',',')

UNION

Select Item from dbo.dbo.DelimitedSplit(@SampleIDs,',')

)

Select STUFF((Select ','...