SSMS -> Options -> Query Results -> SQL Server -> Results to Text -> Maximum Number of Characters displayed in each column

Does that help?

Since the data your are loading is going to be scrubbed, don't try to match the source and destination sizes. In your destination table feel free to make it double...

Sounds, off the top of my head as if you need to normalize your table more. Create a table to hold the car models with key that you can reference...

Something like this maybe?

declare @error_message varchar(30)

set @error_message = 'invalid url'

update yourtable set url =

(case

when ID = 1 then

case when @url1 is not null

case when left(@url1,8) = 'https://' then...

Sure you could do it that way. Open your excel and have it pull down the table into a worksheet and then have that worksheep mapped to a file table...

If you're not searching the text column itself why not simply select the primary key column from your query into a temp table and inner join it to your original...

You ran into the same issue I did, Eugene. User ms>2000 rather than seconds to meet his criteria but many thanks. I just could NOT figure out hot to set-base...

It's hideous and I hate it but it does what you want.

if Object_id('tempdb..#TEMP') is not null

DROP TABLE #temp

set nocount on

set dateformat dmy

CREATE TABLE #TEMP (LogIndex int, UserID nvarchar (10), LogTime...

it's due to the milliseconds.. let me take another look. I also overlooked that you were grouping by user so the criteria changes per user.

Le Sigh.. for the life of me I cannot figure out how to do this in a set-based statement so slap me now.

The following code will do what you want.

if...

Another solution could be, depending on the design of the report, to put it in Excel and have a linked datasource that updates on open so that every time someone...

The requirements shown by your last post are different from the requirements from your first post.

In your first post you state you want only the records that are equal or...

Is there some reason no one has suggested a 'on delete cascade' foreign key solution? Am I missing something about this situation? It seems to me you could put a...

If you change the select statement to this:

select t.taxonomyname + ' ; ' from #taxonomy t

left join #taxonomy tt

on t.parentid = tt.id

order by t.id desc

for xml path('')

you'll get the...

What about using ODBC and creating a linked table in Access so you have constant and immediate access to the data for the report?