Lots of people have looked but no one has commented. Is there no one who has any idea what these tables are?

IF Boolean_expression

{ sql_statement | statement_block }

[ ELSE

{ sql_statement | statement_block } ]

Is your point that "TRY...CATCH" is...

As you can see from my second example above, there is no "BEGIN...END", yet the two print statements act as a single block. That means that "BEGIN...END" is not...

It seems that all the suggestions that involve generating the city data in a single step would need to store that city data in a table somewhere, whereas the stored...

I agree that your version is faster, but not by the margin indicated. Most of the difference is created by the ORDER BY clause in "my" code, which is...

It seems to me that what you are doing is an itterative, sequential process, and a CURSOR is an appropriate way to solve the problem.

I don't know of...

You say that you are getting errors but you don't list what those errors are; it would be helpful to have those to give us some direction.

Also, how are the...

Cadavre: Here is another way to generate the table:

WITHAlphabet

AS(SELECT CHAR(N) AS Letter FROM Tally WHERE N BETWEEN 65 AND 90),

TwoLetter

AS(SELECT a.Letter + b.Letter AS Letters FROM Alphabet a CROSS JOIN...

I'm not seeing "channel" in the data anywhere. Is that part of your data or not?

Also, must a user log on each morning and log out each night, or...

http://support.microsoft.com/kb/316872.

Nested transactions are not permitted, according to the documentation of this error message. Do you have another "BEGIN TRAN" in the code not shown?

The problem with the original query is that it was trying to convert to a NUMERIC(5,4), which will hold a maximum value of 9.9999. The value "35" has two...

greg.bull (2/22/2012)

---

How do you use the known quantities of event start time, duration and endtime to then map to each of 24 hour pigeonholes to see if, for each hour,...

I agree with your assessment of my assumptions. In our applications, the application has a database login and users are credentialed against a user table. That means that...

One possible solution is to have ChildProcedure check for the existence of table #tmp and insert its values directly into the table rather than returning them as a result set.

IFOBJECT_ID('TempDB.dbo.#tbl')...

Having some sample data would help us write the query.

Normally, I would use DATEDIFF to determine the difference between two DATETIME values. I think the date portion is important....