Forum Replies Created

Viewing 15 posts - 6,031 through 6,045 (of 13,460 total)

  • RE: Almost a Delimited Split kind of Join?

    Thanks Mark, but i think that won't quote work;

    in the full table, i have more paths than just the "Program Files\Microsoft SQL Server" path example, many other paths might 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!

    January 23, 2012 at 6:58 am

    #1437064

  • RE: sp_MSforeachtable

    ahh didn't know you were in SQL 2000; didn't read the forum.

    max has no practical limit, but is SQL2005 and above, sorry.

    maxsize in SQL2000 is NVARCHAR(4000) for an NVARCHAR; 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 20, 2012 at 2:02 pm

    #1436743

  • RE: sp_MSforeachtable

    do you need the results on a per table command?

    i've done something similar by building the string and executing it:

    DECLARE @mycommand1 nvarchar(max);

    SET @mycommand1=''

    SELECT @mycommand1 = @mycommand1

    + N'DBCC...

    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 20, 2012 at 1:13 pm

    #1436714

  • RE: Encrypted fields

    durai nagarajan (1/20/2012)

    Hello,

    This DB was not built by me. SQL 2005 DB.

    Basics Employee code, name and certain things are encrypted in this DB.

    None of the table has primary key,...

    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 20, 2012 at 11:08 am

    #1436642

  • RE: Compute table column based on other columns by month

    Ninja's_RGR'us (1/20/2012)

    Ehh, why not sum(case) ???

    duh...err...no excuse. that's the right solution.

    not thinking straight.

    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 20, 2012 at 11:00 am

    #1436636

  • RE: Compute table column based on other columns by month

    we'd really need to see the DDL of the table that the data gets extracted from to offer more than a suggestion or prototype.

    I'd create a view instead that joins...

    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 20, 2012 at 10:19 am

    #1436624

  • RE: SQL Server Collation (ASCII Table sort and Case Insensitive/Accent Insensitive)

    well i couldn't figure out what order you wanted via your example;

    lets switch to real code so we can figure it out better.

    does this do what you want? what's wrong...

    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 20, 2012 at 9:58 am

    #1436618

  • RE: Script out Jobs & Logins Master DB

    i just copied and pasted my quoted command, and tested it in both SQL2005 and SQL2008, and i got results with no errors at all.

    I'm not sure where your issue...

    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 20, 2012 at 6:54 am

    #1436456

  • RE: SQL Server Collation (ASCII Table sort and Case Insensitive/Accent Insensitive)

    remember what case-Insensitive collations are used for: if i search for "apple' or "Apple" or "APPLE", i'd get results. that's perfect. now if i want to ORDER those results, 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 20, 2012 at 12:49 am

    #1436301

  • RE: Creating Index on DATETIME Column based just DATE

    sudhirnune (1/19/2012)

    I have a table which has a column (ISSUE_DATE) which is a date time Data type.

    But for improving the Query Performance i need to Index the Table based on...

    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 20, 2012 at 12:16 am

    #1436295

  • RE: What is the safest less risky way to move System Databases to another Server?

    you are all set buddy; the link and version i sent you works for 2005 and above, so that includes a 2005 to another 2005, if you were 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!

    January 19, 2012 at 12:58 pm

    #1436137

  • RE: Daylight savings is for the birds!

    While we are on the subject of things that annoy us but cannot control...

    there are a pair of stop lights near my house that take entirely too long 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!

    January 19, 2012 at 12:12 pm

    #1436116

  • RE: Determining where or how a connection is being made to SQL

    kurtwest (1/19/2012)

    Is there a trick to using cut and paste on the T-SQL scripts people post on here? When I do cut/paste it makes one long line with 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 19, 2012 at 11:53 am

    #1436108

  • RE: SQL compatibility_level changing to 100 by itself on a production database

    I just tested this by toggling my Sandbox database's compatibility level, and it does appear in the default trace;

    it shows up as an ALTER DATABASE event, with the whodunnit information...

    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 19, 2012 at 11:23 am

    #1436091

  • RE: Query

    if "using" means SELECT FROM that table, only way is by adding a trace so you can see who's selecting stuff from it;

    for INSERt/UPDATE/DELETE, you could add a trigger which...

    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 19, 2012 at 9:55 am

    #1436020

Viewing 15 posts - 6,031 through 6,045 (of 13,460 total)