I got this part.How do i concatenate both weeks and days together.

Ex: 37 5/7 or 31 /2/7 or 41 6/7

I have a days column

Ex:280 days

I would like to...

Query result:

1544

max server memory (MB)

2147483647

16

2147483647

2147483647

Maximum size of server memory (MB)

1

1

Query result:

1544

max server memory (MB)

2147483647

16

2147483647

2147483647

Maximum size of server memory (MB)

1

1

Do the appdomain errors mean issues with the server/database?

Does this error mean trouble?

Error:appdomain is marked for unload due to memory pressure.

Would giving "the sql server service account the right to prevent the operating system from paging its memory to disk" get rid of this error ?

i.e

Click Start.

2. Go to...

Min memory:0 MB

Max memory:2147483647 MB

We have 8Gb RAM on the computer

Should I decrease the max memory to 7GB ?

If i choose to do this how I do it.Do I have...

Does not work.....

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

DOes not work....

.ldf - log files

.dfb-diff backup files

.mdb - master database backup...Is .mdf used only for the backup of the master database?

.bak....Does having .bak extension means it is a full back?

How do...

no errors...the above sql does not return any data.

Thanks Jeff. Works like a charm !

appreciate your replies...working on it...will get back to you.

thanks

Col1 Col2 Col3 Col4 Col5 Col6

ted

This is what I got in the result.

I have 50000 rows in my original table

Thanks

If there are multiple delimiters in the substring ... how do I modify the query ?

Thanks

With CTE .... in sql 2000 gives me a syntax error...any other way of doing this ?

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the keyword...