Are the lines fixed length without a delimiter?

David Lester (11/20/2012)

---

I have a situation where I need to be able import a unix file into SQL. I can get the unix file to the windows environment with no...

It would be helpful if you could describe what you actually need to accomplish.

You can run the script on the link below to get database file usage details and various analysis:

Show Files Details

Total by Database and File

Total by Database and Filegroup

Total by...

Lowell (11/19/2012)

---

yes, with a linked server.

for me, domain information is very static...we don't add new people or move people into groups very often, so I usually take a "snapshot" of...

This should work also:

select

abs(sign(col1)+sign(col2)+sign(col3)+

sign(col4)+sign(col5)) as NegativeCount

sign(col1)+sign(col2)+sign(col3)+

sign(col4)+sign(col5)+5 as PositiveCount

from

MyTable

martinez.math (11/16/2012)

---

Yes the result is 24 not 25 because the DOB is Not exactly the currentdate.

but if the DOB is equal to currentdate or after the currentdate the result must...

The key to finding age is to find the birthday for the current year, and subtract 1 from the difference in years if the current date is before the birthday...

Since it only selects data greater than the start of the month and before the...

This code gives the start time for the OS, SQL Server, and SQL Server Agent, and gives the uptime days for the OS, SQL Server, and SQL Server Agent.

select

[OS Start...

Why did you remove the Type and DBFileName columns from the query?

Why did you leave out the table size query result set?

What are the results when you run the script on the link below in your database?

Script to analyze table space usage:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

If you change the format from 20121025171203 to a string in this format 20121025 17:12:03 that should load into a SQL Server datetime column OK.

DanielP (11/8/2012)

---

Yes, that is one of the options I will test in our mock environment. Also going to test adding new columns, running a crawler to update the new...

If may be faster to create a new table, load the data from the old table, rename the old table, and rename the new table.