As a side note, please follow the second link in my signature on posting code and data for the best, help. If the intial post contains this information you...

Insert should be the first line, not the last, check my sample code.

Insert into TblExecutives(CompanyName,ExeFName,ExeLastName)

select [Company Name] as CompanyName,ISNULL([Executive First Name 10],'') As ExecutiveFName,

ISNULL([Executive Last Name 10],'')As ExecutiveLName from CompaniesExecutives

Maybe this will help instead http://support.microsoft.com/kb/942176

Then you need to build an insert statement around your select.

Please provide the DDL of all the tables in question, along which which columns from each should be stored into...

Please provide your SQL.

Build an insert statement around the T-SQL you used to generate the result set, like below

INSERT INTO table2 (Col1, Col2, Col3)

SELECT Col1, Col2, Col3 FROM table1

From what I remember, but as with anything related to licensing speak to Microsoft directly or your approved Microsoft reseller.

What are your plans for SSRS, same machine, different machine, SSRS...

SPID -2 is for a MSDTC transaction which is terminated but not cleaned up.

First of all try to work back the transaction to the originating host where the DTC transaction...

Create the login using CREATE LOGIN

Then use ALTER USER in the database in question to re-map the user to the login

Then use sp_addrolemember / sp_addsrvrolemember / sp_droprolemember / sp_dropsrvrolememeber to...

sqlnaive (11/2/2012)

---

I have been looking into deadlock issue. While doing so, was able to track the following spids from sys.sysprocesses at the time deadlock happened:

spidkpidblockedwaittypewaittimelastwaittypewaitresource

7280081310x000D1782LCK_M_RS_S ...

What is your reasoning behind advising the use of nolock? Do you...

Do you have a driver (for ODBC) which can connect to Progress? If so it would just be a case of installing the driver and setting up a linked...

SQL_path (11/1/2012)

---

thank you !!

i tried that but it did not work. can you please tell me what am I missing here?

declare @search varchar(max)

select @search='%cake'

create table #ITEM

(

item_desc varchar(50) )...

What is the problem you are facing as the query is correct all you need to do is remove the % from the where clause if the user will supply...

Thats a pretty big downtime window then for something which seems very trivial to do in scripts instead.

I had dealings with a 3rd party who was like this, we then...