Viewing 15 posts - 1,276 through 1,290 (of 1,417 total)
smunson (10/23/2008)
...the meaning of the value in the UNITS field has changed...
Hi Steve,
Thanks for pointing that out. But I created this sample to only simulate my data. The UNITS value...
October 23, 2008 at 11:35 pm
Hi Anzio,
I have work out your solution. Maybe others can benefit from this code.
As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...
October 23, 2008 at 6:05 am
AnzioBake (10/23/2008)
It seems I can not post code to the site, I wanted to post a more generic solution
Hi Anzio,
Allthough the provided solution fits my current needs, I'm interested in...
October 23, 2008 at 4:21 am
Thanks Mark, it works like a charm.
I knew a TALLY table could bring me the solution 😀
October 22, 2008 at 4:09 am
What about this approach...
- create and (re-)fill a table with your data using the scheduled job
- link the Excel-sheet with the correct template to the table
- (automatically) refresh the data...
October 21, 2008 at 3:03 am
Install the SQL-2005 Workstation components and be sure to include the Management Tools. SQL Profiler is part of this.
October 21, 2008 at 2:46 am
To correctly let SQL 'know' and display the changed servername you have to run the following code to update the system metadata (sys.servers and @@ServerName):
sp_dropserver {old_name}
GO
sp_addserver {new_name}, local
GO
See the article...
October 14, 2008 at 6:15 am
I agree with Barry. Just create a trace, to only select the textdata of statements (SP and T-SQL). Filter this on the databasename and "%TabelName% %ColumnName%" and you only get...
October 14, 2008 at 2:21 am
Yes, you can change the name of a server running SQL Server. I did it last month regularly when setting up a new development environment. Every time without any issue....
October 14, 2008 at 2:14 am
by reading the error message it looks like the "SQL Agent" service is not running. If it is running, then probably the account used for the SQL Agent has not...
October 14, 2008 at 1:12 am
You forgot to add the time to the filename. The CONVERT(VarChar(20),GetDate(),112) give you a date in notation in format yyyymmdd. You have to add the time to this part to...
October 14, 2008 at 12:57 am
From BOL (under ALTER DATABASE):
Moving a file to a new location
The following example moves the Test1dat2 file to a new directory.
Note:
You must physically move the file to...
October 13, 2008 at 11:48 am
IIF is a function available in Microsoft Access database and not in a SQL database. You have to use CASE instead.
Sample from BOL:
SELECT ShipVia, CASE ShipVia
...
October 13, 2008 at 6:48 am
For my knowledge it is possible for Database Mail to recieve e-mail. You have to re-route the mail address from Database Mail to your own.
October 13, 2008 at 6:38 am
Are all logins you see with sp_who2 your own? If not, other users are accessing the database. Kill those connections and try again.
October 13, 2008 at 6:24 am
Viewing 15 posts - 1,276 through 1,290 (of 1,417 total)