i was looking for real code specifics..CREATE TABLE Category....

and then how you wanted to filter the products:

SELECT * FROM PRODUCTS WHERE CATEGORYID = ....

those details are what i'd need to...

here's an example using row_number of using that to page information;

if you gave us more details, specifically the actual table schemas, and maybe a sample select statement, we could offer...

this seems to give me the results i was looking for, it's rather dawn out into CTE's to show all the logic and can be easily shortened up, but i'm...

this seems to wrok for me; if i put it on a table that has FK's pointing to it, the constraints for the FK are enforced before the trigger fires.

CREATE...

since you said you are building a string, this is probably what you want for a demo:

CREATE TABLE IDDemo

( pk_ID Integer IDENTITY(1,1)

, Textdata Varchar(100) )

DECLARE @sql varchar(max)

declare @tablename varchar(30)

SET @sql...

Don i think your EXC command needs to do everything all together; you can separate commands with a semi colon, which is rumored to be mandatory in a future version...

so the only difference is you want...

based on Sean's post, i think if you join the grouping back to the original table, you can at least see the dupes :

SELECT #mx.bid_price_old, #mx.* FROM #mx

LEFT OUTER JOIN...

I have this appllicaiton in my PortableApps collection: it finds keys for 2000/2005/2008, and ifg you know where the key to anything is stored, you can add it to the...

Elliott Whitlow (12/22/2010)

---

Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use....

it has to do with your function...if you did not use WITH SCHEMABINDING in the definition, i'm sure the function is non-deterministic, and thus any column that uses the function...

SSMS uses the extended stored procedures master.dbo.xp_sqlagent_monitor and master.dbo.sys.xp_servicecontrol to stop and start the services for the agent or the service on the server.

those procs are called without...

Geoff A (12/21/2010)

---

the ability to control SQL services via SSMS has nothing to do with SQL permissions.

it is based on windows level permissions. local security and domain security policies.

users in...

only a sysadmin has the ability to start and stop the server via SSMS; so do not give their login sysadmin and you are all set; just make them a...

it doesn't matter what...