Viewing 15 posts - 2,491 through 2,505 (of 3,221 total)
Try this. (using the temp table as proposed by arun.sas) for this test
;with numbered as(SELECT rowno=row_number() over(partition by reg_no,leave,typeid order by reg_no),
reg_no,ID,leave,typeid,allowed,remarks from #temp1)
Then use the following to verify...
July 31, 2009 at 1:10 pm
From Books On Line (The SQL help file)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/09a6e0c2-d8fd-453f-9aac-4ff24a97dc1f.htm This portion of BOL is a lot of reading, but well worth it!!
Full backup
A full backup contains all the data in a...
July 29, 2009 at 11:04 am
Getting back to unusual license plates
The best vanity plate I've heard about is CASH on a Rolls Royce.
.
Observed a Silver Cloud Rolls Royce moving down the road with...
July 27, 2009 at 11:30 am
Is your developer of the VB6 application testing for returned errors in the existing code?
From the Help file for VB6 and ADO
Any operation involving ADO objects can generate one or...
July 21, 2009 at 8:09 am
Use Books On Line (The SQL Server help file) Read the following
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a7b1b9b0-7c19-4acc-9de3-3a7c5e70694d.htm
July 17, 2009 at 7:47 am
For a meaningful reply / suggestions please post the information outlined in my signature block, that is a create table statement, some sample data, etc...
Congratulations on running your statement on...
July 16, 2009 at 10:46 am
cos_ta393
I have found this to be an excellent source for importing data from Excel, hopefully it will have enough information to assist yourself.
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
Another good read is:
http://www.mssqltips.com/tip.asp?tip=1202
Both sites contain sample code....
July 15, 2009 at 7:34 pm
What EXCEL revision are you using pre 2007 or 2007? Note that 2007 uses a different driver.
This forum may have what you need if you are using 2007
http://www.sqlservercentral.com/Forums/Topic477652-148-1.aspx
July 15, 2009 at 1:22 pm
But again, you cannot load SQL Server SSMS 2008 unless you are licensed to use 2008 version of SQL
Mischa E.J. Hoogendoorn - You can purchase the DEVELOPER edition of SQL...
July 15, 2009 at 9:24 am
hakan.winther
In answer to your question:
BOL link
http://msdn.microsoft.com/en-us/library/ms189858(SQL.90).aspx
Which recommends:
avg_fragmentation_in_percent value Corrective statement
> 5% and 30% ...
July 13, 2009 at 5:17 pm
Have you considered using the CHARINDEX function: For example:
SELECT CHARINDEX('T:','[\\Servername\PhysicalDisk(7 T:)\Disk Reads/sec]' which will return the value 30.
and
SELECT CHARINDEX('T:','[\\Servername\PhysicalDisk(7 L:)\Disk Reads/sec]') returns a value of 0.
Based on the above...
July 13, 2009 at 5:08 pm
Read this forum post -- it contains the necessary VB6 code that you are requesing
http://www.sqlservercentral.com/Forums/Topic747115-1291-1.aspx#bm747122
July 13, 2009 at 4:56 pm
An extract from the question as published
jpowers
Using Microsoft's BOL recommended guidelines to remedy this fragmentation
- emphasis added for this post.
Please note that the question specifically cited...
July 13, 2009 at 1:01 pm
Christian Buettner
If it was intended to be tricky, then I admit it was well done
The question was not intended to be tricky, but to draw attention to an easily overlooked...
July 13, 2009 at 8:25 am
kopajb
Being a developer rather than a true DBA. Sort of inherited the job when my employer did not see the need to increase staffing. So I fumble...
July 12, 2009 at 4:01 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,221 total)