Forum Replies Created

Viewing 15 posts - 4,111 through 4,125 (of 13,460 total)

  • RE: mail merge in sp

    the example you found from simpletalk

    http://www.simple-talk.com/code/WinWord/spExportToWord.txt

    has nothing to do with mailmerge; it's just an example automating the population of data into a word document;

    worse, you didn't modify it...

    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 21, 2013 at 8:13 am

    #1579271

  • RE: mail merge in sp

    I dont believe you can.

    You cwn open word and use word to select a datasouece which is on a sql server.

    But sql has no way to call word 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 19, 2013 at 3:57 am

    #1578939

  • RE: How to match a UNICODE NULL character within an nVarchar(128) string?

    mrTexasFreedom I'm glad my code helped a bit, but mister magoo really identified the culprit, i think;

    some process imported(and maybe still imports) data that should be nvarchar instead of varchar;...

    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 18, 2013 at 3:22 pm

    #1578901

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/18/2013)

    All we need is an actual Go Faster flag for the database, and everything will be FINE.

    got your fix right 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!

    January 18, 2013 at 12:21 pm

    #1578844

  • RE: Replication Oracle to 2008R2 - truncated update commands?

    ok just checking the basics here;

    I'm assuming you are reviewing the code in SSMS? by default, to save memory, SSMS limits results to the first 256 characters...have you already changed...

    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 18, 2013 at 11:22 am

    #1578825

  • RE: Which Stored Procedure changed

    leela3soft (1/18/2013)

    Thank you very for providing the information to identify who modified the SP's & sql objects.

    glad this post helped you out!

    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 18, 2013 at 10:55 am

    #1578811

  • RE: How to match a UNICODE NULL character within an nVarchar(128) string?

    or another version: a scalar function that would remove anything that was not A-Z/numeric:

    same basic logic, i think:

    select

    id,

    name,

    dbo.StripNonAlphaNumeric(name) As Fixed

    from my_user_table

    If that's cleaning up...

    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 18, 2013 at 10:54 am

    #1578809

  • RE: DENY and REVOKE for Roles and Users

    Ells (1/18/2013)

    Are my assumptions correct in that a deny would for USerB overrule the access that it had as USerN and as a member of RoleA?

    Its mainly the difference between...

    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 18, 2013 at 5:53 am

    #1578657

  • RE: DENY and REVOKE for Roles and Users

    REVOKE would remove a GRANT from the permissions matrix (if it existed). In my head, i think "UN-GRANT"

    DENY would add a new entry to the permissions matrix, and prevent access,...

    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 18, 2013 at 5:27 am

    #1578652

  • RE: 64-bit Linked server to 32-bit Access File

    i believe there is a bug in the ACE drivers which affects Access but not Excel, even if you've installed the 64 bit versions;

    there's a connect item on it with...

    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 17, 2013 at 2:47 pm

    #1578480

  • RE: Best way foward

    SQL2012/2008R2/2008 Express is free, allows a database of 10 gig, and is much much easier to use than CE;

    CE is a very trimmed down database version that is aimed towards...

    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 17, 2013 at 12:01 pm

    #1578430

  • RE: Increase speed - Scalar Function

    rootfixxxer (1/17/2013)

    Never used ITVF before, so how do i replace my function by the ITVF? 😀

    without the code i mentioned previously, it's really hard to guess;

    since i cannot test 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!

    January 17, 2013 at 10:19 am

    #1578413

  • RE: Increase speed - Scalar Function

    the cursor is your # 1 performanceproblem then.

    i'm sure you can replace it with a set based function:

    if you are doing the same logic to each row in the cursor,...

    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 17, 2013 at 10:11 am

    #1578407

  • RE: Increase speed - Scalar Function

    well, the obvious fix is to use an Inline Table Valued function instead of a scalar function;

    i was able to convert it easily, but the example usage you pasted is...

    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 17, 2013 at 9:42 am

    #1578385

  • RE: how to find dependent objects on Default or Rule in sql 2008

    and some ready made code to test it: creates a rule and a column that uses it:

    CREATE RULE [dbo].[NumericCharsOnly]

    AS

    --@value NOT LIKE '%[0-9,-+]%' ESCAPE '!' --bad way...minus and spec...

    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 17, 2013 at 8:39 am

    #1578353

Viewing 15 posts - 4,111 through 4,125 (of 13,460 total)