Why do you need a dynamic statement? I assume you're doing this in a stored proc, if not, adjust or whatever...

I'm also assuming that you know the structure of the...

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...