Assuming that, the column JoinDateQuery will only have two values i.e. "(select hiredate from employeeInfo)" or "(select getdate)" then you can define a bit column HasHireDate instead of JoinDateQuery,...

Check, for what reason the step 1 (AddRecord) of the job is...

MAXRECURSION will not only restrict the recursion but also raises an error when it exceeds the specified value or the default value. You can overcome this by adding a...

Maverick (10/25/2007)

---

I'm not sure but I read this somewhere here only on this site

"The Full Text Search service is also known as Microsoft Search if you're looking for it under...

Nisha,

I think you should think of implementing full-text indexing capabilities.

I've been in this situation a few months ago, whereby i need to calculate the time difference between the entry and exit times....:hehe:

I resolved the problem by just adding column...

You can use EXECUTE SQL Task and inside it you can have global input/output variables...

SELECT ? = COUNT(*) FROM Table1 WHERE DateSubmission IN (SELECT DISTINCT DateSubmission FROM Table2)

WHERE the value...

Use ROW_NUMBER()....

SELECT*

FROM(

SELECTROW_NUMBER() OVER( PARTITION BY AffiliateID ORDER BY AffiliateID, insertDate DESC ) AS RowNum,

Comments, AffiliateID

FROMtblAffiliatePaymentComments

) ao

WHERERowNum = 1

Yes you can...

select XMLColumn1, XMLColumn2

from XMLTable

FOR XML AUTO, ELEMENTS, XMLSCHEMA ('Product')

Its not a good idea to have an index on a varchar(255) column specially when the table contains 700k records, instead of it you can add an identity column and...

Maverick (10/24/2007)

---

Hi All,

The full text index uses the Microsoft Search service. It is recommended that it should run under the Local System Account.

I have two questions here

1>>Does it only works...

Use sqlcmd which is new in 2005, isql, osql or bcp

You don't...

Check if you've Microsoft Internet Explorer 6.0 SP1 or later, as it is required for SQL Server Management Studio, Business Intelligence Development Studio, and the Report Designer component of Reporting...

Yes you can...

just add the column in the SELECT statement of the WITH clause..

WITH myCTE

AS

(

.....

)

SELECT RecursiveLevel FROM myCTE