Viewing 15 posts - 1 through 15 (of 52 total)
Hi
Hi,
use the compute column in the table like
create table T2(
T2ID int primary key,
hours int,
T1ID int FOREIGN KEY references T1(T1ID),
totalpay as (T1ID * hours)
)
]
Guy needs total=rate*hours.
Above answer would simply return...
July 24, 2009 at 1:23 am
Hi
Hi,
use the compute column in the table like
create table T2(
T2ID int primary key,
hours int,
T1ID int FOREIGN KEY references T1(T1ID),
totalpay as (T1ID * hours)
)
]
Guy needs total=rate*hours.
Above answer would simply return...
July 24, 2009 at 1:23 am
Hi
Hi,
use the compute column in the table like
create table T2(
T2ID int primary key,
hours int,
T1ID int FOREIGN KEY references T1(T1ID),
totalpay as (T1ID * hours)
)
]
Guy needs total=rate*hours.
Above answer would simply return...
July 24, 2009 at 1:23 am
Hi
Hi,
use the compute column in the table like
create table T2(
T2ID int primary key,
hours int,
T1ID int FOREIGN KEY references T1(T1ID),
totalpay as (T1ID * hours)
)
]
Guy needs total=rate*hours.
Above answer would simply return...
July 24, 2009 at 1:23 am
So, Jamie... now you have 3 tables to maintain instead of just 2. The real problem is this table...
MakeID Make CategoryIDs
1 Dell 1,2,3
2 Sony 1,2
It's not normalized. Tables should never...
July 22, 2009 at 3:52 am
hi,
you can also create an intermediate table -
MakeID CategoryID
1 1
...
July 15, 2009 at 4:26 am
hi,
you can also create an intermediate table -
MakeID CategoryID
1 1
...
July 15, 2009 at 4:26 am
Hi,
Just try this
create table dbo.Results
(id int, ivalue varchar(1000))
insert into dbo.Results
select 1, '1;12345'
union
select 2, '2;212345'
union
select 3, '1;312345'
union
select 4, '1;412345'
union
select 5, '1;512345'
select id,substring(ivalue,0,charindex(';',ivalue)) [ivalue1],substring(ivalue,charindex(';',ivalue)+1,len(ivalue)) [ivalue2] from dbo.REsults
drop table dbo.Results
July 13, 2009 at 3:59 am
I'm wondering if both your tables might have the same column name DLOAN or TLOAN. If so, you need to fully qualify them -- TableName.ColumnName.
Eli
My Guess is that...
July 8, 2009 at 6:50 am
I'm wondering if both your tables might have the same column name DLOAN or TLOAN. If so, you need to fully qualify them -- TableName.ColumnName.
Eli
My Guess is that...
July 8, 2009 at 6:50 am
I'm wondering if both your tables might have the same column name DLOAN or TLOAN. If so, you need to fully qualify them -- TableName.ColumnName.
Eli
My Guess is that...
July 8, 2009 at 6:50 am
Hi,
If you can give DDL(for both tables),along with some data insertion script, it would be easier to solve that.
July 8, 2009 at 5:33 am
Hi,
It can be done with sp_executesql with 'output' variable.
July 8, 2009 at 3:13 am
Hi,
Left is an inbuilt function that returns left part a string starting from 0 and upto the length specified (13 in your case).
Replace is another inbuilt string...
July 7, 2009 at 3:50 am
Hi there,
We'd have to take a look at your SP. In case you're not passing more than 2 GB size parameter you might have used another varchar...
July 5, 2009 at 10:54 pm
Viewing 15 posts - 1 through 15 (of 52 total)