Greetings g33kspeak,

Nice try, but this does not summarize the start and end dates for the book loan. It is only listing all records as they have been entered. Since...

Greetings,

May as well let you know: MSUT -> MUST

😀

Have a good day.

Greetings,

Thank you for posting this script to help standardize a database. I think it may come in handy for updating the fields in ours. It would be nice...

Greetings nbonadeu,

The regional idea is very nice. I have not worried about that yet though as I have not needed it. It would probably take another table to...

Greetings karyn,

Glad that you were able to find the code useful. If you have any questions, please don't hesitate to ask.

Have a good day.

Terry Steadman

Greetings Robert,

You are free to use the code to learn and your personal projects. If you are planning on using it in a commercial product that is to be...

Greetings Jeff,

It has been a project I have worked on for several years. I have translated the code several times from programming language to SQL backend to full SQL....

Greetings,

In the mindset of SQL 2005, this would look like a trick question. So, even though the question is what would the last SELECT statement show. Logically, it...

Tao Klerks (4/22/2010)

---

To be fair, even if you saw the "Possible Error" in the INSERT (if you didn't know this was a SQL 2008 feature, like me) or if you...

Greetings,

Microsoft does not use the ORDER BY clause when inserting records into any table, including table valued functions. This happens also in SQL 2005. Instead, their SQL engine...

Greetings,

Try changing one line to this:

SET RowValue = LTRIM(SUBSTRING(RowValue, CHARINDEX(' ', RowValue), LEN(RowValue) + 1))

The SUBSTRING is boundary safe so giving it a value that is greater than the actual...

This is actually where the problem came up. Originally the calls were only in the same division and classification as the employee table. Now they've changed it such that they...

Greetngs Sean,

I had to make a few guesses about what you were trying to do with the SQL code but I do have a script that you could try to...

Greetings,

I would think that what you want is possible to be able to search on any word in your search criteria. But, I suspect what you would need to...

Greetings Mark,

Considering that you are wanting the changes and not the original, then a simple GROUP BY log_ticket and a COUNT of curr_group may work. Then you can just...