quote:

---

Is there any other way to pack the data pages on a non-clustered table?

---

No;...

dbcc DBREINDEX(TableName)

or you could try dbcc INDEXDEFRAG.

--Jonathan

STUFF(ColB,1,2,'')

--Jonathan

quote:

---

Great function, particularly as an example of using table datatype and while LOOP. However, be careful that this function does not...

quote:

---

It would appear to me, that there is a potential problem with both of the below code snippets. If State is...

quote:

---

Jonathan,

Don't you mean

ORDER BY Test DESC 

Your solution works because the marks are in ascending order with...

quote:

---

I am showing my ignorance here, but could somone tell me what the 's' is after the 2nd select statement in the...

quote:

---

Having one payments table would work fine for one-off payments such as credit card, cash etc, as I could record the amounts...

I would need to know more about the application to be sure, but I have worked on (too) many financial systems, and IMHO you should have one Payments tables and...

quote:

---

Thanks for the feedback, I will give those suggestions a shot.

As for the use of an Integer as a bitmask - I...

quote:

---

So the question is, am I missing something or SQL Serv doesn't allow more than one col to be referenced in a...

CREATE FUNCTION dbo.f_TransParts(@part int, @comp int)

RETURNS tinyint AS

BEGIN

DECLARE @Transitive table(Part int)

INSERT @Transitive

SELECT Part

FROM Bom WHERE Comp = @Part

WHILE @@ROWCOUNT > 0

INSERT @Transitive

SELECT b.Part

FROM Bom b JOIN @Transitive t ON b.Comp...

SELECT Student, Test, Marks,

(SELECT AVG(Marks)

FROM

(SELECT TOP 3 Marks

FROM Marks

WHERE Student = m.Student AND Test <= m.Test

ORDER BY Marks DESC) a)

FROM Marks m

--Jonathan

Edited by...

You're almost there. If you're using SQL Server 20000, simply recast your method as a UDF:

CREATE FUNCTION dbo.f_ListAttribs(@attribs int) RETURNS varchar(1024) AS

BEGIN

DECLARE @list varchar(1024)

SELECT @list = ISNULL(@list + ',...

quote:

---

Hi,

Is there any way that I can query all my user tables to find in which table a certain fieldName...