Viewing 15 posts - 1,171 through 1,185 (of 2,010 total)
Yeah I'm aware of their product and have brought it up a few times for address validation and such rather than trying to maintain our own homebrew system, but when...
January 22, 2009 at 1:36 pm
OK so this is all in one big table with a mess of individual text boxes right?
The error you are getting is because you can't add a list to a...
January 22, 2009 at 12:06 pm
You need to use something other than just a plain text box, which is what I'm guessing you're using so far...
You need to use either a list, or possibly a...
January 22, 2009 at 11:19 am
I was out on the zip-codes.com site and was looking at their demo files. In the business version on of the new fields is Multiple County Data in the...
January 22, 2009 at 11:02 am
Is this something you are actually doing with Reporting Services or is this some other type of front end? It looks like you are not providing any space/fields etc,...
January 22, 2009 at 10:55 am
Not sure why you're looping through the data... if you could be more clear on what you are doing perhaps we may be of a bit more help...
What I'd do...
January 22, 2009 at 9:26 am
So Using sp_SpaceUsed in a SQL Agent job won't work?
If you want to see it over time, then you'll have to log it to something, I'd suggest a table in...
January 22, 2009 at 8:06 am
A lot of it depends what you want to do with the data... You could use sp_spaceused inside of a SQL agent job and write it to a table, log...
January 22, 2009 at 7:15 am
I'm sure there are registry entries you could check, but for a quick dirty look at your environment as a whole you could look into SQL Ping http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx.
-Luke.
January 22, 2009 at 7:06 am
Ya know, I'd say that "I'd never join you" in my whiniest text possible, however who knows what the future will bring...
And I've been wondering for weeks why we have...
January 21, 2009 at 3:23 pm
Format by SQL Prompt I do, but what can I say I used to like being able to post in color... makes it much easier to read while answering posts...
-Luke.
January 21, 2009 at 1:58 pm
Yeah, I used to run all my posts through a SQL formatter, but My HIPS software doesn't like any of the online ones anymore (keeps thinking I'm trying to run...
January 21, 2009 at 1:52 pm
One of these days I'll learn to recheck the original post before I post the same answer that's already been suggested a minute or two ago...
-Luke.
January 21, 2009 at 1:43 pm
Depending on your indexes and such this could be rather a bit on the long side but why not something like the following???
SELECT Parent.*
FROM Parent Left Join Child ON...
January 21, 2009 at 1:42 pm
Jeff Moden (1/16/2009)
Luke L (1/16/2009)
...to put into a flat file full of repeating groups to send to another organization.
Heh.. that's what you did... my question would be, why did they...
January 18, 2009 at 7:20 am
Viewing 15 posts - 1,171 through 1,185 (of 2,010 total)