Forum Replies Created

Viewing 15 posts - 9,346 through 9,360 (of 13,460 total)

  • RE: Date Comparison Problem

    it's all good; i just moved the WEHRE statment into a CASE so i could print a status:

    SIGNING_DATEENTRY_DATETimeStatus

    2010-05-01 00:00:00.0002010-05-04 00:00:00.000On Time Signing

    2010-05-01 00:00:00.0002010-05-07 00:00:00.000On Time Signing

    2010-05-01 00:00:00.0002010-05-10 00:00:00.000Exception Not within...

    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 27, 2010 at 8:45 am

    #1173361

  • RE: Delete parent record

    you can't without breaking referential integrity.

    Otherwise you'd be dropping the foreign key constraint, or disabling the foreign key constraint so it would be invalid after you deleted the parent record.

    maybe...

    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 27, 2010 at 8:32 am

    #1173355

  • RE: Date Comparison Problem

    still the same idea, i think; for example the week of today is 22:

    select datepart(week,getdate())

    so biz day wise, m-f of this week is 22, m-f of last week is 21;

    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!

    May 27, 2010 at 8:29 am

    #1173354

  • RE: Convert Julian date to Gregorian date

    pinky i guess the question is what do you want to do if the date is invalid?

    return NULL?

    SELECT

    juliandate,

    CASE

    WHEN juliandate LIKE...

    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 27, 2010 at 8:24 am

    #1173348

  • RE: Opening Internet Explorer Using SQL-CODE

    Gopi Muluka (5/27/2010)

    Did you tried this?

    Exec xp_cmdshell '"C:\Program Files\Internet Explorer\iexplore.exe"'

    the problem with that is it will spawn an iexplorer instance, but not clean up after itself...after one hour, you'd 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!

    May 27, 2010 at 8:18 am

    #1173342

  • RE: Date Comparison Problem

    jared here's an example i think can show you the idea;

    you want to use BETWEEN two dates, and use DATEADD to determin the range based on another date:

    --results

    SIGNING_DATEENTRY_DATE

    2010-05-01 00:00:00.0002010-05-04 00:00:00.000

    2010-05-01...

    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 27, 2010 at 8:16 am

    #1173341

  • RE: Opening IE With Sqlserver code

    wrong tool for the job.

    what are you trying to accomplish? is this a keep alive so your web page stays in the server cache?

    what's wrong with calling iexplorer.exe from windows...

    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 27, 2010 at 8:05 am

    #1173330

  • RE: Opening Internet Explorer Using SQL-CODE

    wrong tool for the job.

    what are you trying to accomplish? is this a keep alive so your web page stays in the server cache?

    what's wrong with calling iexplorer.exe from windows...

    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 27, 2010 at 8:04 am

    #1173329

  • RE: want a way..

    V in your first query of the UNION ALL you have this as part of the WHERE arguments:

    CFA.ORGID IN ('*','SERVICE','4C0C6A2U7P','4X9A8F2U5A')

    but in the second part of the union 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!

    May 27, 2010 at 7:04 am

    #1173291

  • RE: Trace table inserts/updates

    Baskar B.V (5/26/2010)

    Hi,

    I am planning to write a trace to capture the trace for inserts/updates happening in sql-server tables across a server. Which event i should use to capture that?...

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

    #1173289

  • RE: BULK INSERT failed on remote computer

    well i'd guess it was permissions of the service account running SQL, even though you said it's got permissions;

    if you have xp_cmdshell enabled, you could see if this returns results,...

    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 26, 2010 at 12:23 pm

    #1172946

  • RE: Create DB Script

    if i google Error 2147217900 , there are at least 4 different error descriptions related to that error number in the top 10 links i found...we'd need the error description...

    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 26, 2010 at 8:12 am

    #1172753

  • RE: A script to create login to a list of Servers and instances

    but having credentials that are valid is the precursor to doing anything to each server.

    so what if i know databaseserver.google.com exists, can i loginto it with a known username? can't...

    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 26, 2010 at 8:07 am

    #1172746

  • RE: A script to create login to a list of Servers and instances

    well you gotta be sysadmin to add sysadmins...so can we assume you can login as 'sa' on every machine?

    the easiest way would be to add your windows login to each...

    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 26, 2010 at 7:49 am

    #1172723

  • RE: IDERA SQL Virtual Database - too good to be true?

    is there a downloadable demo of this, even crippleware for using only the Adventureworks db or something?

    this sounds too good to be true, so I'd like to see it form...

    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 26, 2010 at 7:12 am

    #1172683

Viewing 15 posts - 9,346 through 9,360 (of 13,460 total)