Viewing 15 posts - 9,451 through 9,465 (of 15,381 total)
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...
January 31, 2013 at 1:41 pm
Chrissy321 (1/31/2013)
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...
January 31, 2013 at 1:36 pm
Or maybe another way since you say the data is always AA.
select cast(replace(SiteID, 'AA', '1') as int) as NewSiteID
from #Sites
January 31, 2013 at 1:30 pm
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...
January 31, 2013 at 1:29 pm
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....
January 31, 2013 at 1:12 pm
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...
January 31, 2013 at 1:05 pm
saxena200 (1/31/2013)
while creating IV i have allready removed params and NOLOCK, but still my base query is not reading from IV
What do you mean your base query? I thought what...
January 31, 2013 at 12:28 pm
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...
January 31, 2013 at 12:25 pm
BLombardi (1/31/2013)
January 31, 2013 at 12:16 pm
montse 22199 (1/31/2013)
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...
January 31, 2013 at 12:13 pm
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...
January 31, 2013 at 12:03 pm
pwalter83 (1/31/2013)
Sean Lange (1/31/2013)
January 31, 2013 at 9:58 am
surilds (1/31/2013)
As mentioned he needs the data for that time period. Means copying the data from PROD to QA.
I just want to...
January 31, 2013 at 9:18 am
mpradeep23 (1/31/2013)
hineed to pass database name dynamically it is giving errors
with best regards
pradeep
You need to provide a little more information than that. We can't see you screen from...
January 31, 2013 at 9:13 am
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...
January 31, 2013 at 9:10 am
Viewing 15 posts - 9,451 through 9,465 (of 15,381 total)