this sounds very much like a homework assignment....

aside from that...

you want to do a few things....

you said only three specific values.... as you suspected, read about CHECK CONTRAINTS in you...

try something like this:

select gpsdata_history.*

from gpsdata_history

inner join

(SELECT

REGISTRATIONNO, MAX(GPS_DATETIME)

FROM ...

here's how i would do it:

first id read everything into a single string, instead of line by line.

then i could use substring functions to find what we need instead.

...

there is a free open source project that is a 2005 profiler, independant of MS;

I use it all the time and it is very good.: very small footprint and you...

i have this code saved in my snippets hat might help you; it featues two of the things you might want: BCP of data, and appending multiple files together.

the original...

i've pasted a script below that shows how to get the listening port by reading the registry, and as the previous poster said, you could write to that spot as...

something like htis might help:

it detects the compatibility level...

IF EXISTS(SELECT cmptlevel from master.dbo.sysdatabases WHERE master.dbo.sysdatabases.name =db_name() AND cmptlevel...

a backup created on 2008 can only be restored on a 2008 instance; theactual format of the file is different due to the new features.

this is true of all backups...while...

compatibility level sets what set of syntax rules will be used for commands agains the database; it does not change "how" the data is stored or backed up. think about...

abstract examples are harder to help wiht, but here's an example:

--does this return data?

SELECT

OtherDatabaseT2.RowID,

OtherDatabaseT2.StaffID,

OtherDatabaseT3.SSo_RowID,

OtherDatabaseT3.LogonStaffNo

FROM Otherdatabase.dbo.[Table 2] OtherDatabaseT2

INNER JOIN Otherdatabase.dbo.[Table 3] OtherDatabaseT3

...

i've got this saved in my snippets of code; i added the bolded where statement to ignore clustered indexes:

[font="Courier New"]

SELECT TOP 100

REPLICATE(' ',4000) AS COLNAMES ,

OBJECT_NAME(I.ID) AS TABLENAME,

I.ID AS TABLEID,

I.INDID...

looks like a simple IN() stamtent would do the job...you want the entire order if one of the porducts is 'Bike':

Select

oph.order_no,

opd.order_line_no,

opd.product,...

why not convert them to ints, then cast then as varchars together?

CREATE TABLE T1(col1 varchar(30),col2 varchar(30) )

insert into T1

SELECT '1','09' UNION

SELECT '02','01' UNION

SELECT '01','1 '

SELECT

convert(varchar,convert(int,col1))...

I think you'd have to do this with a quick and dirty .net applacation, since it's obvious you can't on the server side:

i would think that you'd have to recursively...

try changing just the offending columns with CAST or CONVERT, and not the whole formula:

CAST(beschikbaar * 60 AS float)

changes to

CAST(beschikbaarAS float) * 60

I think that will solve your...