For 2 currencies - skip the dynamic SQL altogether.

CREATE FUNCTION [dbo].[FindExRate] ( @extp nvarchar(10), @dt nvarchar(50) )

RETURNS float

AS BEGIN

declare @s-2 nvarchar(4000)

DECLARE @exrt float

if @extp='USD'

BEGIN

set @exrt= ( SELECT TOP (1)...

Stefan Krzywicki (6/12/2012)

---

Matt Miller (#4) (6/12/2012)

---

Just drag the output line to your destination and pick the Transaction as your source. once you do that and go into the mapping...

Just drag the output line to your destination and pick the Transaction as your source. once you do that and go into the mapping detail in the destination, you...

Stefan Krzywicki (6/12/2012)

---

Anyone have a good resource for how to import XML into SQL Server? The SSIS XML source tool isn't clear on how to insert data into a table...

As I understand it,...

Shooting in the dark here - but this looks to be an "ID reservation system". As in, if you were to look at the parameters, you can reserve more...

Lynn Pettis (6/8/2012)

---

Sounds to me like the someone needs to verify that the webservice is actually doing something with the value being returned. Perhaps a little debugging session on...

As long as it's an "actual" calculation, I'd agree with all previous opinions. If calculation comes to mean something having to do with actually formatting the output, then put...

You need to switch to the control flow view. Chances are you are in the data flow view which is one level below control flow (control can call and...

As I understand it, it's in every edition starting with Express Edition with Advanced Services and up. As I understand it - there's no option to install it using...

This will do it for you.

declare @qtr int, @year int,@Startdate datetime

select @qtr=2,@year=2012

select @startdate=dateadd(month,(@Qtr-1)*3,dateadd(year,@year-1900,0)) --0 is 1/1/1900 which is a monday

;with TallyCTE as (

select row_number() over (order by (select null))-1...

Mountain Steve (6/6/2012)

---

yes we have the order by statements. Not sure why the reluctance other than in the past the other non dba developer relied on static data to...

richardm-1037631 (6/5/2012)

---

GSquared

Creativity != "that's how we always do it"

I would like to suggest a 3rd option to remember:

"that's how we always do it" != Reason to change

Just because something...

SQL Kiwi (6/1/2012)

---

Of course there is. You just can't depend...

I'm surprised it hasn't been mentioned before, but I do hope you have some way to actually define the ordering within the table. A common stumbling block is to...