RE: Retriving host IP Address via T-SQL
Thanks! There is more than one way to skin that cat. However, native T-SQL support for this is on my personal wishlist.
2004-12-09
ssas
DTS Data Pump Using Stored Proc with parms
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-22
SQL Statement Help
I got the following data in a tableCol1 Col2 HHHH TTTTT HHHH RRRRR HHHH SSSSS AAAA FFFFF BBBB GGGGG CCCC HHHHH DDDD IIIIII want the follwing result setTTTTT RRRRR SSSSS AAAA BBBB CCCC DDDDMeans where ever i see HHHH in Col1 i have to select Col2, Can you help on this.Thanks in Advance
2004-11-17
RE: Backing up a DTS package
In DTS Designer, when you select Package -> Save, you can choose a location of SQL Server, structured storage file, or VB file. If you choose to save in SQL Server, the package is saved in the msdb database. If you choose structured storage file, you'll be prompted to choose a directory to save to.So, […]
2004-11-12
RE: Moving DTS
The DTS Backup package works well, There is a switch on one of the panels to retain formatting.Don't forget to check it, even so a few will need to be laid out again. Although they work fine.
2004-11-09
Dynamically set DTSDestination column name from variable
I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
RE: SQL query listener?
Really I would just use SQL Profiler. You'll find it under the Tools menu in SQL Enterprise Manager. It hooks into SQL Server and collects all the actions that are sent to it. You can select how much data you want to record, and even what types of events (from just the sql statements executed, […]
2004-08-06
DTS VS Linked Server
Hello, I have a question regarding DTS and Linked server speed and usability. I have about 400,000 rows to transfer on a daily basis between two servers. I can set up a DTS Package to do it, or I can run a job doing the same using linked servers. Which one is the best or […]
2004-07-14
66 reads
RE: convert char to datetime
declare @mydt varchar(10) set @mydt = '10/10/2003' declare @newdt datetime set @newdt = Convert(datetime, @mydt) SELECT CONVERT(varchar(25),getdate(),2) SELECT CONVERT(varchar(30),@newdt,109) SELECT CONVERT(datetime,@mydt) SELECT CONVERT(datetime,'10/10/2003',103) SELECT CONVERT(datetime,@mydt,103) SELECT CAST(CONVERT(char(10), getdate(), 112) as datetime)Test the code above and you'll see that the last 3 select statements (which roughly correspond to the previous replies in this thread) all produce […]
2004-07-14
18 reads
RE: Delete from Where - Older than 60 days...
If you don't have to worry about the time when the statement is ran (if this is run at 11:20am, it will delete everything older than 60 days ago at 11:20am) you can use:delete from TABLE where DATEFIELD < getdate() - 60However, if you want to delete everything before the start of the day (60 days […]
2004-07-09
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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