Forum Replies Created

Viewing 15 posts - 12,091 through 12,105 (of 13,460 total)

  • RE: LITERAL STRINGS

    are you sure the zero is causing the problem, it's alias? try SELECT 0 as CNT instead of the reserved word COUNT

    also, careful with the datefield...

    it's good practice ...

    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!

    May 1, 2008 at 8:27 am

    #809581

  • RE: replication doubt

    the primary key alows the replication service to uniquely identify every row in a table.

    in that manner, it is much easier to tell the recipient database of the replication...

    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!

    April 14, 2008 at 7:15 am

    #802047

  • RE: Copy XLS (LOCAL) to SQL (Remote) table without link server or BCP or .NET code

    iitt2007 (3/31/2008)

    I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server -...

    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!

    April 9, 2008 at 12:20 pm

    #800575

  • RE: Splitting Table Column on Delimiter

    boy I really agree; It's a stupid Project requirement that all "raw data" is imported from text into SQL Server database, and then the data massaged from there.

    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!

    April 1, 2008 at 9:51 am

    #796640

  • RE: Splitting Table Column on Delimiter

    I'm putting this thru it's paces now Jeff;

    The data I'm trying to parse is some FIP55 data with every place name in the united states; 560 meg of data, 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!

    April 1, 2008 at 8:44 am

    #796551

  • RE: Splitting Table Column on Delimiter

    that's what i was looking for antonio; i remember using a different kind of split function for the same type of results. it's the cross apply and the row_number() over...

    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 31, 2008 at 12:02 pm

    #796091

  • RE: Need a script to create a new user based on existing user's permission

    I think what you are looking for is almost built in:

    in MS SQL Server Management Studio, browse to Server>>Security>>Logions (NOT [specific database]>>Security)

    right click on the existing user you want 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!

    March 4, 2008 at 10:48 am

    #785076

  • RE: Large size MSDB, log_shipping_monitor_histroy_detail

    I believe you simply have to shrink the msdb database.

    running sp_cleanup_log_shipping_history will remove rows from the history tables, but that just created free space--the space is still reserved for future...

    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 4, 2008 at 10:39 am

    #785071

  • RE: sql server management studio express data attach won't open some of the folders in the tree heirarchy

    you created them using your admin account, but when you connected with SSIs Express, did you connect as that same user, or as a SQL Server login, like 'sa'?

    that might...

    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, 2008 at 10:38 am

    #783357

  • RE: Push Images from hand held device

    can youc hange your primary key? instead of using some integer value, use the combination of HandheldId + Image_Surr_Key; that way Image_Surr_Key can repeat, but the combination of handheld...

    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 27, 2008 at 9:41 pm

    #782978

  • RE: how to zip file

    I put a copy of PKzip25 in a zip file, along with a .SQL file containing an example, which you can download here

    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 27, 2008 at 5:19 pm

    #782945

  • RE: logic needed for date

    kurraraghu (2/27/2008)

    but whats the logic is it the number of days from 1990 yr is that the one i jus want to know that logic ....

    yes, the logic is 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 27, 2008 at 10:14 am

    #782686

  • RE: logic needed for date

    when converting a number to datetime, the date portion is left of the decimal place, and the time portion is to the right of the decimal point.

    I think it really...

    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 27, 2008 at 9:57 am

    #782658

  • RE: Extracting a specific number of words from a string in sql

    Matt Miller (2/27/2008)

    Lowell - if you're on 2005 - use CLR instead to create the REGEX expressions instead. The XP is nice in 2000, but you can do better...

    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 27, 2008 at 7:38 am

    #782518

  • RE: Extracting a specific number of words from a string in sql

    I know that by using regular expressions, the \b is a word boundary; it might be a space/tab/Crlf, or it might be punctuation...period comma exclamation semicolon etc.

    using regualr expressions, you'd...

    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 27, 2008 at 6:59 am

    #782479

Viewing 15 posts - 12,091 through 12,105 (of 13,460 total)