nice question with good incorrect ones....

Too many queries , too many aliases ; I started to loose patience ...

but it said 2 correct , and found that initially ...

saved the day ..

an easy one to...

nice question...

After reading the file table, I fell on varbinary(max) ..

need to read it again ..

thanks for the question..

good and easy one ...

It threw an error , didn't...

Tava (11/7/2012)

---

SQL-Squid (11/7/2012)

---

Tava (11/6/2012)

---

SQL-Squid,

I was told I can request the app designer to include a primary key in the feed I receive, if that does happen, the merge will...

Jason-299789 (11/7/2012)

---

Tava, you can insert the same record twice with a merge statement, heres a test rig.

Create Table #test_merge_target (

Col1 varchar(10)

,Col2 varchar(10)

)

Create Table #test_merge_source (

Col1 varchar(10)

,Col2 varchar(10)

)

Insert into #test_merge_source

values ('Acol','test...

well, nice one ....got it right to start the morning ..

thanks for the question

SQLMickey (11/1/2012)

---

The temp table's scope is connected to the session, not the variable. After he uses exec @str, he can select out of #temp. A table variable would not work...

28.kanikasoni (11/1/2012)

---

I am getting following errors

first time execution gives this error

Batch execution is terminated because of debugger request

second time execution gives this error

A transport-level error has occurred when sending the...

SQLMickey (11/1/2012)

---

The temp table's scope is connected to the session, not the variable. After he uses exec @str, he can select out of #temp. A table variable would not work...

I don't think it will...

28.kanikasoni (11/1/2012)

---

set @str = 'insert into #temp select GenericVacancyTitleInternalID, GenericVacancyTitleName, NULL ParentInternalID from ReferenceData.TB_GenericVacancyTitle gvt inner join Config.TB_Contract co on gvt.GenericVacancyTitleContractID = co.ContractInternalID where co.ContractExternalID = ''' + @ContractGUID +...

I thought it's highly likely, since the data is not provided , that DatCreated and dateModifed could be repeated ; so basically, Combined with Id is perfect uniqueness considering the...