What is to_char function?

The Select from Dual statement is run on Oracle, not SQL. Thus can't column be used in a SQL function then, but first when returned to SQL...

Begin with creating a function for calculating the distance between two coordinates, like this

CREATE FUNCTION dbo.fnPostalDist

(

    @Lat1 FLOAT,

    @Long1 FLOAT,

    @Lat2 FLOAT,

    @Long2 FLOAT

)

RETURNS FLOAT

AS

BEGIN

    DECLARE @Dist FLOAT,

            @Rad...

Yes. If the two databases are installed on the same database server, use fully qualified name to get the data.

MyDatabase.Owner.Table.Field -> Master.dbo.spt_Values.Number

If the data exists on a different...

The shear amount of data transfered from the database to the web page exceed 36 mb!

Multiply that with the number of concurrent users and you most probably will congest the...

CREATE TRIGGER ProposalCC ON Proposal FOR UPDATE AS

DECLARE @Count INT

SELECT  @Count = COUNT(*)

FROM    INSERTED

IF @Count > 0

    BEGIN

        INSERT CC

        VALUES...

I think once that you have referenced %ErrorLevel%, it is automatically set to Zero as it is very volatile.

Try to save %ErrorLevel% first with

Set a = %ErrorLevel%

You are only fetching first updated record. What if a user updated two or more records at the same time?

Try this code for trigger

CREATE TRIGGER ProposalCC on Proposal...

Yes, but it will not utilize any indexes. John's query will.

Books Online states that SMALLDATETIME is only accurate to the minute.

Are the calls in the database also stored as SMALLDATETIME? IF so, changing to DATETIME for getting latest call is...

Yes Ryan. Of course I am right. Have I ever lied to you?

Use this code. Also tell Madhivanan to add this code to...

declare @param varchar(50)

select @param = 'abc'

select reference,quantity from sl where sl.code = @param

Yes, if you name the sheet or a range in the sheet, Excel automatically adds the new rows at the first free row below existing. If no free rows are...

Yeah, I know this would come up. Jeff, if you already know which columns to update, write them down and update them one at a time. If you want to...

It is possible with OPENROWSET. Read http://sqljunkies.com/WebLog/madhivanan/archive/2005/07/27/16233.aspx

Yes Jeff...

declare @columns table (id int identity(0, 1), tablename sysname, columnname sysname)

insert     @columns

           (

               tablename,

               columnname

           )

select     isc.table_name,

           isc.column_name

from       information_schema.columns isc

inner join information_schema.tables...