Viewing 15 posts - 1 through 15 (of 57 total)
Hi Jason,
thanks for that, I'll add them to the exclusions list in the query.
Ta
David
January 7, 2015 at 4:47 pm
Hi There,
Have a look at this web page, it should give you what you need. I use this method and it works fine.
http://codebyjoshua.blogspot.com.au/2012/01/get-data-from-sql-server-stored.html
Ta
David
November 27, 2014 at 6:30 pm
Hi resender,
Try using --execute sp_executesql (@SQL)
Rather than --execute sp_executesql @SQL
Ta
David
November 27, 2014 at 5:57 pm
I haven't tested this but i think your issue is with the ISNULL in the weird bit. When the name is NULL you set it to None. this does not...
June 9, 2014 at 6:54 am
Hi,
I suspect you have a non numeric character in a column which you are trying to populate a column which is numeric datatype. if the column in the source data...
June 4, 2014 at 3:22 am
I agree this should be done in the frontend app.
This code will give you the commas and decimal places
SELECT CONVERT(VARCHAR, CAST('1234567890' AS MONEY),1)
As for left or right justification, that...
May 30, 2014 at 4:07 am
Hi there,
If it is a straight like for like replacement then this would work
update [mytable]
set [mycolumn] = '#########'
where len([mycolumn]) = 9
If the task is more complex then you will need...
May 30, 2014 at 2:33 am
Hi there,
I would look to be using two CTE to replace your selects and then query those to produce your report so something like
WITH cte1 <columns>
<SELECT Statement>,
cte2 <columns>
<SELECT Statement>
select <columns>
from...
May 20, 2014 at 8:01 am
Hi There,
I don't really understand what it is that you are trying to do. Is it the backups which are failing, if so what are the errors or is your...
May 20, 2014 at 3:05 am
There maybe a better solution using Adam Machanic's WhoIsActive stored proc, he has a variable @show_system_spids so you can stop those appearing and you can filter by database. you could...
May 19, 2014 at 8:51 am
I have ripped this out of Glenn Berry's excellent Diagnostic Information Queries (go grab a copy of the script)
Anyway this should give you what you need.
SELECT DB_NAME([database_id])AS [Database Name],
...
May 19, 2014 at 7:47 am
Is there any BEGIN TRANSACTION.... ROLLBACK in the error handling, indeed are they hitting the error trap for some reason
May 19, 2014 at 4:07 am
Hi There,
If you go to D:\Data are there 3 files for this database? In your post the two .ndf files seem to have the same name?
May 16, 2014 at 3:45 am
Hi,
A quick google of the table name throws up alsorts of posts about this table growing hugely, so much so that there is a microsoft kb article about clearing it...
May 13, 2014 at 4:35 am
Hi Jend,
Can you post the table structure, it sounds like it is a very wide table or maybe it houses images or some such thing.
Ta
David
May 13, 2014 at 3:59 am
Viewing 15 posts - 1 through 15 (of 57 total)