Recent content by NewbieWithSQL

So you are bypassing the first update record for ID 1. I can't bypass any records.

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 what else would be needed, since everyone mail profiles are different Here is some simple code, that I have used to test after seeing the issue. declare @Test varchar(2000) set @Test = replicate('0123456789', 103) exec msdb.dbo.sp_send_dbmail @profile_name = 'Default' ...

Don't think so... It still sends the email even if longer than 1024 characters, it just drops that whatever data is in that spot and then continues with the rest of the message.

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...

Thanks markros. Exactly what I need.

SQL 2008

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...