Viewing 15 posts - 1,921 through 1,935 (of 3,221 total)
Appears to be a duplicate posting... refer to:
http://www.sqlservercentral.com/Forums/Topic926416-338-1.aspx
May 22, 2010 at 11:26 am
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...
May 22, 2010 at 11:20 am
John Bates-251278
Your welcome and thanks for the feed back.
May 22, 2010 at 10:21 am
Try this:
SELECT LEFT(RTRIM(@@servername),10)
RTRIM to remove any trailing blanks
LEFT (in this case 10 characters) - counting from left to right.
May 21, 2010 at 4:01 pm
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...
May 21, 2010 at 12:30 pm
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,...
May 19, 2010 at 9:36 am
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...
May 18, 2010 at 2:08 pm
Anbody here want to help this OP, moving from MSDE to Window 7 platform.
http://www.sqlservercentral.com/Forums/FindPost923611.aspx
be much appreciated
May 18, 2010 at 11:54 am
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
*/
May 18, 2010 at 8:18 am
I would suggest as your first step you download the SQL 2008 Upgrade Advisor from:
Now the tool is not the "be all" advisor, but it will get you started on...
May 18, 2010 at 7:58 am
Excellent question ... really got the brains cells working.
May 13, 2010 at 4:55 am
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...
May 12, 2010 at 2:49 pm
Nomvula
i need to calculate schedules that were done in the past 6 months
DECLARE @date DATETIME, @int INTEGER
SET @date = GETDATE()
SET @int = 6
SELECT DATEADD(MONTH, -1*@int, @date) AS past,
@date,
DATEADD(MONTH,...
May 12, 2010 at 12:06 pm
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 ....
May 12, 2010 at 11:21 am
Viewing 15 posts - 1,921 through 1,935 (of 3,221 total)