Don't think that's going to work, since @vtbl is a table type variable. If it was a string would be fine.

It's a scope issue. The variable only exists at the outer level (where it was declared) so when the dynamic SQL executes, the table variable is not visible.

See BoL under...

Almost right

UPDATE BalanceTable

Set Vendor = VendorCodeTable.Vendor

FROM VendorCodeTable

You can optionally add a where clause after to do joins e.g.

UPDATE BalanceTable

Set Vendor = VendorCodeTable.Vendor

FROM VendorCodeTable

WHERE BalanceTable.Region=VenderCodeTable.Region

HTH

Actually, come to think of it, it can.

SELECT MAX(Element) FROM Table WHERE Element NOT IN (SELECT TOP 1 Element FROM table ORDER BY Element DESC)

Replace TOP 1 with whatever you...

Select max(element) AS SecondLargest FROM

Table WHERE Element!=(SELECT max(element) FROM Table)

Unfortunatly not adaptable to give the third largest, etc. I'm sure someone around here has a more adaptable solution.

Eeep, sorry.

Remove all references to id and remove the group by in the inner query. I was thinking of somethng else.

SELECT actionstatus, actiondatetime FROM tbl INNER JOIN

(SELECT MAX(actiondatetime) AS...

I assume you have some column that is unique. For the purposes of the eg, I will call that column ID. Also calling the table tbl

SELECT actionstatus, actiondatetime FROM...

SET ANSI_NULLS ON

GO

SET ANSI_WARNINGS ON

GO

CREATE PROCEDURE [procTest]

AS

SELECT Shift_num

FROM [bell-sql].CabTS.dbo.Shift

GO

Ownership confusion, most likely

First it should be

CREATE FUNCTION dbo.nvl(....

then call it

select dbo.nvl('123', '321') from my_table

You could try and make the input and output datatypes sql_variant. It's not overly efficient, and may cause problems with implicit conversion, but should work.

What you've created there is a computed column in the table, not a column with a default. The function is recursive as written, and will call itself without end, which...

Not sure how you want this displayed

This is the easiest:

That can be achieved by unioning the selects together

select '-Total-' AS Title, count(*) AS...

Are either of the boxes Server 2003? If so, you might want to check this out.

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

One thing to note is that bit fields are only really useful if there are multiple of them in a row.

From BoL

"If there are 8 or fewer bit columns...

An update statement may only target one table.

I don't know what the update statement looks like, but it sounds as if you're trying to update RaceLog and RaceLogRslts in...