Viewing 15 posts - 1,126 through 1,140 (of 13,446 total)
is your data double quoted, meaning the value featuring the comma is properly delimited so you can process it?
1,Academy award winners,"Jones, James Earl",moredata
if it's not, you need to go...
April 4, 2016 at 2:57 pm
if we are talking about checking if an object is no longer valid because columns or tables were renamed , dropped, etc,
i've got this script i posted here on SSC...
April 4, 2016 at 2:10 pm
i've seen the same on my side, with the default of one retry; an email with to: 'goodemail@somedomain.com;bademaul@somedomain.com' results in goodemail getting two emails.
first thing to do is review who...
April 4, 2016 at 2:05 pm
i would think youll start with a case expression, and then order by the tagname anyway as the second condition;
how do you get the value "tagor1", for example? uis that...
April 4, 2016 at 1:26 pm
i leave xp_cmdshell disabled by default , and have processes enable it, perform bcp via xp_cmdshell, and then disable again.
you could perform bcp from a command line SQL job, and...
April 4, 2016 at 5:56 am
how about not using #temp, but creating the table in tempdb instead? then it will still exist.
DECLARE @cmd nvarchar(4000) = '
SELECT schema_name(schema_id) As Schemaname,
object_id,
Name as TableName
INTO tempdb.dbo.StagingTable
from msdb.sys.tables...
April 1, 2016 at 11:21 am
SQL!$@w$0ME (4/1/2016)
Thanks Lowell. Can you please provide the code for 'CLR_ExportQueryToCSV'.
below is an updated version of it, i posted the original version of it on http://sqlclrexport.codeplex.com/ years ago.
April 1, 2016 at 11:09 am
you posted in "working with oracle", so i thought you were using oracle.
if this is SQL server, then you would just stick with dateformats that are universally converted;
you said you...
April 1, 2016 at 9:21 am
Ray Herring (4/1/2016)
andre.quitta (3/31/2016)
[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module...
April 1, 2016 at 8:46 am
pretty sure you have to use oracles TO_DATE function, especially because you are passing a string,and also using UK date formats.
WHERE DateCreated BETWEEN
TO_DATE('01/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')
AND TO_DATE('31/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')
the problem...
April 1, 2016 at 8:35 am
you'll need to have a separate process save each query to disk on the server, and then the email will not have a query, only attachments.
i currently use a CLR,...
April 1, 2016 at 8:27 am
vijay_uitrgpv (4/1/2016)
Do we need to mention every column which is being updated in IF UPDATE statement ?
Is there any way out if any column is updated...
April 1, 2016 at 5:53 am
great job posting your code and your work!
The thing about triggers, is that they have a pair of psuedo tables named INSERTED and DELETED.
Thos tables have the before and...
April 1, 2016 at 5:14 am
i cannot remember the exact error , it says something about UAC,and it's bit me in the past.
i believe it's because you need to add the user in TWO...
March 31, 2016 at 3:13 pm
I think using a pattern like this will work: its saying the first two characters are A-Z, and then anything after that.
Select top 100 RxClaims.prescriberId
from MHPDW.TransferDB.[dbo].[RxClaims] RxClaims
WHERE
RxClaims.prescriberId LIKE...
March 31, 2016 at 12:20 pm
Viewing 15 posts - 1,126 through 1,140 (of 13,446 total)