Lynn Pettis (3/16/2009)

---

Need for that I had not. Previous employer has offices world wide, in Sydney one was located. Spoke of Tuesday morning you did and Monday afternoon...

[font="Verdana"]Clicked on profile you have, yes?[/font]

[font="Verdana"]Thank you Jeff! You cheered up my doleful Tuesday morning. :w00t:[/font]

[font="Verdana"]Here's some example code.

Note that I have assumed that there is always a space between the "V#" and the actual vendor number. I've also assumed that vendor numbers are...

[font="Verdana"]Bob,

That would be ideal. No idea if they have that option though.

Another option would be to cast it to some form of XML. No idea if that would...

[font="Verdana"]You might be better off writing something in C# or VB, and linking it in as an assembly. That way you can use the .Net regular expressions.[/font]

foxjazz (3/14/2009)

---

And without someone speaking up about the issues, nothing will get done. You all that use t-sql and don't code probably never know any difference. I know my dba...

[font="Verdana"]The definitions are in SQL Server Books Online, which is why you have been given the links to that. You can download SQL Server Books Online from Microsoft if...

[font="Verdana"]I always remember that an interview cuts both ways. Sometimes in an interview, when you are asked a question, it's more about thinking... "if this is an organisation...

[font="Verdana"]Reading over what you were proposing, I'm not sure it actually would add any value to load the XML into SQL Server. Processing it with your application is probably...

[font="Verdana"]Aha! So you're actually another instance of Kimberly Tripp! 😛

Reminds me about a (pascal) joke from a question asked of Niklaus Wirth. The question was "Does it...

[font="Verdana"]Congratulations Kimberly (or was it Kalen?) 😛 Well deserved![/font]

[font="Verdana"]Look up system_user in books online.[/font]

[font="Verdana"]You should be able to bulk insert the header file into an XML column, and read it out from there. The second part just use normal bulk insert.[/font]

[font="Verdana"]I recommend using a Calendar table. You can encode the week start and week end in there. That's particularly good if your week starts on a "different from...