ScottPletcher (9/13/2013)

---

Sean Lange (9/13/2013)

---

If you handled all of your updates via stored proc this would be even easier. 😛 Just add another column to the update statement. If however, as...

wendy elizabeth (9/13/2013)

---

I have a sql server 2008 stored procedure where I want to use the results of a view in a where statement. I want to check to see...

You can use a tally for this pretty easily.

Here is the code to create a tally table view. This is super fast!!!

create View [dbo].[Tally] as

WITH

E1(N) AS (select 1 from (values...

If you handled all of your updates via stored proc this would be even easier. 😛 Just add another column to the update statement. If however, as it sounds that...

You are welcome. Glad that worked for you.

Generally speaking you should always start your own thread. Your powerpivot is good example.

You need to reference the column not the alias.

st.name = 'v_SEC_NON_SEC_POSN_F_TOTAL'

My question...

Sounds to me like this one is all about personality. They want to know if you will fit in. Best advice here is to be yourself and find a way...

This should work.

declare @Date char(8) = '09132013'

select cast(RIGHT(@Date, 4) + LEFT(@Date, 4) as datetime)

I was pretty clear to me what you wanted. Did you try reading the article? It produces exactly what you stated you want as output.

Sure no problem. What you need to do is parse your string and then parse the results. Parsing strings in sql is the challenge here. Take a look at the...

sasi4frendz (9/13/2013)

---

Hi Sean,

I posted the same question twice because my browser got hanged. I will try to delete one of the posts.

I dont see any replies posted on my other...

In addition to Grant's suggestion maybe you should look at Step1. You say there are only about 15k rows but the archive portion takes 10 minutes. That is awfully slow...

ChrisM posted an awesome script the other day. I modified it slightly for you case.

DECLARE @MySearchCriteria VARCHAR(500)

SET @MySearchCriteria = '3496'

SELECT 'SELECT ' + c.columnlist + ' FROM ' + t.name...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1494391-391-1.aspx

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1494563-1550-1.aspx