Well, that is all I can come up with since I can't see what you see.

Matt Miller (#4) (5/11/2012)

---

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL Service Broker application with a conversation set up. ...

Probably not. I wouldn't be surprised if the times you are seeing are during the execution of the procedure. It probably uses GETDATE() in an update statement, correct?...

Sample data for your tables and the expected results would go a long way to helping you.

The sample data should be using INSERT INTO statements for the tables so that...

Tonci Korsano (5/11/2012)

---

hi there,

here is the answer --> https://www.google.com/#hl=en&sa=X&psj=1&ei=70OtT53nCYKy8ASUwrWXDQ&ved=0CBgQvwUoAQ&q=(sqlbulkcopy+OR+bcp)+(%22no+logging%22+OR+%22does+not+log%22)&spell=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=356e729b7a15c7f0&biw=1280&bih=891

or just put in google.com

(sqlbulkcopy OR bcp) ("no logging" OR "does not log")

this is really a web search... even though it...

Not sure if this will help with parallelism, but this is how I would code the query. Also, in SQL Server 2005 the date/time data type can have a...

michael vessey (5/11/2012)

---

riya_dave (5/11/2012)

---

hi

i have unique identifier field in one sp, that i need to pass into another sp.

when i copy paste it to another sp as a parameter...

Can you provide the criteria for computing the start and end dates for your query? Does it always start with 10/01 of a given year?

This should work:

DECLARE @BadData TABLE(DataID INT, Data VARCHAR(50), ExpectedData VARCHAR(50));

INSERT INTO @BadData(DataID,Data,ExpectedData)

SELECT 1,'#123 data','data' UNION

SELECT 2,'#456data','data' UNION

SELECT 3,'data #789','data' UNION

SELECT 4,'data#012','data' UNION

SELECT 5,'data#345 some more data','data some more data' UNION

SELECT...

polkadot (5/11/2012)

---

Time is the issue. I am on this forum to ask someone who is experienced with SSRS if they know the answer. I am not asking for...

Sean Lange (5/11/2012)

---

Lynn Pettis (5/11/2012)

---

Didn't see...

Didn't see it. Looks good...

Here is a shot at it:

DECLARE @BadData TABLE(DataID INT, Data VARCHAR(50), ExpectedData VARCHAR(50));

INSERT INTO @BadData(DataID,Data,ExpectedData)

SELECT 1,'#123 data','data' UNION

SELECT 2,'#456data','data' UNION

SELECT 3,'data #789','data' UNION

SELECT 4,'data#012','data' UNION

SELECT 5,'data#345 some more data','data some...

Jeff Moden (5/11/2012)

---

Lynn Pettis (5/10/2012)

---

Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope for the best....

Have to ask, is it always a # and three digits or is that just the way you configured your sample data?