Hi yaip,

I'm not sure what this design represents, my guess is that for each role you want to be able to have a different display sequence of the menu items.

If...

No comments regarding question and answer, just an alternate solution:

if not exists

  (select 1

   from   tempdb..sysobjects

   where  name like '#mytable%'

   and    xtype = 'U'

 &nbsp

begin

   print('Already created')

end

Cheers,

Henk

Hi AJ,

I must confess that I did read the question the same way you did and was more or less lucky to have chosen the right answer (which I chose...

Another quote from BOL to confuse people even more:

The maximum length of text that can be inserted interactively with WRITETEXT is approximately 120 KB for text, ntext, and image data....

Ok, I was wrong too

Here's a complete(?) overview of the different situations:

alter my_table

add new_column char(1) default 'N'

Does not fill the column for...

Hi Wingenious,

I'll try to clarify the statements I made:

First: what I think I know about your opinion regarding database architecture comes from reading the pfd document http://www.wingenious.com/database.pdf. I assume...

Hi maxismclaren,

In general: no, this does not make sense. An index is usefull if it is made out of column(s) with as selctive possible values. The summum is a unique...

Hi Aaron and Wingenious,

g_smilevski has given excellent suggestions regarding your question. There's nothing I need to add to that. I do, however, want to react to Wingenious post in which...

Hi Gabriela,

Looking at the code, I assume that the query optimizer somehow decided that the index doesn't offer the fastest access. You wrote that you did an "update statistics" and...

Hi Gabriela,

Can you please post the table definition (you can leave out or change column names if you like), including index definitions and the query that is behaving differently on...

Hey bbdpres en Perry,

I've integrated all but one of bbdpres's very usefull suggestions in the script below. I didn't do anything with indid = 0 (heap table), because I found...

Hi Perry,

Try this code, it only generates the rebuild statements, so you can review it before you actually execute the code:

declare c_idx cursor local fast_forward

for

select o.id, i.indid

,      o.name...

Hi jgljgl,

Given the facts that the number of colors is variable and unknown and that you'll select only one item at a time, I think that xnl28's solution does exactly...

Hi all,

I posted a solution before, but I think this one is better. I expanded Vincent's solution with another case statement (Vincent is right, this is the statement of choice for...

Hi jgljgl,

I've created a select that returns the desired result in 1 query. The only caveat is that you must know up front how many different colors there are, for...