steve 50602 (1/13/2013)

---

Thanks, I actually do have such a table (it translates status id to name and description), so its pretty easy to just add another column with the sort...

opc.three (1/13/2013)

---

Naturally. It, like sys.xp_cmdshell, is disabled...

luissantos (1/13/2013)

---

Hello comunity

I have create this function to return total pairs:

CREATE FUNCTION [dbo].[fnQtRefCor]

(@bostamp varchar(25), @ref varchar(20), @cor varchar(50))

RETURNS int

AS

BEGIN

DECLARE @retval int

SELECT @retval = SUM(qtt) FROM bi

WHERE @bostamp = bostamp...

opc.three (1/13/2013)

---

One of the many advantages of using the SQLCLR over xp_cmdshell for interacting with the file system is that if the user connected to SQL Server under Windows Authentication...

durai nagarajan (1/13/2013)

---

Jeff Moden (1/13/2013)

---

There are some mitigating factors such as whether or not the database has been changed to bulk or simple recovery modes but, if no such thing...

durai nagarajan (1/13/2013)

---

Hello All,

Is it posible to restore to any time in point in restore. i am getting issues if i have to restore to date before to the time...

I answered this over here.

Simplest answer I can give you is that you are trying to use MS SQL Server based code in MySQL and MySQL doesn't like it.

This is a Microsoft SQL Server...

Have you read the following plus the related links in the article?

http://msdn.microsoft.com/en-us/library/ms188623(v=sql.100).aspx

Then I suggest reading the following:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

Did you follow the link in that msdn article you referenced, http://msdn.microsoft.com/en-us/library/ms189977(v=sql.105).aspx? It does a good job of explaining what happens.

Once I figured out you meant crore and that is 100 lakh, all I can say is it may take a while to rebuild 19 nonclustered indexes on a table...

This is what I developed:

CREATE TABLE #Test

(

ProductID int,

MainMasterFeatureID int,

MasterFeatureValue Varchar(100),

ChilFeatureName varchar(100),

ParentFeatureName varchar(100)

);

INSERT INTO #Test

SELECT 40,1,'1','Pack','Type'

UNION ALL

SELECT 40,0,'Laminate','Technology','Technology'

UNION ALL

SELECT 40,11,'1','Yes','Coated'

UNION ALL

SELECT 52,1,'1','Roll','Type'

UNION ALL

SELECT 52,11,'1','NO','Coated';

select * from #Test;

go

select

...

If I read you correctly, you want to pass the name of a table, any table, to a stored procedure and run a query against...

Lynn Pettis (1/10/2013)

---

I guess you aren't supposed to leave negative comments on articles like this one, http://www.sql-server-performance.com/2012/sql-tuning-tvf-scalar-functions/. I took a bit of an exception to the article and left...