Trey Staker (11/30/2010)

---

CELKO (11/29/2010)

---

GilaMonster (11/27/2010)

---

It is a generalization, but it is founded on several things from...

GilaMonster (11/30/2010)

---

Joe's pulled out his usual example over here: http://www.sqlservercentral.com/Forums/Topic1026791-392-1.aspx (please don't take that thread out of control. So far it's polite)

Before I reply to his assertions, I'd like an...

msdb.dbo.sysschedules

Is it possible the @active parameter is interfering with the query? What did you set that to when you ran the query outside the proc?

I'd have to at least see the code for the stored proc before I'd be able to begin helping on this.

Can you post the script here?

If not, try adding a conversion to datatype "time" on the column and see if that does what you need.

The schedules are stored in msdb. You can query the tables there to see if a row already exists with the criteria you want to use.

So, it seems to me that it's doing exactly what it should be. It's giving you the rows for the companies, and their data from the sub-table. Right?

If...

The limitations are you cannot use Dev Edition to do anything except develop and test databases and software. If you use it in a production environment at all, which...

Top result for a Bing search for file type ".map": http://filext.com/file-extension/map

Microsoft Update service. Make sure you have all the service packs for the OS and for SQL. http://www.update.microsoft.com

CLR procedures can write to a text file pretty easily.

I'd use SSIS, but if you don't like that, and don't like BCP, give CLR a shot.

It's an integer. Math will be faster.

Excel is assuming it's a time, because of the format. Without a date on it, Excel adds a default date. You'll need to convert it to time-only during...

I'd have to see the tables and the data in them to tell you specifically what to do.

Take a look at the data returned, you'll need to see what doesn't...