snowfrost.c (6/6/2014)

---

Hi All ,

I am using MS SQL Server 2005 as my database. Previously I have some issues with my table indexes and the retrieval of my select is...

Please next time start your...

Why not just post the code instead of a zip file that contains a file that contains the code?

IF NOT EXISTS(SELECT * FROM sysObjects WHERE Name='LookupPriority' AND xType='U')

BEGIN

CREATE TABLE...

I am guessing you didn't read the article I suggested. Your second post has one table but it is populated using a select statement from other tables I don't have....

Still no actual details. Here is my last shot in the dark.

with ViewCTE as

(

SELECT

view.columnA

, view.columnB

FROM view

WHERE date > '2014-06-01'

)

SELECT

v.columnA,

v.columnB,

table.ColumnC

FROM ViewCTE v

INNER JOIN table on table.tableId = v.tableId

WHERE v.date > table.createdDate

Please...

Not a lot of actual details to work with here but have you tried moving your predicate to the join?

SELECT

view.columnA,

view.columnB,

table.ColumnC

FROM

view

INNER JOIN table on table.tableId = view.tableId

...

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

As most things, it depends.

According to my education, America is a single continent divided in four regions: North, Central, South and Caribbean. According to...

OK I finally understand enough of what you are doing here. There is no way from the code that you have posted to capture the current identity value. It is...

Luis Cazares (6/5/2014)

---

As most things, it depends.

According to my education, America is a single continent divided in four regions: North, Central, South and Caribbean. According to the US education, North...

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education...

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system is worthless...

That means...

This is a manual process to copy and paste into excel? The problem is that excel tries to determine what the datatype is for a column based on value in...

Well unless you can tell...

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system is worthless and that our...