I just want to be sure what you are asking. You have two indexes on this one column:

One index is a primary...

Have you tried setting up as a 1 column import? You would then split the data from there.

h.schlais (12/15/2008)

---

Hi Lynn, I get the following error:

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.sp_start_job'. The stored procedure will still be...

Are you looking for somethig like this?

select

OrderID,

OrderDate,

ShippedDate,

RequiredDate,

ShippingWindowDays,

...

I don't know if this helps, but you can integrate Reporting Services with SharePoint. You would then use Reporting Services Reports to provide the integration you are looking to...

Check BOL (Books Online). The procedure you are looking for is msdb.dbo.sp_start_job (or in BOL, just sp_start_job).

Good thing I didn't tell people to post here instead in the other thread. At this point, I just want to know what version of SQL is being used.

You could use a derived table in your FROM clause, but a CTE is cleaner.

Do you want a better answer? If yes, then read the following article http://www.sqlservercentral.com/articles/Best+Practices/61537/

and following the guidelines within it to provide us with everything we need to help...

Are you sure it shouldn't be posted here instead of there? One post is in SQL Server 2005 and the other is SQL Server 2008. In the other...

Just noticed, this is also double posted. It is also posted in a SQL Server Experss 2005 forum. What version of SQL Server are you using? And...

Michael Artz (12/15/2008)

---

I need a simple sql statement with a case to determine whether 2 times need to be added or subtracted

the case statement i have works... but sql wont...

May I suggest that you read the article I have referenced below in my signature block regarding asking for help. Based on your posts, I really don't know what...

karthikeyan (12/15/2008)

---

Hi All,

I need quick help.

create table #temp

(

val decimal(16,10)

)

insert into #temp

select 4536426.225

is throwing the below error message.

Arithmetic overflow during implicit conversion of NUMERIC value '4536426.225' to a DECIMAL field .

i...

The only RDBMS system that I know of that allows using stored procedures like tables is InterBase.

It happened to be one of the RDBMS we were evaluating at my previous...