Viewing 15 posts - 4,156 through 4,170 (of 7,164 total)
Jeff Moden (5/8/2012)
opc.three (5/8/2012)
jasonmorris (5/8/2012)
Where I work they always insist that any import tables for third party text data are nvarchar(4000)...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 8, 2012 at 9:07 am
jasonmorris (5/8/2012)
Where I work they always insist that any import tables for third party text data are nvarchar(4000) and there is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 8, 2012 at 8:59 am
Try left joining from a Tally table to your data on export to fill the gaps.
Here is a derived Tally table you could use:
-- From: http://www.sqlservercentral.com/articles/Tally+Table/72993/
WITH E1(N) AS (
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 8, 2012 at 8:35 am
lil_emery13 (5/7/2012)
I am using MySQL through phpMyAdmin. Sorry for not clarifying.
No problem. This website is devoted to Microsoft SQL Server. While current versions of MySQL support User-defined Functions the SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 4:44 pm
Do they need access to other databases or resources on the instance? If the answer is no just disable their logins.
If the answer is yes then it gets a bit...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 2:55 pm
My test started with an empty table.
IF EXISTS ( SELECT *
FROM sys.objects
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 2:45 pm
I have never seen such a thing in the wild...I was wondering if inserts might even be blocked so ran a quick test...they work. I also ran an execution plan...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 2:00 pm
Nice! Happy to assist...I bet that felt good 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:43 pm
polkadot (5/6/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:32 pm
You're welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:21 pm
If you spell it incorrectly the CREATE LOGIN command will let you know via refusing to create a login off a non-existent AD group. Sorry, I can't help with the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:13 pm
It also looks like you're trying to turn your SQL Server into an application server. What are you attempting to accomplish that you need to start a service on a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:09 pm
lil_emery13 (5/5/2012)
Thanks for your help, will look into create function.
Can you please confirm you're platform is SQL Server, and that the version you'll be developing for is SQL Server 2008?
I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 1:07 pm
PaulB-TheOneAndOnly (5/6/2012)
SQL_ME_RICH (5/4/2012)
The other consideration was their desire for speed over the accuracy of the data. Yes - you read that correctly. :crazy:
:w00t: Yes, absolutely crazy. Nothing...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 12:31 pm
The company where I am currently will only apply Service Packs, reasoning that Hotfixes, bunches of hotfixes like CUs and QFEs are only unit tested, i.e. that Microsoft only guarantees...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 7, 2012 at 12:10 pm
Viewing 15 posts - 4,156 through 4,170 (of 7,164 total)