Forum Replies Created

Viewing 15 posts - 8,236 through 8,250 (of 13,459 total)

  • RE: Calling Scalar Function within stored Procedure

    we'd really need the exact error you are getting...and also the exact code you are doing to really help. All i can offere is generalities.

    where is param1 and param2? are...

    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 6, 2011 at 9:58 am

    #1270186

  • RE: select pattern from the column name

    it's working for me, but you had a lot of reserved words for your column names, so i quoted them, and see it's working that way.....:

    With MyQuickTable AS (

    SELECT 'MONTH_20101006_1_out.txt'...

    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 5, 2011 at 3:51 pm

    #1269797

  • RE: Send mail without use Mail Server

    ok just checking the basics here...at my job, for example, google mail is blocked by our firewall because it's a corporate time waster...utube/facebook etc are all blocked as well...could google...

    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 5, 2011 at 3:43 pm

    #1269796

  • RE: Send mail without use Mail Server

    here you go: visually, this is exactly how my gmail account is set up, and it works...the important piece is the port and mailserver address:

    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 5, 2011 at 12:53 pm

    #1269724

  • RE: Send mail without use Mail Server

    so are you not allowed to setup dbmail on the SQL server, or you just don't have a specific SMTP mail server that you know you can use?

    I've setup 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!

    January 5, 2011 at 9:25 am

    #1269589

  • RE: Taking schema tables into consideration ,I want to create views with readonly permission

    do you mean you want to create a role so that when users connect, the tables are read only?

    USE Whatever

    CREATE ROLE [ReallyReadOnly]

    --give reader writes to 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 4, 2011 at 2:18 pm

    #1269210

  • RE: Returing Tables filled from a query inside a Function

    the short answer is because functions in SQL are different than functions in a programming language...they pretty much have to return data, and cannot change/update data.

    because dynamic SQL could potentially...

    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 4, 2011 at 12:43 pm

    #1269169

  • RE: need help about procedure

    also, this is just incorrect...maybe a copy paste error?

    @email is declared as a nvarchar(50), but you seem to be assigning it the results of a boolean...

    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 4, 2011 at 12:38 pm

    #1269167

  • RE: need help about procedure

    i copied and pasted your code into SSMS, and your syntax errors all seem to revolve around two issues: every CREATE PROC... statement must be in it's own batch...adding 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!

    January 4, 2011 at 12:35 pm

    #1269165

  • RE: Upper/lower case text

    sc-w (1/4/2011)

    I nearly missed that post, i tried the following but it generates an error. Any thoughts?

    update dbo.wce_contact set firstname = dbo.ProperCase(firstname)

    Error:

    Msg 1014, Level 15, State 1, Line 1

    TOP clause...

    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 4, 2011 at 12:13 pm

    #1269159

  • RE: sp procedure error

    spelling error.

    select statement gets SubmitTime,

    but the update statement is using SubmittedTime

    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 4, 2011 at 8:34 am

    #1269010

  • RE: Upper/lower case text

    sc-w (1/4/2011)

    Thanks for both the replies.

    I really like that function. How do i declare @OriginalText to be an actual field that alread exists?

    Thanks again.

    I should have added that to my...

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

    #1268988

  • RE: Upper/lower case text

    this is the ProperCase function I use; it's from a post by Jeff Moden, i believe, harvested long long ago.

    you can search for "ProperCase" or "InitCaps" here on SSC 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 4, 2011 at 6:07 am

    #1268885

  • RE: CLR to do a HTTPS Push to SMS Gateway

    why via the web interface of some provider? all the providers i know support email to sms, which is easier to do from SQL server; the problem is you 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 4, 2011 at 5:12 am

    #1268870

  • RE: Audit of sa logon

    just tested this, and it works fine, assuming you have dbmail setup with a profile;

    --DROP TRIGGER [TR_Logon_Trigger_Track_sa] ON ALL SERVER

    GO

    CREATE TRIGGER TR_Logon_Trigger_Track_sa

    ON ALL SERVER FOR LOGON

    AS

    BEGIN

    --the auditing...

    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 3, 2011 at 1:21 pm

    #1268658

Viewing 15 posts - 8,236 through 8,250 (of 13,459 total)