Viewing 15 posts - 2,026 through 2,040 (of 13,462 total)
data in a consumable format:
i got tired of the solution just cleaning up the data, and gave up at that point.
;WITH MyCTE([ID],[Dept],[Address],[GroupID ])
AS
(
SELECT '165683','32 ','P O BOX 602','2' UNION...
February 9, 2015 at 7:27 am
my best guess base don the limited information.
SELECT *
FROM Customer
--nothing in last 3 monts
WHERE CustomerCode NOT IN(SELECT o.CustomerCode
...
February 9, 2015 at 5:51 am
jahid786 (2/6/2015)
February 6, 2015 at 1:17 pm
i do this ALL the time. i have suites of procedures using this ability.
it requires a few things
it must be placed in the master database. (not some DBA_Utilities or...
February 6, 2015 at 11:44 am
i think the issue is connecting to an exchange server is not the same as connecting to an SMTP server, even if that server happen to be an exchange server.
the...
February 6, 2015 at 6:32 am
similar to what Igor posted, the code below can help find objects that reference a linked server, but can't find adhoc usage of a linked server, for example if an...
February 5, 2015 at 5:51 am
I'd go for local reachouts first. put together a letter of introduction/highlights of exactly what your skillset can contribute. this would not be a resume, but direct experience someone...
February 5, 2015 at 5:34 am
nope, it is not possible to deny a sysadmin access to anything.
permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.
the only solution...
February 4, 2015 at 2:36 pm
wow, i fiddled with doing this with substring and charindex, and it is so ugly compared to using a delimitedsplit.
/*--Results
(No column name) UNC ...
February 4, 2015 at 2:33 pm
suppiunna (2/4/2015)
February 4, 2015 at 10:45 am
to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns in the SELECT, right?
CREATE INDEX...
February 4, 2015 at 10:27 am
you probably want to fix the trigger., or remove the trigger completely and move the migration from one table to another to a job that runs every x minutes.
as a...
February 4, 2015 at 10:13 am
it is not possible to deny a sysadmin access to anything.
permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.
the only solution...
February 4, 2015 at 9:02 am
nikki123 (2/4/2015)
Hi
I need to load the latest csv files from file server , The files are placed in a folder called -
Posted 02022015- --> csv files .
I am...
February 4, 2015 at 8:57 am
isn't this just the difference between a session(connection), and having actually committed a request?
if i open ssms and open ten blank tabs, that's ten sessions, and zero requests.
until i run...
February 4, 2015 at 5:59 am
Viewing 15 posts - 2,026 through 2,040 (of 13,462 total)