Search results for query: *

Here is the scenario that I have. I have a table "UpdateTest" (DDL at the end) that contains a few records. UpdateID Data ------------------- 1 One 2 Two 3 Three In another table "UpdateDelta" (DDL at the end), there are several records...

I'm trying to remove an ASCII character from a flat file. I have the flat file source task pulling the file and when I look at the data, it seems that there is either a carriange return or line feed at the beginning of one of the fields. Can I use the Derived Column task to remove it and...

I'm new to .NET and only have VB experience.. I need assistance in a situation that I'm in and any help is greatly appreciated. Is it possible to add a new column to a .dat file at the end of each row and it contain a number that increments up by 1 for each row, basically giving the file a...

I don't know if I'm in the right forum. I'm creating dynamic HTML emails with SQL and sending it through SQL Database mail. I'm using select statement to create the HTML code and the results of the record pull from whatever table I'm querying... When I send the email, via...

I have seen a lot of posts about returning top 3 random records from the entire table but couldn't find one about random records for a specific reason. I have a table that holds information on employees and the supervisor they are assigned to. I need to find a way of getting 3 or less random...