elegant solution as always from Jeff;

I'm decent with SQL, but I still haven't gotten my arms around the Tally table concept for processing;

someday I'll grow up and be like Jeff...

I don't store images in my database, but i do store information about them.

I wrote a program that gets the CRC of any file, and I store that in the...

no, because there's no central resource to ask for the information.

You'll want to use a utility like SQL Recon to find all the servers in your domain. Besides finding out...

here's how i would do it if restricted to just using TSQL:

--a table to loop thru filenames

CREATE TABLE ALLFILENAMES(WHICHPATH VARCHAR(255),WHICHFILE varchar(255))

--the source table: yours already exists, but...

Query Analyzer is just an application that gets the data from a SQL Server database. it doesn't contain the scripts. everything is contained in a database on the server.

typically, you'd...

like Matt said, it depends on what you mean by "integrate into".

you can add calls to extranal applications int eh toolbar, and there is a project(codeproject.com or planetsourcecode.com , i...

truncating where? in query analyzer? QA has a famous display issue with large varchar columns, it might be the default value of 256 here:

Tools>>Options>>Results>>Maximum Characters Per Column>>change to 8000

if you are...

Is unicode characters the same as high ascii characters?

this is the only way i could figure out how to do it so far, was with a function that loops thru...

with a copy/paste of your code, i get this error:

Server: Msg 1540, Level 16, State 1, Line 1

Cannot sort a row of size 8101, which is greater than the allowable...

creating the tables and migrating the data?

if exists(select name from db1.dbo.sysobjects where name='mastertable1') drop table db1.dbo.mastertable1

select * into db1.dbo.mastertable1 from db2.dbo.mastertable1

just moving new data?

insert into db1.dbo.mastertable1

select * from db2.dbo.mastertable1

left...

if it's just one or two tables, then you'd simply use something like

SELECT *

INTO MYTABLENAME

FROM OTHERDATABASE.DBO.MYTABLENAME

[WHERE <condition to exclude unwanted data>].

if...

I'm confused why you can't just use the object that does the encryption in both ASP and .NET; I know in .NET you can invoke vb6 objects, and vb6 can...

it's tough, because the relationships in a schema diagram are based on foreign keys...since you can't have a foreign key that references outside of the database you are looking at,...

how about something as simple as a customer to product relationship?

many customers might be related to one or more products, and the products might be related to more than one...

I typically use this, which puts them in the desired order, unless you have some circular dependancies where table A references table B, and eventually a chain of them point...