i forced your data to be integers so i could perform math on them, like adding a year; then used a Tally table to generate the results:

With MyData ([Customer...

two typical methods can be used

select distinct user from yourtable

--or

select user from yourtable group by user

you'll have to install the tools from the standard edition;

the express tools will only let you connect to the database engine.

in answer to my own question, i think i needed to use dm_db_session_space_usage instead; that gives me 600 KBbytesUsed in my example.

Eddie thanks for the pointers...I'm not getting the results I'm expecting, though.

I created a temp table with the typical SELECT * into #tmp fromSomeTable.

then i ran this command to see...

why can't you just wrap the big query as a subselect or CTE, and then join to your lookup table:

you know,

Select

MyAlias.*,

RK_tblInjCodes.*

FROM (

--big query goes...

could it be something like a missing GO statement, so the DROP/CREATE rolename is part of some stored proc that gets executed?

CREATE PROC MyProc

AS

SELECT 1 from sys.objects

--missing GO

If Exists(somerole)

drop role...

identity is still exactly what you want, even if you are combining multiple databases together, in my opinion.

One way is to use ranges for the seeds for the identities...

Is there a question in here...

Brandie glad you found what you are after, and thanks for the link; I added some of those methods to my snippets.

If you get a chance, can you explain why...

misiekbest (4/7/2011)

Question is simple. What does sqlsrv engine do with table after truncate command?

Someone told me, that it just rename that table (internally?), create new one and drop renamed...

Well,...

it depends on the work to be done; SQL would evaluate the command and make a decision/plan as to whether pieces of it can be processed in multiple cores; it...

SQL is a little different;

i believe you are looking for a BACKUP of one database(to create the dump, or *.bak file) and then when it's needed to restore over...

I've used the FOR XML trick to get the data...it returns string data(varchar(800) or max

this seems to do what you asked for:

/*DocIDSkills

1DocumentNumber,Sale Date

2First Name

3Last Name,DocumentNumber

8City

10Sale Date

*/

SELECT DocID,stuff(( ...

is there a question?