I would like to use the output of the stored procedure sys.sp_tables in the
AdventureWorks database to iterate thru the database tables (ultimately I
want to export the table contents to external text files, however, for now I
am merely wishing to determine how to use the output of stored procedures in
further scripts). I presume this must be possible? Could someone advise me
of the syntax required?

Thanks

Hey guys,

I recently picked up a new x64 laptop and I can't install MSSQL 2008
Developer on it. As you as you run it, it says that .NET 3.5
installation failed and that I need it to continue the installation.
However, I've check my laptop and I have both 3.5 x86 and x64. What
could be going on?

Thanks
Maz

Hello,

I am looking for information about different version of SQL server 2008. I
found information about different version of sql server 2005, but nothing
about SQL server 2008. Where can I find these information. Where can I find
pricing information?

Best regards

Hi All,
Does anyone know if there is a way to capture 2 column values from a SELECT within a SQL script and use them for later processing?

For example, I have:
SET @loaned=(SELECT on_loan FROM copy WHERE ...)
Only 1 row is returned.
I can then use @loaned in an IF test. But I also want a 2nd column value from the same table. I don't want to run the query twice. Is there another way??

Thanks much

Jonathan

Hi everyone,

I know I can create a composite primary key. I was wondering if it's also
possible to specify a composite "uniqueness constraint". Here's what I mean:

I have two two columns (not part of a primary key) that should be unique in
the table. Neither column is unique on its own but together they are unique
in the table. Is there a way to specify such a constraint?

Thank you

Hi All: I have timesheet project where there's three tables:

time-cards
time-card-hours
time-card-expenses

for any given employee's timecard, it will have a uniqueID that's used for a
one-to-many relationship in both expenses and hours.

I wanted to be able to sum the expenses and hours for a given timecard in a
single query, and tried a query like:

select sum(hours), sum(expenses) from time-card-hours
inner join time-cards on time-cards.uniqueID = time-card-hours.uniqueID
inner join time-card-expenses on time-cards.uniqueID =
time-card-expenses.uniqueID
where time-cards.uniqueID = 'theID'

but joining against both tables returns duplicate rows

Is there an easy way to do this, or do I need to do two separate queries?

TIA

I've just been laid off and I am freaking out (new wife, new baby 2 months
away, new house yada yada yada). (not recommended at this time)

Apart from the usual jobsites, (dice, monster etc) what is the best place I
can go to get a job using dotnet? I have been programming for 2 years in
dotnet and have MSSQL experience. My current title says "Junior Programmer"
but I think I have sufficient experience now to drop off the "junior"
prefix.

Any ideas, please!

I am in San Antonio, Texas.

Hi,

I have the following:

SELECT Code, Commune, Qtr, CAST(F / Meetings AS decimal(8, 2)) AS Expr1
FROM dbo.[2-2-3-f Source]

The Expr1 result give me all the integer (eg 22/6=3.666), the result show
3.00. Where is the decimal part?.

Did I miss something?

SF

Hi,
I'd like to list all the active policies which didn't have claims from the
following tables:

tblPolicies
P_ID
P_Number
P_Date_in

tblClaims
C_ID
P_ID
C_Number
C_Date_in

The following syntax is incorrect because I guess I should use IF EXISTS
instead of INNER JOIN but just cannot seem to get it right.
Any help is appreciated.
Edu

SELECT *
FROM tblPolicies P INNER JOIN tblClaims C on P.ID = C.P_ID
WHERE P.P_Date_in > getdate()

Hi,

I have two tables in a SQL2005 database that have exactly the same
structure. One of them contains today's data and the other yesterday's
data.

I want to select all of the rows in today's table where the value in
the STATUS column is different from the value of the STATUS column in
yesterday's table.

I thought something like

SELECT * FROM today
WHERE today.status <> yesterday.status

might work but it doesn't. How can I achieve it?

Thanks
--