Hi all,

thanks for your time, that's excatly what i want !

thanks for all

Christophe

Hi all,

i'm a beginner in t sql and i have a table with some field, text and date

i have in one row two date

dateStart ...

Hi everybody,

thanks for your explanation , all is clear now for me !

@john-2 Marsh, what the $weather$ in luxembourg, always great 😉

Bonne journée a vous tous

Christophe

hi all,

thanks for your time and your solution that s works fine !

i'm happy !

have a nice day with...

Hi,

it will be a windows task who runs every day night

have a nice day

Christ

HI all,

thanks for all that's work perfectly !

here is it my little code in my sp

-- DETERMINE IF WE HAVE THE FRIST DAY OF THE MONTH

SET @day = (select DATEPART("dd",...

Hi everybody here is it my solution :

SELECT TOP 1 statut as statut1 FROM

(

SELECT TOP 2 statut FROM DESCRIPTION_FLUX WHERE DescriptionNumero = 202

ORDER BY majdate desc

)

test

ORDER BY statut1...

Hi,

in fact i must to get the before last inserted value !

here is it the flow, i update with an interface my table and statut can be 0 to 13

0...

all right !

that's exactly what i want !

thanks for your time !

Have a nice week end

Christophe

Hi florian,

where i can find this tool !

i use of course management studio in sql server 2005.

i have create a db name DB_COPROPRIO and now i must to create all...

Hi everybody,

thanks for your time

yes i can use for to have information from other database i can use the database name

select * from databaseOther.dbo.deno1

Have a nice day

Christophe

hi,

thanks for your comment but it's not a course it's on a society !

it's not me the database administrator but i have a littile developement that i must to realize...

Hi,

here is it the table definition:

table1 => description_poste

field => descriptionPosteId (pk), numero (int), version (int), desPosGen (int), history (int)

table description_poste_flux

field => descriptionPosteFluxId (pk), descriptionPosteNumero (int), statut (int)

I want to have...

Hi Andrew Peterson,

thanks for your information !

is it possible to have a little sample about a function who returns a table !?

I'm a beginner of sql server a really !

Thanks...

Hi guys,

thanks you for your knowledge...that's exactly what i want !

thanks for all

Christophe