Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 13,460 total)

  • RE: SSIS in SSMS - no option to install

    I'm under the impression that Express with advanced tools installs the SQL and SSRS, but also installs a small version of Visual Studio, with the templates for creating SSIS packages...

    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!

    September 16, 2015 at 6:00 am

    #1827028

  • RE: SQL management studio alternative

    I carry LinqPad around on a thumb drive if i happen to wander to a desk without my favorite tools.

    you can install an unlimited number of SQL Server Management Studio...

    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!

    September 16, 2015 at 5:52 am

    #1827025

  • RE: Trying to create a linked server to a Microsoft Access 2013 database in SQL 2012

    I've never gotten a DSN-less Access linked server to work.

    the link below will get you rolling, but if you have Office installed on your local machine, a side affect is...

    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!

    September 15, 2015 at 2:33 pm

    #1826907

  • RE: TempDb on Drive Root

    I misread your question as moving off of the Os drive, insteadof what you asked;;;

    so should tempdb.mdf be T:\tempdb.mdf vs T:\SQLData\tempdb.mdf ?

    i'd say folders make things more organized, so...

    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!

    September 15, 2015 at 1:19 pm

    #1826887

  • RE: Best idea - summary field

    i would use a view that does the calculation from your post above, and then you can poll the view instead of the base table. that is the easiest route,...

    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!

    September 15, 2015 at 1:16 pm

    #1826885

  • RE: Speed Up Creating Temp Table

    scotsditch (9/15/2015)

    Hi I'm trying to create a temp table using the script below and it's taking forever. I was hoping someone might have some tips on hows I could...

    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!

    September 15, 2015 at 11:43 am

    #1826852

  • RE: USER DEFINED DATA TYPES: Used in table creation - What happens if you change just the user defined type to varchar(max) from text?

    As a remember it, there is no valid syntax for ALTER TYPE. only drop and create.

    i know that once a user type is in use, to change it, it cannot...

    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!

    September 15, 2015 at 11:21 am

    #1826838

  • RE: Intermittant fault on script.

    could you have a script out there that tries to be bulletproof, and drops and recreates the linked server before it does any work, in order to guarantee, for that...

    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!

    September 15, 2015 at 10:07 am

    #1826809

  • RE: Renaming SQL Instance (SQL 2008 R2)

    to fix @@servername, modify this example to the "right' name

    while the changes are in the right tables, it will eventually require a stop and start of the SQL services...

    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!

    September 11, 2015 at 2:14 pm

    #1826155

  • RE: Renaming SQL Instance (SQL 2008 R2)

    it is not possible to rename an instance name. only the server itself.

    so on my local machine named [LowellDev], i have LowellDev\SQL2014, LowellDev\SQL2012 and LowellDev\SQL2008R2 instances.

    if i rename my...

    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!

    September 11, 2015 at 11:49 am

    #1826098

  • RE: Check if two rows have a different value in a specific column

    here's my guess on the requirements,i thought of two ways to do it, but i was not sure if you could have the same Id multiple times, all with the[IS_NULL]...

    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!

    September 9, 2015 at 6:00 am

    #1825368

  • RE: To set the quarter date according to the date flag.

    no input, just consumable data to help:

    ;WITH EstimatedData([QuarterDate],[sf_115],[sf_315],[sf_415],[sf_515],[sf_615],[sf_915],[sf_1015],[sf_1115],[sf_1215])

    AS

    (

    SELECT CONVERT(DATETIME,'01-15 -2015'),'1',NULL,NULL,NULL,NULL,'1',NULL,'1',NULL UNION ALL

    SELECT '12-15-2015',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1' UNION ALL

    SELECT '09-30-2015',NULL,'1',NULL,'1',NULL,'1',NULL,'1',NULL

    )

    SELECT QuarterDate,

    sf_115,

    ...

    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!

    September 8, 2015 at 7:21 am

    #1825113

  • RE: Remove String from column Post Code Field

    can you make an assumption based on the length? your example using charindex of the left parenthesis doesn't match your sample you posted.

    ;WITH MyCTE([PostalCode])

    AS

    (

    SELECT 'Derbyshire S42 5BX' UNION ALL

    SELECT 'NN4...

    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!

    September 8, 2015 at 6:49 am

    #1825099

  • RE: hi, i'm a noob on sql 2008 could anyone suggest me on how to do it

    Help us help you!

    if you can provide your sample data in a consumable format(meaning copy and paste to SSMS and build the data)

    as well as the queries you are running...

    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!

    September 4, 2015 at 12:14 pm

    #1824756

  • RE: Create dates right on the hour interval-best technique

    you can also use the dateadd/datediff functions to strip to the hour, and still keep the value as a datetime instead of a varchar.

    select DATEADD(hh, DATEDIFF(hh,0,getdate()), 0) --2015-09-04 10:00:00.000

    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!

    September 4, 2015 at 8:30 am

    #1824686

Viewing 15 posts - 1,501 through 1,515 (of 13,460 total)