Can you post some sample data?

DECLARE @Employee Table

(code VARCHAR(50),name VARCHAR(50))

INSERT INTO @Employee

SELECT '001','A' UNION ALL

SELECT '002','B' UNION ALL

SELECT '003','C'

DECLARE @Position Table

(JobCode VARCHAR(50),JobTitle VARCHAR(50),EmployeeCode VARCHAR(50),

FromDate DATETIME

)

INSERT INTO @Position

SELECT 'MRE','abc','001','2011/09/09' UNION ALL

SELECT 'MRO','abcd','001','2011/10/10'UNION ALL

SELECT 'CEO','xy','002','2012/01/01' UNION...

Please explain it little bit more.

DECLARE @TableO TABLE

(UserName VARCHAR(100),[DateTime] DATETIME,[Action] VARCHAR(50))

INSERT INTO @TableO

SELECT 'abc','2011-01-22 23:45','xyz' UNION ALL

SELECT 'abc','2011-01-23 10:00','pqr' UNION ALL

SELECT 'abc','2011-01-24 10:00','pqr' UNION ALL

SELECT 'dtr','2011-01-24 10:00','pqr' UNION ALL

SELECT 'abc','2011-01-25 10:00','pqr' UNION ALL

SELECT 'abc','2011-01-26 10:00','pqr'...

If it is fixed pattern it should work for you.

DECLARE @Str VARCHAR(100)

SET @Str = '12345 0047225P1'

SELECT SUBSTRING(@Str,CHARINDEX(' ',@Str)+1,7) AS ID,

SUBSTRING(@Str,CHARINDEX(' ',@Str)+8,1) AS 'Account No'

You can try this:

;WITH CTE AS

(

SELECT Number,Type,Name,ROW_NUMBER() OVER(PARTITION BY Type ORDER BY Type) As 'Pos' FROM RelationshipTable

)

SELECT Number,Type,Name FROM CTE

WHERE

Pos = 1

Hi,

You can change your Where condition.

SELECT *

FROM midyearexample

WHERE

startdate < '1985-07-15' AND (enddate > '1985-07-15' OR enddate IS Null)

Check this one.

ALTER FUNCTION dbo.RemoveNonNumericCharacters (@Temp VARCHAR(1000))

RETURNS VARCHAR(1000)

AS

BEGIN

While PatIndex('%[^0-9,.]%', @Temp) > 0

Set @Temp = Stuff(@Temp, PatIndex('%[^0-9,.]%', @Temp), 1,...

Hi,

Try to write your T-SQL as below.

DECLARE @TABLE1 NVARCHAR(30)

DECLARE @TABLE2 NVARCHAR(30)

DECLARE @sql NVARCHAR(1000)

SET @TABLE1 = 'dbo.City'

SET @TABLE2 = 'dbo.Marks'

SET @sql = N'SELECT * FROM '+@TABLE1+';'+'SELECT * FROM...

Hi,

Check this post.

http://www.sql-server-helper.com/error-messages/msg-117.aspx

Hi,

You can try this one.

DECLARE @test-2 TABLE

(A INT,B INT,C INT)

INSERT INTO @test-2

SELECT 10,1,1

UNION ALL

SELECT 10,1,2

UNION ALL

SELECT 10,2,1

UNION ALL

SELECT 10,2,2

UNION ALL

SELECT 10,3,1

UNION ALL

SELECT 10,3,2

UNION ALL

SELECT 11,1,1

UNION ALL

SELECT 11,1,2

UNION ALL

SELECT 11,2,1

UNION...

Hi,

Try this T-SQL.

DECLARE @ID1 VARCHAR(7)

DECLARE @ID2 VARCHAR(7)

SET @ID1 = '1234'

SET @ID2 = '76541'

SELECT RIGHT('0000000'+@ID1,7)+RIGHT('0000000'+@ID2,7)

Hi,

You can use Substring function here.

In which field you are storing date ?

Make it clear i will try to write query.

Check this link.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30071

nhimabindhu (9/21/2011)

How to find the file name in the folder if it exists or not.Daily text file is coming in the format ex:21-09-2011 i...