Viewing 15 posts - 1,801 through 1,815 (of 1,988 total)
Well you could use a little excel magic to concat all the data into one column then import that column.
February 13, 2015 at 2:05 pm
Well if you don't care about giving users an error... rename the table do what you need to do rename it back.... or depending on how your accounts...
February 10, 2015 at 12:12 pm
You might have some issues with that as not all countries use the same format address.
February 9, 2015 at 3:29 pm
COUNT(DISTINCT person_id)
February 6, 2015 at 2:36 pm
It sounds like you're trying to build some kind of a time card system, you could mess around with something like this. This isn't tested at all strongly for...
February 2, 2015 at 2:24 pm
Why are we getting so many count with null questions recently?
February 2, 2015 at 8:52 am
Just like most anyone in the job market, where they either want to land or where they let themselves land. If you don't like being a senior DBA/developer what...
January 30, 2015 at 8:12 am
KoldCoffee (1/27/2015)
Well yes... but that has both business impact and performance impact.
ZZ, please clarify 'performance' impact.
In general the more information you store and retrieve the slower it will be....
January 27, 2015 at 2:05 pm
KoldCoffee (1/27/2015)
But I think the only 'gain' here is that it prevents insertion of data that is way out of scope of what is expected. No other...
January 27, 2015 at 12:52 pm
KoldCoffee (1/27/2015)
But if that is the case, why is there an option to specify length...
January 27, 2015 at 11:21 am
Phil Parkin (1/23/2015)
ZZartin (1/23/2015)
On another note on the most jarring experience I had with naming conventions was using an open...
January 23, 2015 at 8:42 am
The only proper naming convention is all caps with underscore seperators.
On another note on the most jarring experience I had with naming conventions was using an open source ecommerce site...
January 23, 2015 at 8:36 am
Eh well the same way you originally saved it to the DB, it should prompt you if you want to overwrite it and you just click yes.
I think there's ways...
January 22, 2015 at 5:06 pm
Just save the job back to MSDB after making your changes. Making changes in BIDS and saving it locally won't update the scheduled job.
January 22, 2015 at 4:06 pm
Then that error is because whatever value is being set in that global can't be converted to a number.
Looking at the script it looks like all he's doing is converting...
January 16, 2015 at 10:24 am
Viewing 15 posts - 1,801 through 1,815 (of 1,988 total)