Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 13,460 total)

  • RE: expanding the keyword AS

    i wasn't sure of your use case, so here's three examples:

    alias = {calculation}

    {calculation}AS Alias

    CalculatedColumn As {calculation}

    SELECT Month1 = convert( varchar(10),GETDATE(),110)

    SELECT convert( varchar(10),GETDATE(),110) AS Month1

    create table #temp (ID int identity(1,1)...

    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!

    July 8, 2015 at 5:38 am

    #1810897

  • RE: SSIS: migration of a SSIS script: "binary code not found"

    every time I've gotten the old binary script not found error, it was because a script task was syntactically incorrect; i edited it, and forgot a semi colon, or deleted...

    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!

    July 6, 2015 at 11:51 am

    #1810530

  • RE: Home lab build question...

    Like Eric, i use virtualbox;

    i've got two laptops, my original with 8 gig of ram, which does pretty good with two virtuals running,and slows down beyond that;

    i've got an...

    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!

    July 2, 2015 at 12:28 pm

    #1810029

  • RE: Find last time all cubes were processed

    I have a linked server on every sql instance that also has SSAS installed on the same box.

    i can query the linked server for some of those attributes.

    --#################################################################################################

    --Create our Standard...

    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!

    June 30, 2015 at 2:50 pm

    #1809306

  • RE: delete profile

    part of my Script Out Database mail settings script found here:

    http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

    is a comment block to drop both the profile and the accounts.

    grab that script, run it to produce a script,and...

    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!

    June 30, 2015 at 2:03 pm

    #1809289

  • RE: Schema Compare tools - recommendations for mid-size IT shop?

    redgate version 8 doesn't connect to 2012, but the updated versions of Schema Compare 11 handles 2012 and 2014 just fine; i'd look to see if your license includes upgrades,...

    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!

    June 30, 2015 at 12:57 pm

    #1809271

  • RE: Generate Unique string Id

    this is usually frowned upon, because the unique string generated can (and eventually Will) end up being an offensive word. there's no need to show a string, when a number...

    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!

    June 30, 2015 at 10:40 am

    #1809214

  • RE: Slow Database

    i believe SQL Server 2008 R2 Express edition will limit itself to using 1 gig of ram max, regardless of the amount of ram available on the host...

    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!

    June 30, 2015 at 9:38 am

    #1809185

  • RE: Deleting a file from file system. Worked before and now an error, strange.

    this is a real stretch, but maybe the a nother dba or the network team changed the service account, and that account doesn't have permissions to the share the way...

    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!

    June 30, 2015 at 8:40 am

    #1809159

  • RE: Query Question -- odd results

    can you add a logging fucntionality, that dumps some details to a log table as it completes each substep? then you can run it three or four times, and review...

    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!

    June 30, 2015 at 7:29 am

    #1809114

  • RE: How-to-return-next-values-and-concatenate-with_string (SQL Server 2012)

    that error would be pure syntax. you don't have a it's

    INSERT INTO TableName(ColumnList) VALUES ...

    or INSERT INTO TableName(ColumnList) SELECT ...

    you've mixed values with columns, so ti fails.

    INSERT INTO subs...

    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!

    June 30, 2015 at 5:30 am

    #1809065

  • RE: is .jet or .ace is used by ssis for excel file import.

    sqlcmd, bcp and bulk insert can import flat text files only, but the delimiters a can be anything; comma seperated, tabl seperated or pipe character seperated are probably the most...

    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!

    June 30, 2015 at 5:15 am

    #1809057

  • RE: Deleting a file from file system. Worked before and now an error, strange.

    is there a possibility that the filename @BackupFile has a space in it?

    this would be valid:

    DEL \\adas16.clients.advance.local\wip$\AvionteAP_Template_893.bak /Q

    but something like would fail:

    DEL \\adas16.clients.advance.local\wip$\AvionteAP - Full03-25-2015.bak /Q

    can you change your code...

    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!

    June 29, 2015 at 1:13 pm

    #1808907

  • RE: two indexes on same column

    i have a couple of tables like that in a vendor database; with a single column index on the PK;

    the funny thing is, that NC index gets used a lot...

    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!

    June 29, 2015 at 12:17 pm

    #1808878

  • RE: Reminder emails

    assuming the data is right, your query works for me;

    do you have a seperate table that tracks each email you sent out, asswociated to the unique item/ID? you need to...

    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!

    June 29, 2015 at 7:55 am

    #1808766

Viewing 15 posts - 1,651 through 1,665 (of 13,460 total)