Viewing 15 posts - 2,371 through 2,385 (of 3,221 total)
Charles Kincaid - let me take you further back onto memory lane, we replaced the 709 with a 1401... Remember when coding was not accomplished with a word processor, or...
October 18, 2009 at 11:25 am
If you need to ignore the suggestions of Bob Hovious and Jeff Moden look at this code and decide what you want to do.
CREATE TABLE #Demo(Col1 VARCHAR(9),Col2 VARCHAR(9))
DECLARE @Blanks VARCHAR(9)
DECLARE...
October 18, 2009 at 8:17 am
A rather simple article, but the suggestion to pick out a few key users sounds as the way to go... you show one or two of them, and they in...
October 17, 2009 at 4:53 pm
Took a while before I got up enough courage to post to this forum but here goes.
Started in '50s - college degree in Mechanical Engineering - when engineering was the...
October 17, 2009 at 3:47 pm
This might give you an idea, as it is, it is rather crude
DECLARE @CEFDT DATETIME
SET DATEFORMAT ymd
SET @CEFDT = '20091017'
DECLARE @It VARCHAR(15)
DECLARE @is VARCHAR(2)
SET @It = (SELECT DATEPART(yy , @CEFDT))...
October 17, 2009 at 2:26 pm
Darn GSquared types too fast for me to keep ahead of him. OH well for what it is worth here is my adaptation of GSquared's recommendations.
Without the table definitions here...
October 16, 2009 at 3:10 pm
Tara-1044200
To receive some help please help us to help you. Read both the articles in my signature block and post the requested information. Other wise the only answer...
October 16, 2009 at 11:59 am
sihaab
Switch to using GOOGLE mail for e-mails from SSC read this:
http://www.seroundtable.com/archives/000784.html
and then:
http://toolbar.google.com/gmail-helper/notifier_windows.html
It will cause a small window to open up just above your tool bar and displays for...
October 15, 2009 at 3:52 pm
olsentimothy03
So just pretty much the same thing
No not at all close to the same thing. Using a group by with the HAVING clause
SELECT lngCompanyID,shtCompanyID,dtmModified, COUNT(*) AS...
October 15, 2009 at 3:33 pm
Try this:
;with numbered as(SELECT rowno=row_number() over
(partition by lngCompanyID,shtCompanyID,dtmModified order by lngCompanyID)
, lngCompanyID,shtCompanyID,dtmModified,strAddress from #tDupData)
select * from numbered
Resulting in:
rownolngCompanyIDshtCompanyIDdtmModified strAddress
11 ...
October 15, 2009 at 12:19 pm
Be aware of some gotchas when using SET IDENTITY_INSERT ON. For example:
CREATE TABLE #Tident(ID INT IDENTITY,Col1 VARCHAR(5))
INSERT INTO #Tident
SELECT 'A' --repeated for a total of 7 rows
This...
October 15, 2009 at 11:32 am
You may have other syntax errors but from Books On Line.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/01de7476-4b25-4d58-85b7-1118fe64aa80.htm
The names of users that are mapped to SQL Server logins, certificates, or asymmetric keys cannot contain the backslash character...
October 15, 2009 at 7:31 am
Not knowling exactly how your T-SQL statement are composed you might think of creating a function based on either East Coast time minus some hours or Greenwhich mean time minus...
October 14, 2009 at 4:33 pm
This works for me:
SELECT * INTO Dbo.ICSV
FROM
OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};
DEFAULTDIR=F:\Testdata\;',
'SELECT * FROM CSVFile.csv')
SELECT * FROM dbo.ICSV
As far as I can tell all I did to your code that was...
October 14, 2009 at 12:20 pm
If you have not read this article by Gail Shaw, I suggest you do so.
http://www.sqlservercentral.com/articles/64582/
and by Paul Randal
Randal's blog post also contains links to several additional articles in Technet magizing...
October 14, 2009 at 8:10 am
Viewing 15 posts - 2,371 through 2,385 (of 3,221 total)