Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 8,761 total)

  • RE: How to I getr around the \ issue

    My bad in the post before on the conversion, sorry about that.

    😎

    My point is that incorrect typing and implicit conversions do cause problems, I've lost count of how many of...

    December 22, 2015 at 10:22 am

    #1847509

  • RE: How to I getr around the \ issue

    ScottPletcher (12/21/2015)

    But if you put the N' when the column is not unicode, you'll force SQL to implicitly convert the column itself and that could be a real performance killer.

    This...

    December 22, 2015 at 2:43 am

    #1847364

  • RE: SQL Order By

    Looks like MySQL/MariaDb, the CURDATE() and DATEDIFF with two parameters fits there.

    😎

    December 22, 2015 at 2:23 am

    #1847360

  • RE: Cast as Numeric

    Ed Wagner (12/21/2015)

    Jason A. Long (12/21/2015)

    The danger is real...

    Love the picture. That's priceless.

    Home sweet home...gone!

    😎

    December 21, 2015 at 7:38 pm

    #1847318

  • RE: How to I getr around the \ issue

    BrainDonor (12/21/2015)

    Talib123 (12/21/2015)

    Sorry now works fine

    Typo, or something more interesting we might all want to learn from?

    Or wrong server on a different domain:-P

    😎

    December 21, 2015 at 9:29 am

    #1847194

  • RE: Error executing xp_cmdshell in 32 bit env

    jayaprabhalnt (12/21/2015)

    I am getting the same error in the local server also.

    I guess I am missing a quote somewhere.

    please help.

    Thanks

    jayaprabha

    The problem is that xp_cmdshell can only take one double quoted...

    December 21, 2015 at 9:25 am

    #1847191

  • RE: How to I getr around the \ issue

    Talib123 (12/21/2015)

    This query has issues due to the \.

    If I use a Where = it works fine. How do I get around this small annoying issue.

    SELECT name FROM sys.syslogins

    WHERE name...

    December 21, 2015 at 9:21 am

    #1847184

  • RE: Error executing xp_cmdshell in 32 bit env

    jayaprabhalnt (12/21/2015)

    Yes, I have the sysadmin permission.

    I had also tried using the below command. But is is giving the same error.

    exec master..xp_cmdshell '"\\RemoteServername\D$\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtexec.exe" / f"\\RemoteServername\C$\\Package3.dtsx"';

    I guess...

    December 21, 2015 at 7:46 am

    #1847128

  • RE: Multiple parameter function !

    GilaMonster (12/21/2015)

    I don't think that functions have optional parameters that can be left out of the call

    That's correct, neither optional parameters nor default values can be defined for User Defined...

    December 21, 2015 at 6:57 am

    #1847106

  • RE: Today's Random Word!

    djj (12/21/2015)

    anthony.green (12/21/2015)

    Ed Wagner (12/21/2015)

    Grumpy DBA (12/21/2015)

    Ed Wagner (12/21/2015)

    anthony.green (12/21/2015)

    whereisSQL? (12/20/2015)

    Awesome

    Everything

    Something

    Nothing

    NULL

    Unknown

    Knowledge

    Useless

    December 21, 2015 at 5:39 am

    #1847077

  • RE: How to do IN statement as a parameter

    Jeff,

    what I've found is that there are two thresholds, one for the well formed XML and other for the CSV to XML, the former is lower than the latter, partly...

    December 20, 2015 at 2:22 pm

    #1847004

  • RE: How to do IN statement as a parameter

    Jeff Moden (12/20/2015)

    Eirikur Eiriksson (12/20/2015)

    Piling on, while the string splitting method works fine when working with small number of values the performance degrades very quickly when the number of values...

    December 20, 2015 at 8:45 am

    #1846982

  • RE: Error executing xp_cmdshell in 32 bit env

    jayaprabhalnt (12/18/2015)

    Hi,

    I am trying to execute 32 bit dtexec from 64-bit ssms.

    Give below is the command that i am trying to execute

    exec master..xp_cmdshell '\\<RemoteServername>"\D$\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtexec.exe"' / f"\\RemoteServername\C$\\Package3.dtsx"'

    I...

    December 20, 2015 at 7:36 am

    #1846974

  • RE: time series from particular day in month 1 to particular day in month 2

    Borut Olenik (12/20/2015)

    hm, ok.

    But what if I have dynamic day from - day to and I am doing dynamic filter on my factsales. Because of that once I will...

    December 20, 2015 at 4:22 am

    #1846969

  • RE: How to do IN statement as a parameter

    Piling on, while the string splitting method works fine when working with small number of values the performance degrades very quickly when the number of values increases. If you expect...

    December 20, 2015 at 4:09 am

    #1846966

Viewing 15 posts - 4,201 through 4,215 (of 8,761 total)