Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 13,460 total)

  • RE: Group by + Count + Case

    what you are looking for is a SUM(CASE construct like this:

    /*

    Cust TotalCount TrueCount FalseCount

    Na 2 2 ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 9, 2015 at 5:23 am

    #1838512

  • RE: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

    that is correct. there are no tests related to 2008-related certifications to take anymore, but there's it's new successors for the 2012 level platform.

    they were superceded and replaced by...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 9, 2015 at 5:20 am

    #1838511

  • RE: Rename a network file using xp_cmdshell

    i seem to remember that xp_cmdshell is limited to a single set of double quotes, right?

    so "\path with spaces\oldname" "\path with spacesewname" might return an error?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 6, 2015 at 9:47 am

    #1838275

  • RE: Invalid Object name error

    global temp tables still get dropped when there are no more sessions at all, i believe.

    from msdn i think, in my notes but not attributed:

    a global temp table exists for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 6, 2015 at 9:44 am

    #1838272

  • RE: Linked Server - Oracle - sys as sysdba

    a lot of the time, the GUI might not show you all possible datasets...you sometimes have to "KNOW" that a database exists.

    you can run sp_tables_ex in SSMS to get details...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 6, 2015 at 8:40 am

    #1838256

  • RE: Tracing a user back to a login, where that login is an AD group

    Thanks Anthony! I added that to my snippets; damn i love the teamwork here!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 6, 2015 at 6:59 am

    #1838206

  • RE: Tracing a user back to a login, where that login is an AD group

    i use this to enumerate all members of all groups on a given server. then you can see when someone shows up in multiple groups.

    IF OBJECT_ID('[tempdb].[dbo].[#TMP]') IS NOT NULL

    DROP...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 6, 2015 at 5:40 am

    #1838194

  • RE: Dbmail HTML body size limit

    body is defined as nvarchar(max), so it's likely that you are getting some implicit conversions to nvarchar(4000) when you are building your htmlbody.

    can you show the code that builds that?

    that's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 4, 2015 at 9:12 am

    #1837715

  • RE: Downgrade SQL Server / Install Master Database

    i was always under the impression that to downgrade, you have to uninstall and reinstall.

    especially master and the hidden resource databases, which cannot be restored to any lower version service...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 4, 2015 at 8:30 am

    #1837686

  • RE: Third party tools to compare data in SQL Server 2014 and Oracle 10g/11g

    at my last place where we supported Oracle and SQL for an applications RDBMS, we had a specific set of rules to map equivalents structures at a table level. it...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 3, 2015 at 7:50 am

    #1837369

  • RE: Encryption of tables

    typically, you look at at a specific table, and decide which specific columns need to be encrypted, either because they contain personally identifying information, health information, or sensitive info...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 2, 2015 at 1:07 pm

    #1837191

  • RE: Exporting BCp to a Compressed File (Rar)

    after the bcp is created, you can call 7za.exe(the command line version of 7zip) to zip the file.

    if you call it from xp_cmdshell, you are limited to one...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 2, 2015 at 7:30 am

    #1837081

  • RE: How To Modify Column Datatype In Oracle

    was this a question, or were you pointing folks to the solution to an issue you encountered?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 2, 2015 at 5:23 am

    #1837025

  • RE: HIT 3621 When running Job

    we'd need more details to really help.

    my research implies it's due to bad logic in the procedure:

    when i googled "sql error 3621"

    this link implied that the error was returned...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 2, 2015 at 5:21 am

    #1837024

  • RE: How to execute a .cmd file on remote server through SSIS package

    if ServerA is going to issue a command(s) on serverB, psexec must be installed on ServerA

    also i believe on a per user basis, you need to call psexec at...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    October 30, 2015 at 11:21 am

    #1836779

Viewing 15 posts - 1,396 through 1,410 (of 13,460 total)