look up SQL server ranking functions, specifically ROW_NUMBER() and the OVER(PARTITION BY) predicate; that can do it, as well as

RANK and DENSE RANK;

if it was just an arbitrary #...

richardkel (12/10/2011)

In my case I have an ERP system that needs to supply a plant control system with customer, pricing and order information. This information needs to get to...

search the scripts section for "ProperCase" or "InitCaps" foir other examples, there's some out there that look for things like "O'Brian" and "St.James" or "David-Jones".

here's just one of...

Pam do you youse a calendar table for the on off entries, or just a schedule assumption (ie biz hours mon-fri);

i tested the concept with my calendar table, no...

and post upgrade, to address how statistics are used differently in the updated sql engine:

1. rebuild all indexes.

2. UPDATE STATISTICS [EachTableName] WITH FULLSCAN

nothing worse than to upgrade to a monster...

just saw you said no xp_cmdshell;

in that case, unless you can install a CLR, theres no way to do this from TSQL. xp_cmdshell is the only thing i know that...

a very bassic example using the "md" command for make directory;

note in this example, the parent "Test" directory needs to already exist.

DECLARE @Results table(

ID int identity(1,1) NOT NULL,

TheOutput varchar(1000))

CREATE...

create them on the server, based on a query?

what if they already exist?

what would the query you run look like? (is it really Select myname from mytable?) what columns/data...

since you have control of the physical server on the laptop,

you an stop and start the service in single user mode, connect and then add a domainuser or localuser...

something with row number will probably get you pretty close to what you are after, so you can still visualize the data:

anything that is a duplicate (based on what you...

becasue you mentioned you needed to do this for a datawarehouse, I was assuming you had the ability to adapt an example. I was demoing the concept on how to...

someone with access can backup the database and restore elsewhere as well; people who would detatch and detatch to get the data would simply be those persons who are not...

Interesting scenario;

do you really want to prevent access completely, or should they only have read only access during specific restricted periods?

if it was read only access, you could use a...

this trick of adding the # minutes to the minimum sql date will trucate to the last minute that occurred:

select DATEADD(minute, DATEDIFF(minute,0,getdate()), 0)

Second Place...again 😉

WTG Cadavre.