What is the question? Are you trying to create a function that receives two parameters? If you can clearly explain what you are trying to do we can help.

Please don't cross post. It just fragments your answers. Please direct all replies to the original thread.

http://www.sqlservercentral.com/Forums/Topic1207019-1063-1.aspx

This looks pretty good. However your select statement is not quite correct. You need to get the status relative to the row in inserted. The way your subselect is coded...

Not exactly sure what the question is here. But you certainly don't need to create a temp table to hold one column of data from a permanent table to use...

Try it out and see what values you are using.

select DATEADD(M, -2, GETDATE()), DATEADD(M, -1, GETDATE())

Remember that if you don't understand the code you are running you could be running...

So you can only have 1 open connection at a time? Are you using Access?

Pretty sparse on details but we will see what we can do.

Can you connect to the database is SSMS with the same credentials you are using from your application? Double...

No problem. Sounds like you need to find a way to get some time off. 😉

Let me know if still need some help with this and we can take a...

Could be. There are certainly a number of other things in sql server to avoid unless it is absolutely necessary (cursors, sql variant, xml, etc). As with all things sql...

Well given that you didn't post any ddl, or sample data it is impossible to tell what might be wrong.

The query you posted looks on the surface like it would...

What is the issue? From the sample you posted it looks like your totals are correct.

I have to disagree with that sentiment. Display formatting should be left to the...

corder (11/15/2011)

---

Does anyone have thoughts on the differences between these statements?

DECLARE @Result varchar(10) = ''

IF 1 > 0 BEGIN Select @Result = 'True' END

SELECT @Result

Versus

DECLARE @Result varchar(10) = ''

SELECT @Result...

...but that is...

That...