santa326 (8/14/2012)

---

Hi Mark,

yes i can do that but,how will sql know that my text is in dd/mm/yyyy for and not in...

You mean something more like this?

CREATE TABLE [dbo].[tst_InvoiceHeader](

[invoice_id] [int] NULL,

[grouo_id] [int] NULL,

[subscriber_id] [int] NULL,

[createdate] [datetime] NULL,

[duedate] [datetime] NULL

) ON [PRIMARY]

INSERT INTO dbo.tst_InvoiceHeader

( invoice_id ,

...

rVadim (8/14/2012)

---

I think Jared is right. The whole thing boils down to incorrect formation of @Subnet parameter. That is why asked what is in it. If it's like below, you...

Make it easy on others:

http://www.sqlservercentral.com/Forums/Topic1322992-392-1.aspx

The way I showed above does the...

Charmer (8/14/2012)

---

Lynn Pettis (8/14/2012)

---

I'd like to see the query, tables and indexes, and the actual execution plan of the query. Never know, there may be some tuning that can...

David92595 (8/14/2012)

---

I created it as a stored procedure in SSMS so I could use it for multiple reports and then just add it as a dataset in SSRS.

First Day of...

I'd like to see the query, tables and indexes, and the actual execution plan of the query. Never know, there may be some tuning that can be done.

Grizzly Bear (8/14/2012)

---

I am getting this error : Operating system error 665(The requested operation could not be completed due to a file system limitation) encountered.

Microsoft has this article http://support.microsoft.com/kb/2002606

But that...

The other option is to use a SQL Task to load the results of your query into a staging table (permanent or temporary, but probably permanent for ease of coding)...

SQLKnowItAll (8/14/2012)

---

I think we are missing a key aspect of what the OP is asking. This is closer to an SSRS question, I believe. There are 2 datasets...

Not sure what you mean by "has no other way."

Kwisatz78 (8/14/2012)

---

I am wanting to use a static port for SQL but something that has always confused me with the following article.

http://msdn.microsoft.com/en-us/library/ms177440(v=sql.100).aspx

It mentions to right click and select properties to...

Have you tried tuning your SQL query?

And the question is, what?