are you familiar with using the GROUP BY statement? i think a SQL combined with some of the functions that are allowed using group by (MIN(),MAX()AVG())

would get you what...

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...

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'...

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...

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:

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...

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...

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...

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...

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...

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...

spelling error.

select statement gets SubmitTime,

but the update statement is using SubmittedTime

I should have added that to my...

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...

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...