Appears to be a duplicate posting... refer to:

http://www.sqlservercentral.com/Forums/Topic926416-338-1.aspx

ashiqkhan98

You are more likely to receive tested assistance if you post your table definition, provide some sample data (this may be fabricated data, so as not to reveal company confidential...

John Bates-251278

Your welcome and thanks for the feed back.

Try this:

SELECT LEFT(RTRIM(@@servername),10)

RTRIM to remove any trailing blanks

LEFT (in this case 10 characters) - counting from left to right.

1st of all I had to correct your table definition:

create table #courses

(course varchar(100),

count int,

specification varchar(100),

author varchar(100))

Then correct your input statements:

insert into #courses

values('digital',3,'msse','james')

insert into #courses

values('AI',6,'msse','hacks')

insert into #courses

values('digital',5,'mdsa','kali')

insert into #courses

values('signal',8,'mdfe','jorge')

insert into...

You might want to look at using a CTE such as:

;with numbered as(SELECT rowno=row_number() over

(Partition by COL1, COL2,COL3 order by COL1),COL1,COL2, COL3,COL4 FROM #TableX)

SELECT COL1, COL2,...

If you do not have a listing of the ASCII character sets go to:

http://msdn.microsoft.com/en-us/library/4z4t9ed1.aspx

with these you can compose a T-SQL statement using either the CHAR and/or ASCI functions to test...

Anbody here want to help this OP, moving from MSDE to Window 7 platform.

http://www.sqlservercentral.com/Forums/FindPost923611.aspx

be much appreciated

Why are you concerned about the [] this works:

DECLARE @CLAIM table(

[CLAIMNO] [varchar](20) NOT NULL,

[ACCT] [varchar](4) NOT NULL)

INSERT INTO @CLAIM

SELECT 1, 'Did' UNION ALL

SELECT 2, 'Doit'

SELECT * FROM @CLAIM

/* Results:

CLAIMNOACCT

1Did

2Doit

*/

I would suggest as your first step you download the SQL 2008 Upgrade Advisor from:

http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

Now the tool is not the "be all" advisor, but it will get you started on...

Excellent question ... really got the brains cells working.

Sorry miss-read your question ...

Assuming the "application" is NOT Excel have the user attempt to open the sheet using Excel .... he mostly likely will receive an error message saying the the sheet is...

DECLARE @date DATETIME, @int INTEGER

SET @date = GETDATE()

SET @int = 6

SELECT DATEADD(MONTH, -1*@int, @date) AS past,

@date,

DATEADD(MONTH,...

To get started with your T-SQL code go to:

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

This will give you code samples to do just about anything with date/time values.

Then if have additional questions come on back ....