An easy and effective way to do this is by using the quirky update. You must fully understand what it is doing, follow all the rules and test for effectiveness...

Yes, depending ont he architecture, it should be x64 or x86.

You can install SQL Server Express with advanced tools. It includes SSRS but won't have BIDS for SSIS or SSAS.

tom.w.brannon (8/14/2013)

---

I use numbers in my order by statements every day for short queries. It is faster than typing out long names and is especially nice when the column...

But you got a different way of doing things that will give...

Do you mean that you want to edit the results of a SELECT statement? That can't be done.

Right clicking the table and selecting "edit 200 rows", will change the contents...

Have you tried something like this?

Declare @Database varchar(20)

Set @Database = 'TDSTEP'

Declare @RowCount int

declare @sql as nvarchar(max)

set @sql = ' SELECT @RowCountOUT = Count(*) FROM ' + @Database

exec sp_executesql @sql, N'@RowCountOUT...

Have you tried to compare characters with the ASCII() or UNICODE() functions? You might have characters that look alike and are different for SQL Server.

Apparently all of your requirements are urgent and you haven't learned much from SQL in the last 7 months you've been around here.

Please post DDL, sample data and expected results...

Will this give you the expected output?

SELECT DATEDIFF( mm, date1, date2) - CASE WHEN DAY( date1) <= DAY( date2) THEN 0 ELSE 1 END

FROM (VALUES( '2013-08-05 00:00:00.000','2014-06-01 00:00:00.000'),

( '2013-08-01...

You could take a look at this book. It's a complete process for troubleshooting SQL Server

http://www.sqlservercentral.com/articles/books/76296/

Without more information, you could test this.

UPDATE MyTable SET

file_path = REPLACE( file_path, '/Downloads/', '/forms/')

Using dynamic code might cause problems with sql injection. You could try to use the 8K splitter [/url]to split your string.

You could end up with something like this:

SELECT *

FROM MyTable...

How do you define the order? do you have an identity value?

.Netter (8/7/2013)

---

I actually feel like an idiot! this just goes to shows I was completely shattered last night.

I'm sorry for...