RE: Once again subscription mail
quote: A miracle is happening Mails over mails coming in. See this as a test one !! Cheers, Frank Emails are down again... Seems to work for about 12 hours then it quits.
2003-08-12
1 reads
upgrading
RE: Need a good web hosting company
Hi Brian, forget this offering ! The company went out of business. They don't host private sites anymore, only commercial. But I found something new, and thought I tease you a little bit Take a look at http://www.internetspeicher24.de/ . I choose 'Juniorhosting'. Cheers, Frank
2003-07-31
1 reads
RE: Numbering the ResultSet - Equivalent of Rownum
quote: There is no ROWNUM (Oracle) in SQL Server. You may add addtional 'Identity' column to table as row number. Thanks, but the problem is i cannot add a column to the database. All i can do is change the queries to get an equivalent of Rownum as Rownum is not available in SQL Server.
2003-07-18
2 reads
RE: Batch processing
it's a file with huge data to be processed daily, I have around 100.000 records and I want to process like 5.000 at time how I do that?
2003-07-15
RE: Code to Format Numeric Data?
Samples DECLARE @val money SET @val = 1234567.89 SELECT CONVERT(char(15),@val,1) DECLARE @val int SET @val = 1234567 SELECT LEFT(CONVERT(char(18),CAST(@val AS money),1),15) DECLARE @val decimal(9,2) SET @val = 1234567.89 SELECT CONVERT(char(15),CAST(@val AS money),1) DECLARE @val real SET @val = 123456.78 SELECT CONVERT(char(15),CAST(@val AS money),1) Edited by - davidburrows on 06/26/2003 07:25:17 AM
2003-06-26
1 reads
RE: Code to Format Numeric Data?
Yes, you'd think there'd be a simple function, but I didn't see one either. However, you could use a DTS transformation task such as this: '******************************************** ' Visual Basic Transformation Script '******************************************** Function Main() If DTSSource("column name")<>"" THEN ' add spaces in front of number to fill field, where field is char(20): DTSDestination("column name") =space(20-len(FormatNumber(DTSSource […]
2003-06-25
RE: Code to Format Numeric Data?
Here is a copy of the wheel that I re-invented, but I'm not particularly happy with the code. Anyone have any better ideas? Thanks, Jon create function DBA_FormatNumericData ( @float float, -- An integer value that will be formatted @DesiredWidth smallint, -- The desired width of the output string @DecimalCount smallint -- Number of decimal […]
2003-06-25
1 reads
RE: Help with "CASCADE CONSTRAINTS"
If you want a trouble-free way of dropping tables.... This sp drops all column constraints and defaults on a field, then drops the field. The code is a bit messy (exec during a default cursor...) , but the SQL it's based on is sound. You should be able to mess around with this so that […]
2003-06-19
2 reads
RE: shrink logs
Here's a link to the script that I used OFTEN. http://qa.sqlservercentral.com/scripts/savescript.asp?scriptid=26 It forces the transaction log to shrink by moving the last active transaction back to the top of the transaction log.
2003-06-19
RE: A Simple Question
Hi Adiseshan, quote: Builtin/Administrator account was deleted and the admin forgoted his sa password then how to login to the system with administration rights? if there is no member of sysadmin or securityadmin available, I don't know of any way. Cheers, Frank
2003-06-18
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers