Frank Kalis

Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 5,356 total)

RE: Cluster That Index! Part Two

Hi Chris,
quote:
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp
this is no...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 21, 2003 at 12:43 am

#466146
RE: Domain aggregate function

Hi kiberu,
quote:
How do you put a calculated value eg. sum of all entries in the footer of a data entry form in...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 21, 2003 at 12:38 am

#466145
RE: Optional search conditions

Hi Tomi,
quote:
There's only one problem. It doesn't take advantage of possible indices i.e. it does an index scan when it should do...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 21, 2003 at 12:30 am

#466144
RE: Numbering the Result Set - Like Rownum(ORACLE)

Hi Anil,
quote:
I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM (Oracle) in...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 21, 2003 at 12:23 am

#466143
RE: one terabyte of data

Hi Jugal,
quote:
Currently we are using san storage to store files in pdf format. This has led to space issues on the disk....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 21, 2003 at 12:19 am

#466142
RE: Domain aggregate function

Hi kiberu,
quote:
Alter Procedure QryOrderFooter
(
@OrderId int OUTPUT
)
As
SELECT OrderId,QTY,QtyValue, (QTY * QtyValue) as Revenue
FROM qryOrder
WHERE (qryOrder.OrderId...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 20, 2003 at 11:57 pm

#466139
RE: Numbering the ResultSet - Equivalent of Rownum

Hi anilg,
quote:
Thanks, but the problem is i cannot add a column to the database. All i can do is change the queries...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 8:16 am

#466056
RE: Domain aggregate function

quote:
Error message, that Domain aggregate functions not allowed in VBA?
I've tested this one
Me.Text2 = DSum("[id]",...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 8:01 am

#466051
RE: Domain aggregate function

quote:
Correct, Moved to ACCESS ADP and my forms have gone beserk!
FE is in Access 2K (Office 2K SP3)
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:51 am

#466039

RE: Review: EditPlus

quote:
Another editor that is similar to EditPlus, and way more powerful is HomeSite. It isn't free, but it's only around $60...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:46 am

#466035

RE: Domain aggregate function

Just another thought.

Are you moving from Access to SQL Server?

Will Access be the Front-end or will this change?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:43 am

#466030

RE: Domain aggregate function

quote:
Hi, thanks, but this is from a VBA code behind a form where the computation is done:
Me.TotValue = DSum("Revenue", "QryOrderFooter")and...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:40 am

#466029

RE: Domain aggregate function

Hi Noel,

quote:
If I understand the meaning of DSUM correctly, you should use a GROUP BY clause.
With

DSum(expr, domain, criteria)
,...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:37 am

#466026

RE: Performance issue

Hi ishaan99,

quote:
Can anyone please let me know if it will make a significant difference in performance having table on one filegroup and...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:31 am

#466024

RE: Domain aggregate function

Hi kiberu,

quote:
Kindly show me the equivalent of MSAccess Dsum() function

given the Access Online Help...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

July 18, 2003 at 7:27 am

#466022

Viewing 15 posts - 4,576 through 4,590 (of 5,356 total)