magyar - it would be something like...

insert into tblSchool(SchoolName, SchoolCounty, SchoolType)

values(@SchoolName,

@SchoolCounty,

@SchoolType)

insert into tblNetwork(NetworkType)

values(@NetworkType)

...etc...

What is your query...at any rate here's some info from source

Troubleshooting

Error 913

Severity Level 22

Message Text

Could not find database ID %d. Database may not be activated yet or may be...

hey remi - this's what I have from the microsoft website...

max parameters

"@parameter

Is a parameter in the procedure. One or more parameters can be declared in a CREATE PROCEDURE statement....

Your stored procedure will know because you tell it in your t-sql - eg: parameter1 goes to tbl1, parameter2 into tbl2 etc...

I thought it was 2100...!!!

at any rate...I know I'm happy when I don't have to pass more than about 10 (max in my procedures...thank...

Erik - now I'm confused - in your table def for AttributeExtendedValues you have:

CREATE TABLE [dbo].[AttributeExtendedValues] (

[AttributeExtendedValuesID] [int] IDENTITY (1, 1) NOT NULL ,

[AttributeID] [int] NOT NULL ,

...

Erik - shouldn't you be doing:

INSERT INTO AttributeExtendedValues

(AttributeID,ProductImages)

SELECT...

hmm - I know exactly what you're asking but have no idea if this can be done with a sql select - I keep thinking it would help using ascii...

Mark - I'm sure someone else will come along who has a better comprehension of your question....this is what I understand you want to do with the first part of...

Well - your database is case insensitive - so you have one of two options...either make the whole database case sensitive or make only the column/s that you are referencing...

Richard - are you looking for something like this:

SELECT B.StockCode, MAX(B.QtyOrder) AS QtyOrderd, MAX(B.QtyScanned) AS QtyScanned, (MAX(B.QtyOrder) - MAX(B.QtyScanned))AS QtyRemaining

FROM

(SELECT StockCode, SUM(QtyOrder)AS QtyOrder, 0 AS QtyScanned FROM #tbl_LLDT WHERE LLNum...

G.A.L remi...

if you're asking me remi - NO - I'm not sure...making assumptions!

did you try :

select B.BetID,B.Num1,B.Num2,B.Num3,B.Num4,B.Num5,T.TypeName,T.TypePrice

from Bet B

inner join

Type T

on

B.TypeID = T.TypeID

.....and if it's only for a specific TypeID you would do:

select B.BetID,B.Num1,B.Num2,B.Num3,B.Num4,B.Num5,T.TypeName,T.TypePrice

from Bet B

inner join

Type T

on

B.TypeID = T.TypeID where

B.TypeID =...

- one way of doing this would be to select distinct(field name) into another table..

but it would help to have more details on your table with duplicates!!!