YesChris, you told this earlier. Here is the...

Check the below article for more info on it.

The GO Command and the Semicolon Terminator[/url]

pbreitenbeck Posted Dec 10, 2008 @ 4:47 PM

SSC Veteran -

I basically understand everything in the block of code below, except the last two lines. I understand that...

You can do this by constructing a dynamic query using the PIVOT operator. You can take help from the article in the below link in doing it.

Dynamic PIVOT in SQL...

Are these the only dates in the DATE column in the table

timscronin , you can use PIVOT clause for this solution if you are on SQL Server 2005 as follows. I notice that your table allergy has a column patientid but...

Try this and let know this is what you require. Note that you should provide sample data and script for better response.

create table MachineName (machineName varchar(50), machineID int)

insert into MachineName...

I am really thankful to you Paul for your reply and alleviating my concern. It prompts me to explore more this 'B-tree structure' thing, quoted so much in the BOL...

Thank you very much Paul for your elaboration. However, I have just one doubt.

Paul Randal 12/4/2008 10:50 AM

-------------------------------------------------------------------

It's not a B-tree (either the classic B-tree, or the B+-tree that...

ntext and bvarchar(max) can store the same amount of data (2 GB maximum or a 16-bytes pointer).

I fact SQL 2005 has depreciated the NTEXT in favor of NVARCHAR(MAX), though NTEXT...

Ah yes. You'll need to join the inserted table to the source table, otherwise the insert will try to insert all rows from the table to the destination....

nazaninahmady_sh,

The problem here is that you are missing the table name after the FROM...

steveb is right. Following is the sql for the solution provided by him. In fact I missed this idea earlier. I am just modifying his idea a little. There is...

You can split the data out into two seperate staging tables, one for Firstname and One for LastName

Then use another dataflow to load these both up and join them...

This will work if the user has at least the 'CONNECT' role