This is a tough one. It's hard to know what you need to know in that situation. The main thing I'd focus on finding out is, which databases can the...

chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/5/2011)

---

paul_ramster (10/5/2011)

---

Your outer query has the WHERE clause:

where PostedDate='1/19/2011'

and PostedDate is defined in the view as:

CAST(CAST(SUBSTRING(WH_Status.StatusHistory,CHARINDEX('Batch posted successfully',CONVERT(VARCHAR(MAX),WH_Status.StatusHistory))-35,26) AS DATE) AS DATETIME) AS PostedDate

You...

Sean Lange (10/6/2011)

---

Jack Corbett (10/6/2011)

---

I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.

Never really listened to...

Time to start the education. Quintessential Ramones. But my own preference is for this.

Hurry, hurry, hurry...

Stefan Krzywicki (10/6/2011)

---

GilaMonster (10/6/2011)

---

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm...

chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/5/2011)

---

paul_ramster (10/5/2011)

---

Your outer query has the WHERE clause:

where PostedDate='1/19/2011'

and PostedDate is defined in the view as:

CAST(CAST(SUBSTRING(WH_Status.StatusHistory,CHARINDEX('Batch posted successfully',CONVERT(VARCHAR(MAX),WH_Status.StatusHistory))-35,26) AS DATE) AS DATETIME) AS PostedDate

You will always get...

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older as...

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older as well. People I...

Script out the database. Like it says above, use SSMS to generate a script. You can also make calls to SQL Server Management Objects (SMO) from code to generate...

It's not something I've run into before. Are you up to date on the service packs? Have you looked to install any of the cumulative updates? I'd start there.

Just a...

For additional methods of dealing with parameter sniffing, check out Chapter 38 of the SQL Server MVP Deep Dives II[/url] book. It covers things not included in the article such...

TSQL is a querying language, not a presentation and formatting language. If you want to change the format, you need to have a report, a spreadsheet, or build an application.

Too bad you weren't on 2008 or better, you could just use the MERGE command.

As it is, you need to do two TSQL statements. The first should be an INNER...

vince_sql (10/5/2011)

---

Grant Fritchey (10/5/2011)

---

chandan_jha18 (10/5/2011)

---

Thanks. I was trying to remove the cast functions in the 'on' filter which Grant mentioned sometime ago.

But as you(Paul and Grant) mentioned about posted...

chandan_jha18 (10/5/2011)

---

Thanks. I was trying to remove the cast functions in the 'on' filter which Grant mentioned sometime ago.

But as you(Paul and Grant) mentioned about posted date which is...