Rounding in itself is a business decision. As in- it's usually a design constraint imposed by the byusiness on how it SHOULD work. No matter how you look...

SQLKnowItAll (5/23/2012)

---

drew.georgopulos (5/23/2012)

---

not so good...there are business analysts interposed between the report requestor and developers, so developers rarely speak to the end user.

My feeling is that GSquared's suggestion hits the...

Put a "use" clause in the dynamic statement.

Something like:

Declare @SQLExec varchar(1000),

@BackName varchar(8),

@dbname varchar(100)

Set @BackName = replace(convert(varchar,getdate(),101),'/','')

Set @dbname = 'Database2'

-- select @BackName

Set @SQLExec= 'use ['+@dbname+'];'

Set @SQLExec = @SQLExec+'if exists (select...

Take the Exec out and print the SQL statement instead. You will see that the string is missing a bunch of apostrophes around items.

This should be about right.

Declare @SQLExec...

Gazareth (5/21/2012)

---

Yes, the Team Foundation Server MSSCCI Provider mentioned previously allows you to do this.

(Open an existing DB solution from TFS in SSMS).

There's no way to enforce changes to the...

khushbu (5/21/2012)

---

Working in restricted environment is pain.. and not having access to windows server is double pain..

Sometimes, I need to check eventviewer for any errors etc.. and to check this...

Jeff Moden (5/18/2012)

---

Matt Miller (#4) (5/18/2012)

---

As while you are correct that the compiler currenly isn't smart enough to detect the stored proc call, you are going against the intended use....

Michael -

I think the issue is "not enough info".

There are a fair amount of folks on here that enjoy a nice challenge, but implementing a resonably complex...

The 2012 functionality within the += operator IS in fact a concatenator (if you use it with string data types). As long as you don't particularly case in which...

The list of "allowed constructs" is out of Books Online, and is very specific about what can and cannot be called within a function. It's intended to be an...

preetham gowda (5/17/2012)

---

Try it

Create Function dbo.Fun_Proc_Test1(@id1 int) Returns varchar(30)

As

Begin

Declare @res varchar(30)

--Set @res = (Select * From OpenQuery(ABHI, N'Declare @result varchar(30) Exec Abhi.Test.dbo.convert2Lower @id = ' + Cast(@id1 As Varchar(5)) +...

OP = Original poster. in this case - you:-)

I'd look at using a work table with a good index on it to track the combinations. The best performance would likely be if you can set up a...

And thank you gemisigo for allowing us to trample over your initial topic. Didn't mean to hijack it.

Thanks Howard for the input.

And...