This is mostly due to us being forced to speculate on your table. Dwain assume you have multiple rows but my guess is your table holds the entire discussion more...

Chrissy321 (1/31/2013)

---

Hi All,

I am used to working with a calendar table that has a record for each day. Now I need to work with a table of holidays only.

My requirement...

Or maybe another way since you say the data is always AA.

select cast(replace(SiteID, 'AA', '1') as int) as NewSiteID

from #Sites

I missed one of your requirements.

What I can't do is take 3000AA and make it 3001, it needs to be 30001. Maybe a way to declare it in the...

Another post with nothing to work with? Don't you get tired of us asking you to put in the leg work?

Given your description it seems you are over complicating it....

OK this can be done without global temp tables and no dynamic sql. The real challenge is that you are trying to insert rows into a table that has only...

What do you mean your base query? I thought what...

By default a primary key will have a clustered index created, assuming there is not already a clustered index on the table. In your first query you create the table...

BLombardi (1/31/2013)

---

I have 3 Tables, one for Company, one for Contact and one for Phone Numbers. Each Company can have multiple Contacts. And Each Company can have multiple...

montse 22199 (1/31/2013)

---

Hello Experts,

I have the following querie using case then statement for one of my fields as it follows,

My question is, I need to add another condition but this...

Your query has parameters. You can't pass parameters to a view. You could build your query without the parameters and then use them in a where clause when you query...

pwalter83 (1/31/2013)

---

Sean Lange (1/31/2013)

---

Have you run this in the debugger? You can check the visible rowcount of the grid at the beginning of your method and then again at the...

surilds (1/31/2013)

---

This is actually from one of our client.

As mentioned he needs the data for that time period. Means copying the data from PROD to QA.

I just want to...

You need to provide a little more information than that. We can't see you screen from...

Have you run this in the debugger? You can check the visible rowcount of the grid at the beginning of your method and then again at the end. Also setup...