There are multiple "split string" tvf functions you can find at SSC. Just use its search feature.

Just add an identity column to the result table and join on that.

Congratulations SSC !

Thank you for providing _the_ reference platform for SQLserver and the means to learn on a daily basis !

There are multiple articles at SSC that may be of your interest:

- Generating Missing Dates and Numbers By Jacob Sebastian http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

- The "Numbers" or "Tally" Table: What it is and...

I mostly use SQLServer Management Studio to get to my SQLServers.

But I'm a dba and rarely developer.

With regards to your Access conversion:

- Keep in mind Microsoft has a tool that...

raid is not mandatory !

However .... if you have no raid volume for your sqlserver databases, it is game over if you lose the drive, where with e.g. a raid1...

george sibbald (10/4/2010)

---

🙂 ah such an optimist! I do not think so but if it...

Did they benchmark TVF vs scalar functions vs CLR functions for this case ?

Thank you for the feedback.

Can you provide some performance data of their tests and chosen solution ?

Grant Fritchey (10/2/2010)

---

It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are...

What your are trying to do is a piecemeal restore.

(ent edtn / dev edtn needed )

ref: http://msdn.microsoft.com/en-us/library/ms177425.aspx

check Restore headeronly in BOL.

It provides the info you need.

You can use it this way:

if (select isnull( object_id(N'tempdb.[dbo].[#Tmp_BackupHeaders]'), 0)) <> 0

begin

DROP table #Tmp_BackupHeaders

end

-- versie SQL2K5 sp2

create...

please post your configuration settings "min server memory" and "max server memory".

On every 64-bit os, you should set the max server memory or else it may grab all ram.

(the...

If you're going for the choice to copy the table to a staging table scenario, keep in mind to re-link all objects that are related to or have been related...

Adi Cohn-120898 (9/28/2010)

---

I have to admit that I don’t agree with ALZDBA’s opinion. It is important to know and realize what clustered index does and how dropping it and\or...

How is this for a coincidence ... just today ... converting another db to sql2005 .... data_purity messages ....

my query only captured 7 rows of the 68 rows reported...