The task seems to be straightforward.

What would you need the dynamic sql for?

Couldn't you just pass the VARCHAR(MAX) value, the @where variable and the call of fnDelimitedSplit to the dynamic...

Is there any specific reason for using the least preferred method?

LOL! True. Didn't consider that "alternative". Glad I'm in Europe. Might...

Alvin, that's what you look like when you've had time to shave?!? 😀

But isn't that counterproductive regarding hunting season?

Digs (11/23/2010)

---

Hi,

I have a need to Script a where clause from client side and send it to the server to execute in dynamic sql.

The issue is that the table...

@Ron:

I guess the OP is all yours from now on. 😉

At least (s)he's letting you know that you're getting closer...

In order to get the monthla split I'd probably use a...

I'm getting confused...

First you posted table def for [Tenants] and [Buildings] including sample data. Good point to start with...

When I asked what you've tried so far you posted different DDL...

You can't use a GROUP BY within your update statement directly.

It's not really clear what you're looking for, but due to the GROUP BY aggregation I have to assume you're...

So, what have you tried so far?

@shyaagi: The row_number() approach requires to specify a column that would define the order.

Unfortunately, I cannot find an...

Please see BOL (BooksOnLine, the SQL Server help system usually installed together with SQL Server) for the correct syntax (SET before FROM part):

UPDATE [dbo].[progoogle]

...

Ok, let's start at the very beginning:

How long does it take to run the code in SSMS that is called within the job?

If it consists of independed code blocks: How...

vs. previous post

Please tell us the error...

pavan_srirangam (11/22/2010)

---

thanks any way

one last question

If I add more .ndf files to the database will reduce pagelatch_up waits and resource is 5:1:3 no.

Because I found there are...

You would need dynamic SQL for this. Something lik the following:

DECLARE @database NVARCHAR(128)='dbDRCT_1'

DECLARE @sql NVARCHAR(2000)

SET @sql='SELECT *

FROM ' + @database +'.dbo.tblAuditMasterLog'

PRINT @sql

--EXEC (@sql)