Forum Replies Created

Viewing 15 posts - 11,701 through 11,715 (of 13,460 total)

  • RE: records with distinct IDs

    excellent!

    that helps a lot, thanks. I can script and test agaisnt your example data now.

    but what about the business logic?

    what makes the record "e001 ...

    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!

    January 28, 2009 at 7:25 am

    #933796

  • RE: records with distinct IDs

    not enough information;

    what makes the record e001 A valid,

    and the e001 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!

    January 28, 2009 at 7:12 am

    #933776

  • RE: SQL Proper Case Command

    OK in another shameless adaptation of Tally examples, I'll attempt to get Jeff Moden some more recognition.

    Here is a propercase function based on the Tally table. here I'm checking 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!

    January 27, 2009 at 12:08 pm

    #933437

  • RE: Show dummy row for query between 2 dates

    Typically, you want to use a Tally or Numbers table to "fill in the gaps" for sequences or dates.

    I couldn't get my mental arms around your example to change 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!

    January 27, 2009 at 11:43 am

    #933426

  • RE: get hourly combine data

    lol I'm on the ball today...rare for me

    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!

    January 27, 2009 at 11:07 am

    #933395

  • RE: get hourly combine data

    SELECT CONVERT(VARCHAR,@YOURDATECOLUMN,101),HOUR(YOURDATECOLUMN)

    FROM YOURTABLE

    group by CONVERT(VARCHAR,@YOURDATECOLUMN,101),HOUR(YOURDATECOLUMN)

    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!

    January 27, 2009 at 10:56 am

    #933385

  • RE: Need to transfer videos (25 GB) from one server to an other

    403 is web page permissions....

    maybe you can FTP or SFTP to your server? since it's a web page error, i assume your other server is remote over the internet 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!

    January 27, 2009 at 10:50 am

    #933383

  • RE: Need to transfer videos (25 GB) from one server to an other

    back up the database, zip, transfer to the new server, unzip and restore is sure to be the fastest way as well as the most dependable;

    transfering over the wire, 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!

    January 27, 2009 at 10:39 am

    #933372

  • RE: Are the posted questions getting worse?

    my absolute favorite posts to read are the ones where they say "urgent" in the title.

    they are invariably from a poster who just joined, has less than 5 posts, 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!

    January 26, 2009 at 10:14 pm

    #932990

  • RE: Calling VBScript or command file from within T-SQL without xp_cmdshell??

    As Jeff said, chances are whatever you were going to do, you could do it in tSQL;

    outside of that, you can use sp_OACreate to run vbscripts, or an executable, or...

    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!

    January 26, 2009 at 9:05 pm

    #932975

  • RE: Very Simple User Define Function Returning Zero

    SQL server doesn't bother with changing data tytpes when it sees integer divided by integer...it returns an integer value.

    change so that your 2 is 2.0:

    RETURN 2.0/(@Period + 1.0))

    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!

    January 26, 2009 at 9:02 pm

    #932972

  • RE: Replace Command

    Follow with what Jeff And Lynn said; repalce with an int where isnumeric is true:

    UPDATE YOURTABLE SET Login = Convert(varchar,CONVERT(INT,Login)) Where IsNumeric(Login) =1

    the rows like 'jc4444' will not be...

    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!

    January 26, 2009 at 10:27 am

    #932704

  • RE: How to Insert multiple rows if quantity is more than 1

    by using a Tally or Numbers table, you could insertall the items, with the proper qty's in in a single statement:

    CREATE TABLE #TEMP (QTY INT, ORDERITEM VARCHAR(30),MORESTUFF VARCHAR(30) )

    INSERT INTO...

    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!

    January 26, 2009 at 5:55 am

    #932541

  • RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

    there was a different thread on zipcodes here where i posted a text file to a bunch of zip code/city/state stuff...are you just trying to get a list of 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!

    January 23, 2009 at 7:54 pm

    #932138

  • RE: get timestamp from Oracle via Linked server

    since current_timestamp is a variable, it really doesn't matter which table you get it from;

    by same question, you mean from a linked sql server?

    i did select top 1 current_timestamp 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!

    January 23, 2009 at 7:49 pm

    #932134

Viewing 15 posts - 11,701 through 11,715 (of 13,460 total)