Viewing 15 posts - 9,241 through 9,255 (of 15,381 total)
You could get rid of the cursor here too. Something like this should be pretty close.
DECLARE @CORRECTION_STATEMENT nvarchar(max)
select @CORRECTION_STATEMENT = 'UPDATE [janinetestdata].[dbo].[EDTE] set ' + Columns_To_Fix + ' = '''
+...
February 25, 2013 at 3:33 pm
candide (2/25/2013)
i have a view with two columns, lets say SpecYear and SpecMonth, both are integer.
How can I build two new columns with the first and last day of...
February 25, 2013 at 3:21 pm
Another crazy snowstorm in Kansas City. This is the second thunder snow in 5 days. It is really quite odd to hear rolling thunder while it is blizzarding. We got...
February 25, 2013 at 3:13 pm
mohsen.bahrzadeh (2/25/2013)
I did not notice much explain
Not totally sure what you mean here but to get the actual execution plan you need to select that choice in SSMS. It is...
February 25, 2013 at 12:48 pm
mohsen.bahrzadeh (2/25/2013)
sorry you can download from this post
Can you post the actual execution plan instead of the estimated one?
February 25, 2013 at 12:19 pm
VASUforSQL (2/25/2013)
I have a table called Products which has many columns.
It is a temporary table used for reporting purpose. The data will be processed to this table concurrently by...
February 25, 2013 at 12:13 pm
mohsen.bahrzadeh (2/25/2013)
thanks, SSCoach
I can't read that and it appears to require a login. Can you just post the file as an attachment here?
February 25, 2013 at 11:59 am
I agree with Jason that your code is the biggest issue here. That being said your indexes are kind of all over the place too. This is a catch all...
February 25, 2013 at 11:55 am
asco5 (2/25/2013)
Sean Lange (2/25/2013)
Your question is unclear. Are you trying to create an application that will dynamically display the results of a query?
Hi exactly
In fact instead of going to sql...
February 25, 2013 at 10:26 am
ohpenot (2/25/2013)
The query works fine now, even if i don't like not being able to write "jprod as....query treatement here"
What if i need to define...
February 25, 2013 at 9:15 am
Your question is unclear. Are you trying to create an application that will dynamically display the results of a query?
February 25, 2013 at 9:09 am
Hi and welcome to the SSC. Nice job posting ddl and sample data!!!
I made a couple changes so that it will work for everybody. This query works for your sample...
February 25, 2013 at 9:08 am
GilaMonster (2/25/2013)
Sean Lange (2/25/2013)
That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are looking for.
A...
February 25, 2013 at 8:36 am
I would HIGHLY recommend you read the article suggested with the DelimitedSplit8K function. Once you read that article you will understand why you need to get rid of your loop...
February 25, 2013 at 7:47 am
Hi an welcome to the forums. It is impossible to answer your question with the limited amount of details you posted. Please take a few minutes to read the article...
February 25, 2013 at 7:44 am
Viewing 15 posts - 9,241 through 9,255 (of 15,381 total)