You wanted to use MERGE, didn't you:

MERGE Something_Destination...

+100

GSquared (11/2/2012)

---

Not just...

It's possible with using Dynamic Sql. Here just a small sample, but you should be able to get your one from here:

-- that could be your proc input parameter:

DECLARE @ColumnName...

Jason Selburg (11/2/2012)

---

Eugene Elutin (11/2/2012)

---

Try this:

DECLARE @sql VARCHAR(8000) = 'SELECT * FROM FROM sys.objects'

SET @sql = 'SET NOEXEC ON;

' + @sql + '

SET NOEXEC OFF;'

BEGIN TRY

EXEC...

What I can say? Have you tried to search this site?

Check it here:

http://www.sqlservercentral.com/Forums/Topic796803-338-1.aspx#bm796805

As I said, you don't need to create function for this, especially the one you have which unnecessary...

kapil190588 (11/2/2012)

---

Jason,

I am getting the data when i run the query that you sent..

I have added condition in where statement like this:

where Compare1=Compare2

But it gives an error that:

Msg 207,...

Try this:

DECLARE @sql VARCHAR(8000) = 'SELECT * FROM FROM sys.objects'

SET @sql = 'SET NOEXEC ON;

' + @sql + '

SET NOEXEC OFF;'

BEGIN TRY

EXEC (@SQL)

END TRY

BEGIN CATCH

...

Just output the content of your @Command before executing so you can see the built SQL statement.

You can debug it and find what is wrong with it.

You don't need a function for this.

Just use Datediff:

select DATEDIFF(year,@in_DOB,GetDate())

what is inside of

@SortFieldIndex and @OrderBy ?

Looks like you are mixing dynamic and static sql together, it's not going to work...

Sean Lange (10/31/2012)

---

Mackers (10/31/2012)

---

Hi Chris,

The SQL is quite hard to read (and I have never come across case statements & cursors used like that before) but rather than using a...

Change SqlCommand.CommandTimeout to higher number. Default is 30 sec...

Is any rule for a splitting by Rid?

Will you pass Rid range boundaries as input parameters into stored proc or you will have them stored in some other table?

Yes, exactly...