Viewing 15 posts - 5,836 through 5,850 (of 7,164 total)
You can use SQLCLR aggregate GROUP_CONCAT to do this (get it here http://groupconcat.codeplex.com):
SELECT jc.OrderNum,
dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries
FROM #JobCountry...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 12:15 pm
32-bit or 64-bit SQL Server? How much memory does your server have in it and what is the max memory setting in SQL Server?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 12:07 pm
ash0550 (6/27/2011)
In the Adventure works DB If i want select all the tables under Production at once without mentioning in particularHow to do it. Is it possible
Yes, it is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 12:05 pm
Elliott Whitlow (6/27/2011)
opc.three (6/27/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 11:52 am
Elliott Whitlow (6/27/2011)
opc.three (6/25/2011)
Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 10:16 am
whole (6/27/2011)
hi, i cannot do anything about the database design now ...now i understand the criteria that both columns datatypes needs to match...
Excellent, remember this when it's your turn...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 10:12 am
Ninja's_RGR'us (6/27/2011)
Sean Lange (6/27/2011)
I do know what to do on each layer and trust me you both are wrong, no other data engine, or layer, linq, entity framework, Datasets loops...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2011 at 9:54 am
I do love them, like hangnails, and splinters 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 7:51 pm
From http://en.wikipedia.org/wiki/International_Data_Encryption_Algorithm:
IDEA was used in Pretty Good Privacy (PGP) v2.0, and was incorporated after the original cipher used in v1.0, BassOmatic, was found to be insecure.[2] IDEA is an optional...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 7:49 pm
GilaMonster (6/26/2011)
opc.three (6/26/2011)
I always use PerfMon, not sure if it's available in a DMV. If you find a DMV/F please post back 😀
Except that the perfmon counter doesn't actjually track...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 1:06 pm
GilaMonster (6/26/2011)
opc.three (6/26/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 12:48 pm
I always use PerfMon, not sure if it's available in a DMV. If you find a DMV/F please post back 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 8:22 am
Serializable would keep you from getting dups. It is super max lockdown though so using it would defeat the purpose of running two instances of your code as it is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 8:18 am
SkyBox (6/26/2011)
opc.three (6/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 8:00 am
You're welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2011 at 7:58 am
Viewing 15 posts - 5,836 through 5,850 (of 7,164 total)