Use the STUFF function to format it into a string that can be converted into a date using the normal convert function. Once it's a real date datetype, you...

Several possible ways to prevent the log filling:

Insert the records in batches and take log backups between the batches.

Switch the DB to 'Simple' recovery mode, insert in batches, switch back...

Why wouldn't you see number 7? It's mark matches another id with the same mark and a different islabel. Can you only use the matching combination once and...

OLEDB waittype indicates it's waiting for something outside the SQL Server. How are you executing the scipt? Through an OLEDB connection in SSIS?

http://www.confio.com/logicalread/sql-server-oledb-wait-type/

Thanks Daman,

We ended up using DBAmp and had a successful project roll-out in 2011.

Data Definition Language (CREATE statements for the tables and indexes you are using).

I'd pick this up

http://www.amazon.com/The-Microsoft-Data-Warehouse-Toolkit/dp/0470640383

as a good way to make sure you had a good grasp of the concepts and techniques in a very popular ETL and warehousing methodology.

I'm afraid you're asking for code that would make these two:

21ST CENTURY SERIVES

21ST CENTURY SERVICES

equal, not because they are, but because they SHOULD be. Is that true? The...

Never heard that one, but might be: Select Create Update Delete. These kids today and their modern slang.

You might want to look here:

http://en.wikipedia.org/wiki/Julian_day

I don't have any scripts to convert this, but Google might be your friend here...

The other possibility is that the error message is correct and the report server got a connection to the sql server but somehow didn't put the connection in the correct...

That's where I went too and realized I couldn't solve that. Happy New Year to you too!

Not really extracting, but as long as the year numbers can't appear in any other part of the string and the number of years is finite...

create table #stuff (

badstrings varchar(255)...

Sorry, but aren't these 2:

1 group can have only one group member

1 group can be joined by many members

mutually exclusive? Are 'members' and 'group members' different things? If...

Lowell,

Querying AD directly has always given me a problem when extracting things that have multiple occurrances (like OU or group membership). Is there a way to get those types...