how was the copy created the first time around?

is there a need to keep this copy updated with the data in the first DB? if so what is the...

DiverKas (5/8/2012)

---

anthony.green (5/8/2012)

---

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2...

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2 denotes a...

will the filename be exactly the same and in the same directory every time the import needs to be run? if so one of the last screens is run...

please provide the create table definition and some sample data.

use the text qualifier on the import screen and set it to " this should then remove the " when you look at the csv in the preview

thanks, can you also provide the create table command as well for the table and a few insert statements for some data within the table (granted data maybe sensitive, but...

it is substituting 0 with the default date of '1900-01-01 00:00:00.000'

If only a time value is assigned to a variable of a date data type, the value of the missing...

what is the error?

can you also detail the full query, including tables and sample data as per the second link in my signature block to help us create a mock...

can you detail the error

if your trying to put a uniqueidentifier into an int column it will not work as this conversion is not allowed

you need to set the variable = null

CREATE PROCEDURE dbo.GestionStatutDossier

-- Add the parameters for the stored procedure here

@StaId int = NULL,

@DosID uniqueidentifier,

@staDate datetime,

@staBL nvarchar (50),

@staCRprod nvarchar (50)

AS

depending on what you want to learn and what you already know the official MS courses for 2008 are

6231 - Which is more on the admin side

6232 - Which is...

same table same server? same table different server?

can you post the code you executed, including the DDL definitions of the objects involved in the query?

your trying to insert more than the column can hold, for example inserting a string of 100 characters into a column which can only hold 50.

i would identify which column...