See this article: http://msdn.microsoft.com/en-us/library/ms191485.aspx

You should use backslash n to indicate a linefeed row terminator

If I understand the requirements correctly, each file can have a different set of columns.

In that case the main challenge is to create a new table for each file with...

What application is the user trying to connect with ?

Is the user trying to use windows authentication or SQL authentication ?

Is the user's computer a member of the same domain...

yes, but as I said before, a good index is more important.

It is not so easy to return the queries that return a large result set, but it is very easy to return the queries that take the longest to execute.

You...

Well, as usual it depends. 😉

The best way to speed up your query would be to create a clustered index on DATA_ABC with date_id as the first column.

This would mean...

To get maximum performance you want a merge join between a and b and you want an index on a so you can use a stream aggregation for the group...

Try something like this:

select

touserid, fromuserid,

stuff((

...

This will pad the varchar column v in table t to 30 characters:

update t

set v = v+space(30-len(v))

where len(v) < 30

Exactly what are you trying to do ?

Are you trying to convert from a string to a date, or from a date to a string ?

Is the conversion done inside...

OK, now I think I understand what you want.

Try this:

select

userid,

substring((

select ' : ' + cast(memo as varchar(max)) + ' , ' + cast(memodate as varchar(max))

from Notes n2

where n2.userid...

But what should happen if the table contains more than one UserID ?

As I said before: Give us an example of what your data looks like...

_taz_ (6/16/2010)

---

Kingston Dhasian (6/16/2010)

---

Try this one

DECLARE @Notes varchar(MAX)

-- Here you are assigning a value to a variable

SELECT @Notes = COALESCE(@Notes + ':', '') +

...

Hadrian (6/15/2010)

---

Table 'Item'. Scan count 1, logical reads 1015, physical reads 0, read-ahead reads 0, lob logical reads 371361, lob physical reads 0, lob read-ahead reads 108129.

SQL Server Execution Times:

...