Could you post the procedure so we can take a look. There might be a recursive call somewhere that's not exiting?

No, not that I'm aware of, at least not built in.

Krishnan,

This script I wrote demonstrates how to create a temporary table to do interval timing, match a stored value using an INNER JOIN with a BETWEEN condition, and...

How do you know how to filter the data being returned? For instance, you showed a subset of the data in your table. How does the query know...

You can generate schema in SQL scripts from Enterprise Manager, right-clicking the database --> All Tasks --> Generate SQL Scripts. In the first tab, click Show All, then set...

quote:

---

How will using temp tables decrease the amount of RAM used on the server, especially for multiple users? The temp tables...

I think that's a fair assumption; that SQL Server performs the CREATE INDEX function in the background after the constraint is added, and that's why there's no control over where...

<?php

/* Get the connection */

$cnn = mssql_pconnect(SQL_SERVER, SQL_USER, SQL_PASS);

/* Select the DB */

mssql_select_db(SQL_DB_NAME);

/* Grab a resultset */

$sql = [Your sql statement here];

$oR = mssql_query($sql);

foreach ($oField =...

This interval field -- is it able to be of a unit smaller than the smallest time interval stored in the DB? If so, you might be heading for...

I don't think it's possible with the ALTER TABLE syntax. But like Henry said, is there really any advantage to defining the PK in the ALTER TABLE statement instead...

Try this:

SELECT 

  hipodromo.nombre as hipo_nombre

, predefinida.numero as carr_numero

, (

  SELECT TOP 1 apostable.corre

  FROM predefinida 

  INNER JOIN apostable

  ...

Could you post an example of your code for us to look at?

I think what you need is:

SELECT 

  l.id as "fid"

, l.name as "fname"

, l.url as "furl"

, l.description as "fdescription"

, 'Y' as "factive"

, COUNT(*) AS "hit_count"

FROM...

What is the FIRST function? Do you mean MIN?

quote:

---

But does, 'Insert into '+@addDate+'' work with my above EXEC sp_executesql @query.

I defined the @addDate as

DECLARE @addDate table (dated varchar(12))