Forum Replies Created

Viewing 15 posts - 601 through 615 (of 13,460 total)

  • RE: Scattered data into single line

    off hand, i'd say it looks like you need to use something like SELECT  MAX(ASP_New?) As ASP_New FROM SomeTable group 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!

    March 8, 2017 at 1:05 pm

    #1932394

  • RE: How to change the CLR permission_set value from 3(unsafe) to 1(safe)

    I believe that when the CLR is being compiled, it assesses what it is doing, and has unalterables built in rules, depending on what the CLR does, which determines whether...

    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!

    March 8, 2017 at 11:04 am

    #1932370

  • RE: How to parse this, 'F0-B20170225131636437{A^CM.INIT}'

    if we assume there's only one carat, and only one curly brace:

    /*
    (No column name)
    CM.INIT
    CM.INIT
    */WITH MySampleData(val)
    AS
    (
    SELECT 'F0-B20170225131636437{A^CM.INIT}' UNION ALL

    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!

    March 7, 2017 at 12:40 pm

    #1932139

  • RE: Script the table structure ( create table or alter table) for all the tables in the database

    There is nothing built in to SQL to do it via script; Even SSMS uses SMO to script objects out, it's not TSQL native.
    Luis was kind enough to link...

    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!

    March 7, 2017 at 12:21 pm

    #1932127

  • RE: Foreign Key is enabled , but not trusted

    here's a script to generate the commands for you;
    I keep this handy all the time:
    SELECT Quotename(s.NAME) + '.' + Quotename(o.NAME) AS QualifiedObject,
        s.NAME            ...

    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!

    March 3, 2017 at 1:36 pm

    #1931625

  • RE: Foreign Key is enabled , but not trusted

    when the FK was originally created, it would default to checking all the data, so it would be enabled and trusted.
     some processes will disable foreign keys as part of...

    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!

    March 3, 2017 at 11:19 am

    #1931587

  • RE: SQL Server 2016 Express with Service Pack 1 - SSIS

    you would not be able to deploy any projects to SQL Express, nor use the SQL Agent to schedule packages.

    Since SSDT is a completely separate installer, you can...

    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!

    March 1, 2017 at 7:10 am

    #1930952

  • RE: DBA without sa rights???

    jim.powers - Thursday, December 8, 2016 10:36 AM

    Anyone know any openings in the North Dallas area (Plano, Frisco would be best). I...

    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!

    February 28, 2017 at 8:30 am

    #1930717

  • RE: Strange Issue with SSIS package - Flat file source does not show the FIRST ROW in preview mode

    joydeep.sen157 - Saturday, February 25, 2017 6:42 AM

    Thom A - Saturday, February 25, 2017 4:21 AM

    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!

    February 25, 2017 at 6:53 am

    #1930320

  • RE: Using Case When to Calculate a number of events

    I see your query failed a syntax check; when i reformatted it, i see you got three trailing ,0), as if they were part of NULLIF/COALESCE, but you need only...

    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!

    February 25, 2017 at 6:48 am

    #1930319

  • RE: How to Add DATE TYPE DATA using store procedure

    your code, i guess is a web page, script task or application, has to pass the parameters.
    here's an untested modification of some code i had to help get you...

    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!

    February 25, 2017 at 6:37 am

    #1930317

  • RE: Active Directory -> SQL (Convert)

    i know power shell has a function FromFileTime  that can convert that wierd value( #ticks?) to datetime

    i've sued this expression:
    Expression={[DATETIME]::fromFileTime($_.accountExpires)}}

    $Results = Get-ADUser -Filter...

    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!

    February 24, 2017 at 2:56 pm

    #1930281

  • RE: Conversion script runs for long time unless carved up, not sure why.

    I assume you are running the script in SSMS, right?
    I've seen the same behavior in a script that was 46K lines of inserts for a zipcode database.(INSERT...VALUES)
    run 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!

    February 24, 2017 at 1:39 pm

    #1930271

  • RE: stored proc fails randomly...

    I'd definitely consider moving any file or renaming operations into SSIS and not use TSQL to do it. better error handling occurs there.
    i'd think it might be a concurrency...

    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!

    February 22, 2017 at 7:32 am

    #1929715

  • RE: how to update column with '

    the single quote is SQL's delimiter for identifying strings, so you have to escape it by repeating it twice in a row, where you want it to exist inside your...

    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!

    February 21, 2017 at 2:00 pm

    #1929612

    • Viewing 15 posts - 601 through 615 (of 13,460 total)