Now I want to create a dynamic function, which can be used...

Jeff, I work with TSQL all day long, and I do read & enjoy your pieces on here - But I don't see that you've solved his problem? :ermm: How...

Hi,

As you've no doubt guessed - You can't execute a stored procedure from a function:

Msg 557, Level 16, State 2, Line 1

Only functions and extended stored procedures can be...

Are the 100+ tables all the tables in the database? Just wondering if you could set up a dataflow that pulls all the names from sys.objects into a temp table/table...

Mahesh (3/14/2008)

---

Thanks a lot Sarversh for such a Humble reply. (En firangiyonki to mai ek din **** ...) 😉

GSquared and Leo Mepham, ... I will develop one forum site. Obviously...

Can anybody tell me, in detail, what is the difference between a genuine request for help and homework?

😉

For an output parameter like that, I've been using ParameterDirection.Output - Which works well for me, after some issues with ensuing the names were all correct.

As an example:

...

Did you set the configuration in the scheduled task? When you create a step, you select the package from the 'General' tab, then the configuration from the 'Configurations' tab. Do...

Your loop is wrong, you set the variable to be one - Then you say 'While variable is GREATER THAN twelve'! :hehe:

Also, I assume your dbo.GetMonthName function is OK?

Best wishes...

Ties perhaps? Could you give more detail? How many columns, what type? What is the underlying view you are selecting from?

Hi,

I'm in a roughly similar situation, I have a table with company name (Nvarchar(255)), and company address (All address pieces mangled together in an NVARCHAR(1000)). I need to match...

Hi Rob,

Just replace the CTEs with the relevant SQL as subqueries:

SELECT * FROM

(

SELECT

SitePK,

SiteName,

SiteTag,

GroupingCount,

RowNumber,

DENSE_RANK() OVER(PARTITION BY GroupingCount ORDER BY SitePK) AS DenseRank

FROM (

SELECT

SitePK,

SiteName,

SiteTag,

NTILE(2)...

Hi Rob,

This is my first post to this group, but I do find it an invaluable resource so I thought I'd try giving something back.

This query requires SQL...