Viewing 15 posts - 2,281 through 2,295 (of 7,502 total)
Do you want to return all last names in a single return field or do you want to return a set of all last names ( row based ) ??
If...
February 26, 2011 at 1:06 am
search Books Online on "GROUP BY clause, AVG function".
You'll find nice examples of what you need.
February 26, 2011 at 12:56 am
I'm not going into details on this one. It's been couvered totally already.
RBarry, it is ok to refer to your series of article on how to lose the cursors and...
February 26, 2011 at 12:46 am
must be homework :ermm:
just select the columns you need and add a count(*) as nLogins
Convert your datetime column so the startime is converted to 00:00:00.000
( or convert it to date...
February 26, 2011 at 12:32 am
there is also a free downloadable ebook at red-gate called "sql server statistics". It states the magical figure of 100 rows.
It also has some statements on the differences of @...
February 25, 2011 at 2:22 pm
Steve.hitch (2/25/2011)....
Unfortunately, the way this data is arranged doen't allow for unique keys. The data captures project data for employee by date. The payroll system will allow multiple entries for...
February 25, 2011 at 1:41 pm
indeed, a udf needs to be addressed schema qualified.
select yourschema.yourudf( paramcol )
from yourobject
....
February 25, 2011 at 11:29 am
So, on this logging table, how do you identify a single row ?
If you cannot: Is this worth a concern for your data system ?
If that is a concern, one...
February 25, 2011 at 11:26 am
strange a monitoring company doesn't manage their db and db logs.
Please read the article Gail pointed to. It will clarify our concerns.
In many cases, people think they don't need PIT...
February 25, 2011 at 11:17 am
Roy Ernest (2/25/2011)
Feeling much better, Thanks. It is difficult to keep with the THREAD if you dont read the THREAD for just couple of hrs. 😀
Maybe we should ask OP...
February 25, 2011 at 8:31 am
If to you NULL = '' then declare you column NOT NULL !! (maybe even add "with default '' )
there are some nice article regarding NULL and its impact...
February 25, 2011 at 5:24 am
Just make sure you include the catalog name ( i.e. dbname) in your joins.
Of course only pick the columns you need. (c.* :ermm: )
--sp_pkey
SELECT kcu.COLUMN_NAME
...
February 24, 2011 at 1:49 pm
If I'm correct you need middleware for SQL2005.
With SQL2008 MS did aquire that middleware.
Now, if only I could recall the exact name.
February 24, 2011 at 1:31 pm
the log can only grow because of database activity.
log entries will only be truncated at the end of a log backup (see Gails previous replies)
So even if the tape is...
February 24, 2011 at 12:58 pm
Lowell (2/24/2011)
February 24, 2011 at 6:48 am
Viewing 15 posts - 2,281 through 2,295 (of 7,502 total)