That "slim chance" is here:

"$BODY$" - what is that ? Compiler probably asks the same 🙂 Get rid of that.

Functions cannot change database data (UPDATE/DELETE/INSERT are not allowed).

Using loops is...

Do a short trace (5 seconds will probably be enough) with sql profiler, with event "SP:Starting" and "SP:StmtStarting".

You will probably find function or computed column that is called zillion times.

I'll show you simple example.

First, prepare test data:

SELECT name = 'age', value = 20

into #fact

union all

SELECT 'age', 30

union all

SELECT 'age', 40

union all

SELECT 'height', 180

union all

SELECT 'height', 190

select * from #fact

WITH...

You cannot have two objects with the same name in a namespace.

In Orace, schema equals to user, and schema is a namespace. You cannot have two objects of the same...

Or simply press XDetails button (free plugin) on that table name in sql editor,

and you'll see all info you need.

I write a lot of t-sql and use XDetails (www.sqlxdetails.com) to look-up tables and columns.

Maybe this could work for you:

build a batch of sql commands and store them into varchar(max).

Call it with parameters using sp_executesql.

Example with two sql command in one batch:

EXEC sys.sp_executesql N'select...

Documenting the database is very important.

You can see descriptions next to the table columns quite easily with XDetails plugin (free): http://www.sqlxdetails.com

You can also see column descriptions next to each column with this very useful addin: http://www.sqlxdetails.com

No, you cannot do that. You could maybe build your query with UNION ALL of the queries and get the result you wanted.

Are you sure you cannot avoid dynamic queries...

You're welcome! 😉

"ws" is alias I choosed for #WeekSchedules table, ommiting optional "AS" keyword (I could write "from #WeekSchedules AS ws" or...

jfm3 (2/7/2011)

---

Sometimes I do use tallies, however, at the moment I simply need to list instances of people who have special days in their schedules. I need to see...

All that you want in one short answer:

Prepare the data (you should have posted that!):

select MondayRequired='x', TuesdayRequired='x', WednesdayRequired = 'x', ThursdayRequired='x', FridayRequired='x'

into #WeekSchedules

union all select 'x', '', null, '', 'x'

union...

Try this

Hi.

Solution provided so far will not work.

You can use a neat trick with CASE nested in the SUM() aggregate function.

With that trick, solution is really simple, and even without joins:

Prepare...