Did you have a question that you wanted to ask?

I think there should be a separate SQL Haiku forum where both questions and answers must be posted in the form of a Haiku.

If you want help, you should post your sql in the message in between code tags.

Most people (including me) will not open a file posted on the forum because it...

The code you posted isn't even in valid SQL syntax.

Please supply your actual query code, table definitions, sample data, and your expected output with the sample data.

Here is another approach on the link below. Function F_TABLE_DATE is a multistatement table-valued function that returns a table containing a variety of attributes of all dates from @FIRST_DATE...

You will have to open a cursor on the inserted table and execute the procedure once for each row returned by the cursor.

This looks like something that would be better...

Add an ORDER BY clause to the SELECT statement that is calling the function.

declare @t table (pk int not null primary key identity, dat varchar(10))

insert into @t (dat)

select '1' union all select '001' union all select '11' union all

select '100' union all...

This is not an easy problem to generalize.

Take this name for example: “Carl von Clausewitz”. Unless the procedure knows the conventions, how does it identify that the last name...

I’m going to make the assumption that what you mean by “Outsourcing” is Offshore Outsourcing.

A lot of senior management types see IT as a necessary evil at best, and really...

800 MB is a very small database. Did you actually mean 800 GB? ...

gan (11/27/2008)

Michael Valentine Jones (11/25/2008)

In that case, let me jump in. 😀

There are many opinions of this subject, but I...

You cannot force SQL to execute on shutdown, especially if someone uses SHUTDOWN WITH NOWAIT to force an instant shutdown.

In that case, let me jump in. 😀

There are many opinions of this subject, but I am firmly in the...

Michael Valentine Jones (11/21/2008)

What do you want it to return if today...