heh he... I know that feeling, I'm currently hiding out on scc from a overdue web project... I tried to convince myself that I needed to brush up on dynamic...

Thanks for the information on this type of database design 🙂

Here's the dynamic version:

USE tempdb

IF OBJECT_ID('#sample') IS NOT NULL

DROP TABLE #sample

CREATE TABLE #sample (empid int, attribute...

Hi there,

I would use a dynamic cross-tab query for this, but I don't see where EMPID is coming from. Can you provide some sample data for this also?

Also, I...

They are two articles I go back to most often here Jeff, thank you.

///Edit - really off-topic, but it would probably be one I would end up constantly referencing -...

Jack Corbett (7/31/2009)

I provided an answer,...

I was suggesting making a temporary database with just table with images in it, backing up this database to a .bak file, transferring the bak file (over network/dvd/however) to the...

How about (something like)..

On source server:

CREATE DATABASE TempTransfer

CREATE TABLE TempTransfer.dbo.DataToTransfer (ID, ImageBlob)

INSERT INTO TempTransfer.DataToTransfer

SELECT ID, ImageBlob FROM SOURCE

BACKUP DATABASE TempTransfer TO DISK 'C:\TempTransfer.bak'

On destination server:

RESTORE DATABASE TempTransfer FROM DISK...

And you can't do a INSERT INTO StagingTable SELECT FROM SourceTable?

Hi,

What are you trying to achieve? Has the data to be transferred to another system?

Here's one for you http://www.sqlservercentral.com/Forums/FindPost763350.aspx, wrong in so many ways I am totally stumped for any response!

Does the database in question have foreign key constraints set up?

Hi,

here is a solution that relies on a tally table http://www.sqlservercentral.com/articles/T-SQL/62867/ and is based upon the code in http://www.sqlservercentral.com/articles/Crosstab/65048/, these are two excellent articles, and I recommend them both highly,...

I think you may be better looking at Fulltext indexing for this problem. This will improve performance of searches and give you built in thesauraus, inflectional and word splitting...

Yeah, I guessed that, I think you have only...

Wow, that was a fast response! Did you have a chance to read the article I referenced above?

Any chance of getting sample data and ddl (create table and insert statements)...