This will do it:

DECLARE @InputDate DATETIME, @DayCount INT

SET @InputDate = '01-12-2008'

SET @DayCount = 1 + DATEDIFF(dd, @InputDate, GETDATE())

SELECT DATEADD(dd, 1-N.number, GETDATE())...

Can you see the database ODS in the output generated by this:

SELECT a.* FROM OPENROWSET(

'SQLOLEDB',

'Trusted_Connection=yes;Integrated Security=SSPI;DataSource=''10.0.172.53'';' ,

'SELECT [name] FROM master.dbo.sysdatabases') AS a

Rootman (12/10/2008)

---

Thanks for the reply.

But I want to return a specific column, say column 2 from a table.

In other words I want to use the table as a sort of...

SELECT *

sabarichandru (12/10/2008)

---

Dear all,

i need to display dates as a O/P which falls between two date inputs .

Eg:

input 1 ...

Hi Debjani

Can you please let us know what the remaining problems are?

pino_daddy (12/9/2008)

---

This query was a simple example of how we would use the function.

We are aquiring companies around teh world and for UTC we need to have one time zone....

Ironic this...prices are tumbling and yesterday's technology is robust!!

pino_daddy (12/9/2008)

---

This query:

SELECT ROW_ID, CREATED, dbo.ConvertGMTToEST(CREATED)

FROM S_SRV_REQ S

returns 959,970 rows in 48 seconds

This query:

SELECT ROW_ID, CREATED

FROM S_SRV_REQ S

returns 959,970 rows in 4 seconds

Want to know how to speed up the...

Kelvin Phayre (12/9/2008)

---

I put 1.5m rows into a table and then ran your query. I then stopped the query before it crashed the server.

I then took a different tac. I...

Hi Joe, I'n not reall sure what's going on there!

Here's a simple test setup, with a sp taking 6 parameters, three of them being output params.

It should be sufficient...

pvar (12/9/2008)

---

Thanks guys for your quick response. I tried Noeld's solution and it worked, I liked the simplicity of the select statement. But I am not sure about chris's solution,...

No, twenty or so should be...

No problem. This will do:

SELECT * FROM (

SELECT...

pvar (12/9/2008)

---

Hi,

I have a table with 4 boolean fields. I need to find the records that have more than one boolean field set to true. That means records with A...