Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 13,460 total)

  • RE: Convert MSSQL date to MySQL date

    any chance teh report is returning results that create something like this, which would of course return no records?

    WHERE (recordDateTime BETWEEN '2001-01-01' AND NULL)

    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!

    December 5, 2011 at 12:30 pm

    #1416979

  • RE: Convert MSSQL date to MySQL date

    MyDoggieJessie (12/5/2011)

    I assume you're using a linked server....can you post the SQL statement please?

    if you are using parameters, you are making sure the datatype of the parameters are datetimes 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!

    December 5, 2011 at 12:21 pm

    #1416971

  • RE: Using initial query results to build sub query

    mySQL does not support Common Table Expressions. SQL and Oracle do, and you asked ina SQL forum.

    instead, you have to move the example into a named Alias...same thing, just...

    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!

    December 5, 2011 at 11:02 am

    #1416890

  • RE: Date Coding Format - Is there any benefit of using YYYYMMDD OR DD-MM-YYYY? what is most common and why preffered?

    Dev (12/5/2011)

    SQL Server stores datetime in YYYY-MM-DD hh:mm:ss[.fractional seconds] format. Rest all the formats are result of cast / convert functions and added operation on t-sql.

    CAST and CONVERT...

    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!

    December 5, 2011 at 10:34 am

    #1416861

  • RE: How to create a role and make all data owned by that schema

    Paula here's an example i built for another post, I think it describes everything you are looking for.

    the key is to apply a default schema to the users; then any...

    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!

    December 5, 2011 at 8:58 am

    #1416747

  • RE: SQL Code Help

    i'm not sure why you wnat to loop; you could do the entire table in a single pass

    something like htis:

    SELECT ' Invalid data: record '

    ...

    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!

    December 5, 2011 at 8:10 am

    #1416717

  • RE: SSRS- Needs to display All month

    you have to join a Calendar table of some sort in order to generate your missing values.

    Search here on SSC for Calendar Table or Tally Calendar.

    If you can show us...

    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!

    December 2, 2011 at 2:55 pm

    #1416195

  • RE: Storing "BLOB" data

    the app probably recognizes the TEXT or IMAGE datatypes.

    I've got applications that *think* they are storing in an TEXT column or an IMAGE data field , but i had converted...

    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!

    December 2, 2011 at 10:12 am

    #1416053

  • RE: Extracting Documents (.pdf, .doc, .xls, etc) stored in image type fields in multiple rows

    here's a VB.Net snippet I wrote and tested for a different post on the same subject;

    with a few tweaks realted to the connection and table to select from, 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!

    December 1, 2011 at 2:51 pm

    #1415613

  • RE: Why does this union add so much time?

    where's the link to Gails articles about catch all queries?

    ( -- Get Non-Peer Categories without regard to Assignments

    (esc.statusname != 'PEER' And @FilterAssigned = 0)

    OR -- Get Non-Peer Categories Assigned 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!

    December 1, 2011 at 2:28 pm

    #1415602

  • RE: Mind mapping software - How it can help the DBA

    amazing how smart i feel when i discover something i knew nothing about previously!

    Like others have noted, this looks like a very useful tool!

    Thanks!

    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!

    December 1, 2011 at 11:34 am

    #1415479

  • RE: Extracting Documents (.pdf, .doc, .xls, etc) stored in image type fields in multiple rows

    Cadavre pretty much what i was thinking, unless she doesn't have access to 2005+, which means no varchar(max) or CTE's...it's all textpointers and stuff if she's locked into 2000, not...

    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!

    December 1, 2011 at 9:54 am

    #1415384

  • RE: Extracting Documents (.pdf, .doc, .xls, etc) stored in image type fields in multiple rows

    Nancy you posted in a SQL 200 forum, so I'm assuming a lot here; i'm guessing the data is chopped up into VARCHAR(8000) columns, instead of being stored in an...

    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!

    December 1, 2011 at 9:44 am

    #1415372

  • RE: DDL Database Trigger causes error when Droping Table

    go to tools options...

    i'm guessing the default settings on your specific connection do not have the same settings as mine, for example:

    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!

    December 1, 2011 at 8:40 am

    #1415318

  • RE: Database Mail fails to send with no errors in sysmail_event_log

    in some other dbmail related threads, there was a lot of examples/issues where even though dbmail was set up correctly, the service broker itself was not performing it's duties.

    as a...

    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!

    December 1, 2011 at 7:48 am

    #1415270

Viewing 15 posts - 6,286 through 6,300 (of 13,460 total)