Forum Replies Created

Viewing 15 posts - 7,351 through 7,365 (of 13,460 total)

  • RE: URGENT HELP NEEDED

    since you are using access, those are two different queries;

    the GO statement is valid for SQL Server;

    each of the two queries needs to be saved separately...been a while since 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!

    June 22, 2011 at 4:42 am

    #1342302

  • RE: URGENT HELP NEEDED

    m.dodd (6/22/2011)

    the depart time is generated when the visitor clicks the Out button on the access form (taken from the computers time)

    the method of entry into a table wouldn't 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!

    June 22, 2011 at 4:32 am

    #1342298

  • RE: URGENT HELP NEEDED

    moving the data more complex than it need to...

    i don't see a need to move the data, other than it makes "sense" to someone (the data is different...

    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 22, 2011 at 4:12 am

    #1342293

  • RE: How to Left Justify Results

    i've done this on the .NET side of things, after i've already loaded the data into a .NET DataTable.

    from there, it's fairly easy to format the data into a string...

    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 21, 2011 at 8:36 am

    #1341883

  • RE: Cannot install SQL 2005 on the D drive.

    Duran (6/21/2011)

    Hello,

    I'd imagine that somebody would have come across this before, I am trying to install SQL 2005 R2 (downloaded from MSDN) to install in the D drive, I specify...

    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 21, 2011 at 6:16 am

    #1341779

  • RE: help for select statement

    nice job on posting details so we can follow along...but is there a question in there somewhere? is this related to compact edition(the forum you posted) or a specific version...

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

    #1341767

  • RE: Need help with store proc.....that great

    ok first the concept:

    you can use DATADD and DATEDIFF to fiddle with dates, keeping everything in the proper datetime variable.

    test this to understand the concept:

    select

    --midnight of TODAY.

    DATEADD(dd, DATEDIFF(dd,0,getdate()), 0),

    --older...

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

    #1341356

  • RE: OS + SQL Server binaries on same drive?

    i seem to remember that the biniaries that are the core srvice and stuff must be installed on the %systemdrive%, with no choice in the matter...you can move the databases,...

    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 20, 2011 at 9:49 am

    #1341286

  • RE: insert a value AND the results of an exec.

    if you cannot use the builtin getdate() function for the current date and time,

    you can stick the results into a temp table, and insert from there as well.

    CREATE TABLE...

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

    #1341067

  • RE: Batch alter stored procedure within one single transaction with error handling

    yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with GO statements...

    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 16, 2011 at 7:21 am

    #1339676

  • RE: Batch alter stored procedure within one single transaction with error handling

    see opc.three's post from the thread below;

    i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know better:

    http://www.sqlservercentral.com/Forums/Topic1125836-391-1.aspx#bm1125844

    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 16, 2011 at 6:55 am

    #1339636

  • RE: sql cmd shell execution:

    the hanging of the app from the command line is that messagebox dialog, guaranteed;

    I hate to say this, but you'll have to check the 3rd party apps documentation to supress...

    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 16, 2011 at 6:52 am

    #1339632

  • RE: sql cmd shell execution:

    malachyrafferty (6/16/2011)

    hi all

    i have a 3rd party demo software called Crystal Command which lets you execute a crystal report in the background using command shell and save it/email it etc

    what...

    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 16, 2011 at 6:42 am

    #1339621

  • RE: Deleting 4000 different records from a table with where and conditions on each row.

    what's this post counter of which you speak?:-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!

    June 15, 2011 at 1:08 pm

    #1339259

  • RE: SELECT TOP 0 * INTO

    Kevin for me, to get a table based on select into, I usually use a WHERE statement that will guarantee no rows:

    SELECT * INTO ...

    WHERE 1=2

    that builds...

    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 15, 2011 at 12:36 pm

    #1339218

Viewing 15 posts - 7,351 through 7,365 (of 13,460 total)