Yes in this case it is comparing the value from one table to another. So you get what is happening now?

sqlfriends (8/1/2011)

---

I see one of our query is like below:

select Cast(Case BusCalItemID

when BusCalItemID then 0

else 1

End as bit) as linked

from dbo.businessCalendarItem.....

The BusCalItemID field is a PK and int field.

My...

Yes I would agree that would make the problem even more difficult. 😛

I am totally unclear on the rules for the "groups". Can you provide what the desired output would...

Your query will return the count of table a for each group. BTW, you really don't need a distinct when you also have a group by. The group by will...

Then you will have to use a trigger. There just is no way to conditionally fire a trigger based on a 3rd party application. You could your own nasty kludged...

In all honesty I think the biggest challenge you are facing here is poorly designed tables. How are you going to handle adding new foods? You have to add more...

This is WAY off topic for a sql forum.

The easiest way would be to add a keypress event handler to your textbox that will run some javascript. In your script...

There is no reason you can't delete a backup file after you have restored from it (unless you want to keep it for archive). It is not being used by...

How about order by col1, col2?

I don't think there is anyway for sql to know when another application is done sending update statements. Conceptually it just doesn't work. You could have the other application call...

PaulB-TheOneAndOnly (7/29/2011)

---

Sean Lange (7/27/2011)

---

I often tell business people (which are the ones that usually ask for this kind of silliness) that primary keys are used by the system and therefore...

I have to say that the correct answer is not worded in such a way as to make much sense. It says "Install fails because SQL 2005 can't be installed...

Cool glad you figured out a way to solve it.

See if this helps.

declare @MakeDirVal varchar(500)

begin

set @MakeDirVal = LEFT(@Copy, 26)

SET @SQLQUERY1 =

'xp_cmdshell ''mkdir "d:\copy test\destination"' + @MakeDirVal + ''''

EXEC (@SQLQUERY1)

SET @SQLQUERY2 =

'xp_cmdshell ''XCOPY /S "d:\copy test\source"'+@Copy+' "D:\copy test\destination"'+@Copy+'"\"'''

EXEC (@SQLQUERY2)

That should...

If you want a little dynamic solution instead of hardcoding 20 characters take a look at this. I wasn't sure if you were trying to parse the file name or...