The easiest method is to use Generate Scripts under the database...

Brandie Tarvin (9/19/2013)

---

Does anyone know why SSMS would close without warning during the middle of a query run?

It's done this to me twice this morning. I do have Statistics_IO and...

I think ORDER BY name is what you want. But to get the sort order correct you will need to pad the values with leading...

OK...here ya go...includes Brian's suggestion for Holidays. I turned it into a stored procedure:

CREATE PROCEDURE dbo.UTIL_CreateDateCalendar

...

Sean

I haven't had a chance to review the entire script in detail nor have I gone back to read all the comments so if the following issue has already been...

Great script! :w00t:

 

I use CTEs now routinely instead of using sub-queries. Just a new way of doing it that seems more clear and structured to...

Great article Jeff. Perhaps you could add the point that when inserting code into the "Code" IFCode tags that tabs should be converted to spaces before pasting in the code....

Start here:

Post about CONTAINSTABLE

Full Text Indexing - Text Parsing Routine[/url]

 

Hey...I found the answer:

Erland Sommarskog, SQL Server MVP. 2013-03-24.

How to Share Data between Stored Procedures

"Another solution, which requires SQL 2008, comes from Wayne Bloss. He creates a table type that...

One thing I use it for...

Let me add to the conversation. Since the procedure's parameters (except for the first one) all have NULL assigned as a default doesn't mean that the parameter will be processed...

Once you know what account it's trying to run under (the failure message will tell you), then you can right click on the SSMS shortcut and "Run As" that user...

Jeff Moden (8/15/2013)

---

Steven Willis (6/22/2013)

---

Brian

It looks like you have a winner! I ran a test of DelimitedSplit8K using your method against 3 other methods including the Itzik Ben-Gan method. Your...

I'll make a list of possible changes for review so we can all contribute and not have to do stuff over and over. Thanks.

1 Negative numbers

2 Base 0 or 1

3...