deep_kkumar (6/18/2012)

---

We had an issue with one of the log files grow out of proportion. We haven't received any alerts. I am trying to automate the process only for the...

Grant Fritchey (6/18/2012)

---

Lynn Pettis (6/18/2012)

---

Grant Fritchey (6/18/2012)

---

That's how you get the...

Not enough information. How are the records releated to each other in your expected results?

Why are you trying to automate shrinking your log files? They are just going to have to grow again depending on database activity which will impact system performance.

Certifications are not worthless. The problem is actually that some people are able to get the certifications even though they can't do the tasks required. I worked with...

How many users can potentially access your database(s) on the server?

Grant Fritchey (6/18/2012)

---

That's how you get the 2012 OLTP AdventureWorks2012 sample...

Caruncles (6/18/2012)

---

I apologize if this is not the right place for this question. I couldn't seem to find anything close.

I'm troubleshooting a stored proc and came across this syntax:

AND...

Have to ask first, why are you trying to attach the mdf file without its associated ldf file?

kharol (6/18/2012)

---

Hi Gail,

This is inline table valued function. It looks pretty much like this:

CREATE FUNCTION [dbo].[SomeTVF]

( @param1 varchar(50)

, @param2 datetime

, @param3 datetime

) RETURNS TABLE AS

RETURN

(

WITH cte as

(

..

)

SELECT cols

FROM dbo.SomeTVF2(@param1, @param2)...

Olalekan Adewale (6/18/2012)

---

Table structures

DECLARE @team table (emp_code int,old_emp_code int, emp_name varchar(20))

insert into @team (emp_code,old_emp_code, emp_name)

select 1, 100,'ABA' UNION ALL

select 2, 200,'ABB' UNION ALL

select 3, 300,'ABC' UNION ALL

select 4, 400,'ABD' UNION...

Now, show us what you have done in an...

john.walker 46407 (6/18/2012)

---

Thank you, but this was user error. I was actually using a similarly named column with similar values giving what looks like the figures I want just marginally...

I'd be curious what is actually in the two columns. When I setup two variables as floats and enter the values you provide I get the answer you are...

Okay, so what is the question/problem?