garyh2k3 (8/12/2013)

---

When setting my @sql statement to

FROM

SATXFPMetrics

WHERE [Date] >= CONVERT(datetime,'''+ @StartDate +''',121)

group by [Date]'

--select @sql

--SELECT @SQL1

--exec sp_executesql

EXEC(N'sp_executesql N''' + @sql + @SQL1 + '''')

for example and...

I assumed some of the structures were not yours but the post that won't execute certainly was. At any rate I think that something like this will get you what...

jamie 82947 (8/12/2013)

---

Thank you very much for the help.

I couldn't change the database compatibility level due to a lot of old stuff so I created the view in a new...

Before we even get into a query your code has some pretty serious issues. I know you are new and I am not trying to bust your chops but you...

Of...

I think you may be chasing your performance problems...

jamesheslin123 (8/12/2013)

---

Hello,

I need to convert a query in MS Access to a view in SQL Server 2005. The view will draw from two tables: Employee and Spaces. I want the...

Does this date column allow NULL? If you specify a default for a column but allow NULL it will NOT use the default when you don't include that column in...

You don't. You will have to set it to a new value.

No need for a temp table here. Just add a where clause.

where thing1.name = @SearchVal

OR thing2.name = @SearchVal

OR thing3.name = @SearchVal

Check out the articles referenced in my signature. They explain in detail how to do both a static and dynamic version of cross tabs.

BOR15K (8/12/2013)

---

There is no 80 points and there is sample data - WITH statement runs and works perfectly (I understand you haven't tried it).

I do know that SQL is not...

Something like this should work as a replacement for your entire view definition.

select ID, x.Item

from TempTesting t

cross apply dbo.DelimitedSplit8K(TestData, ',') x

The next question is why do you have inserts within a while loop?

You should check out the link that Luis pointed you too, or the one in my signature about splitting strings. It is way faster than...