Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 13,460 total)

  • RE: Limited Management Console Access

    altering a table...adding/removing columns,creating or altering procs views, etc etc requires ddl_admin permissions.

    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 11, 2011 at 1:31 pm

    #1285889

  • RE: What is wrong my script?

    in this specific example, i cannot get it to raise the error, but I've encountered other situations where i must issue the GO command after an ALTER TABLE command before...

    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 11, 2011 at 1:25 pm

    #1285884

  • RE: order by ??

    your example's messing you up... a row of data is just that: each element is related to the others. grabbing a value from another row? why?

    if you substitute names 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!

    February 11, 2011 at 9:24 am

    #1285771

  • RE: The Oddest Interview Questions

    At one place I interviewed at, I had a good preliminary interview with a couple of people, one a manager, and the other an HR-type, but it was all high...

    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 11, 2011 at 7:02 am

    #1285668

  • RE: Barcodes Code128 generator function

    a quick google lead me to this solution posted from Dalton from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70901

    declare @myString varchar(255)

    select @myString = 'BarCode 1'

    -- Define the string of characters that we'll need to pull the...

    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 11, 2011 at 6:12 am

    #1285636

  • RE: How to Schedule a SQL Trace ?

    I'm in the same camp of not worrying about the trace impact after this article about the near-zero impact of a server side trace where someone actually compared the...

    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 11, 2011 at 5:11 am

    #1285619

  • RE: Why doesn't this 'select round(5/2,0)' output 3?

    the integer division, 5,2 is evaluated before the round occurs.

    if you divide two integers in SQL, the result is returned in the same datatype...an integer.

    That behavior is kind of unique...

    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 10, 2011 at 6:29 pm

    #1285539

  • RE: db diagram

    I know if you right click the diagram in 2005 and above, there is a "Copy To Clipboard" option, but it copies as an image/bitmap, so you can paste 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 10, 2011 at 3:25 pm

    #1285507

  • RE: RIGHT OUTER JOIN not returning correct data

    those "ISO-11179 rules" aren't rules, they are guide lines, or at least an attempt at best practices; calling them anything other than is misleading.

    no DBMS system anywhere prevents you from...

    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 10, 2011 at 3:07 pm

    #1285501

  • RE: Count of variables with a particular value

    the trick here is to the the SUM of a CASE which tests the columns you are after;

    take a look at my example below;

    based on your post, something like this...

    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 10, 2011 at 1:59 pm

    #1285465

  • RE: Selecting a word from all the columns in a table

    here's something i put together a long time ago; this requires one tablescan for the EXISTS() of every table that has a char/varchar/nchar/nvarchar column in it's definition...

    so if you have...

    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 10, 2011 at 1:51 pm

    #1285462

  • RE: Timeline for learning SQL

    standard answer...it depends: experience is based on challenges and problems you learn to overcome, right? it depends ont he work environment.

    if you write reports, you could expect 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 10, 2011 at 11:36 am

    #1285377

  • RE: find top 50 values from 90% records of table.

    what have you tried so far?

    SQL supports the TOP command, ie

    --last 90 days of data

    SELECT TOP 50 ColumnList From MyLogTable Where SomeDate > dateadd(dd,-90,getdate())

    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 10, 2011 at 11:18 am

    #1285365

  • RE: Select rows from a table whcih was a result of join statement

    i got thru turning your post into consumable data, and ran out of gas....

    if the data was already in consumable format, i probably would have worked on a solution instead.

    here'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!

    February 10, 2011 at 11:13 am

    #1285360

  • RE: Date format in view used for mailmerge

    No we are on the same page.

    a mailmerge substitutes [Fieldname] in the word document with whatever value is coming from the database. but in many cases, you wan thte value...

    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 10, 2011 at 8:15 am

    #1285237

Viewing 15 posts - 8,116 through 8,130 (of 13,460 total)