Vladan (12/14/2008)

---

Garadin (12/12/2008)

At the time an invoice was generated, you'd look at your most recent record for Dollar > Euro conversion, calculate the amount in Euros and store those numbers...

While it may be possible to do this directly from excel, I would do it as follows:

Import the excel sheet as a table using the import wizard.

Update the original table...

Gotta be a little more specific with "do something interesting".

Are these databases on the same server?

If they are, you can extract the information like so:

SELECT *

From Database1.dbo.Customer C

...

Untested due to no sample data, but something like this should work:

SELECT R.ResourceID, PC.RCount

FROM ResourceTable R -- This should be a table holding your 23 types if you have one

LEFT...

gamache (12/12/2008)

---

Garadin (12/12/2008)

---

Oops, I ran that on my 2K8 test server.

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c)...

All this Tab -> spaces debate made me curious... so I did a little test. I'm guessing this is due to it mimic'ing html or something when...

Jeffrey Williams (12/12/2008)

---

Garadin (12/12/2008)

---

Roger that. Just made the change. Mine was set to 8. It always kinda bugged me that it was so big, but never really...

. )

)

)

)

You copy and paste a tab from elsewhere =).

For your table, this would likely look like this:

CREATE PROCEDURE [dbo].[TEST_SS2K5_PAGING3]

@slice_size INT = 1,

@slice_start INT = 1

AS

;WITH Paging AS(

SELECT Users.*,

ROW_NUMBER() OVER(ORDER BY lastname, firstname, user_id) 'RowNumber'

From...

Oops, I ran that on my 2K8 test server.

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft...

Modifying your SP to use a Tally table (Sorted DESC so you can more easily see) instead of your user table, I get these results.

20000

19001

20000

20000

Which seems correct.

Modified code below:

ALTER PROCEDURE...

I'm guessing that unless your users are accessing the server directly, you aren't going to be able to extract this information in T-SQL. If you're going through an ODBC...

The logic behind it is this. It's a very common use of outer joins that makes a lot of things very easy.

[font="Courier New"]DECLARE @YourView TABLE(

I    INT,

V    CHAR(1))

DECLARE @YourTable TABLE(

I    INT,

V    CHAR(1))

INSERT INTO @YourView(I,V)

SELECT...

Lynn Pettis (12/12/2008)

---

Steve Jones - Editor (12/12/2008)

---

Tab settings can be inconsistent, and so if you try to line things up, or open someone else's code, 2 tab stops could result...

http://msdn.microsoft.com/en-us/library/aa337114(SQL.90).aspx

--[Edit]--

Heh, oops. Beat me to it.