If you want to compare dates in string format you must use the 111 date format, because this way you'l have first the year, then the month and finally the...

I guess you coud code some function to calculate the unique number per combination of the four parameters. Something like this:

CREATE FUNCTION fn_UniqueNumber

(

@empid int, @StateNo int, @CityNo int, @CallType...

You just need to change your query to the following:

Select w.* from webs w

LEFT JOIN docs d

ON w.id = d.webid

and w.id = '12345'

...

You just need to change your query to the following:

Select w.* from webs w

LEFT JOIN docs d

ON w.id = d.webid

and w.id = '12345'

AND...

It seems you have problems connecting to the domain: SQL server Service is unable to get the security credentials of the logged NT user. Are U logged locally or you...

Hi Yaniv,

May be the question was not the correct one. I was wondering if exists some way to receive mail using some SQL "service"  or "tool" or something else...

The goal is...

I'm not an expert using SQL server, but recently I tried to configure SQL mail to use a POP3 server to download mail, and it did  not work because it...

I'm sorry if I disturbed You. It was not my intention at all. In any case you replied because you wanted to.

Thanks anyway

Certainly they could see which stored proccedures appeared, but the actual code of the sp will be encrypted. That's the point.

This is not the "whole" security demanded though... just...

1- First I create one readable script for may personal use like this:

CREATE PROCEDURE myprocedure

  @param1 int

WITH ENCRYPTION AS

2- I run this script on my test database and after that I'll...

I have tested the previous method and it works ... any comments???

Thanks bkelley,

I assume it's possible create the procedure in my  development  database using the "WITH ENCRYPTION" clause.This will create an encrypted sp, then I could script this encrypted stored proc and deploy...

Thanks for your your suggestion... How would I like to have just one and only one table!!!, but all the system is based on these periodical tables, and I'm just trying...

Thanks rsharma, that's exactly the stuff i needed!!!

Thanx a lot, it's exactly what i need.

Cheers,

Felix