meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | 11 hours ago | |
| stats | profile views | 9 |
|
2d |
awarded | Constituent |
|
May 17 |
awarded | Yearling |
|
May 16 |
comment |
Fixed length text file insert into SQL table Not having experience with FORMAT FILE, I've looked into it briefly, but I haven't seen an example that addresses files like the example, where the header has one set of columns, the data rows another, and the footers another. Can you suggest a source for info? |
|
May 16 |
comment |
Fixed length text file insert into SQL table In my very limited experience, SQL isn't as bad at string manipulation as everyone says--this is how I'd try it if SSIS vaporized itself, and if the performance wasn't acceptable, I'd try something else. |
|
May 15 |
awarded | Informed |
|
May 15 |
answered | Fixed length text file insert into SQL table |
|
May 13 |
awarded | Caucus |
|
May 9 |
revised |
How can I reliably track stored procedure ( and functions ) use over time? Primarily addition of code block; minor code formatting for readability |
|
May 9 |
suggested | suggested edit on How can I reliably track stored procedure ( and functions ) use over time? |
|
May 6 |
comment |
pros/cons of different ways to store whether a record is one of two options? I can't vouch for best practice, but I'd go with option 3. You can make it a bit if you're sure you only need the two options, and changing it to an int later (if your prognosticator is faulty) would probably be significantly easier than fixing one of the other options. Probably not a bad idea to still build the corresponding AddressType table for a reference, even if you don't code to use it. |
|
May 3 |
revised |
Can I use Try_Cast to give me a query result column with different datatypes? added 170 characters in body |
|
May 3 |
answered | Can I use Try_Cast to give me a query result column with different datatypes? |
|
May 2 |
answered | Trying to write a function that doesn't require dbo. prefix |
|
Oct 8 |
answered | To use or not use ISNULL(NULLIF(Field1, ''))? |
|
Oct 8 |
awarded | Critic |
|
Oct 4 |
revised |
Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? added 258 characters in body |
|
Oct 4 |
awarded | Editor |
|
Oct 4 |
revised |
Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? added 228 characters in body |
|
Oct 4 |
answered | Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups? |
|
Oct 4 |
awarded | Teacher |
