Viewing 15 posts - 706 through 720 (of 859 total)
SQLKnowItAll (4/3/2012)
Cadavre (4/3/2012)
S_Kumar_S (4/3/2012)
I need a query(or function) that filter the names(column name) which have consecutive 3 alphabets. basically I want to filter out those garbage names. e.g. sabcmm has...
April 3, 2012 at 11:47 am
GSquared (4/3/2012)
Brandie Tarvin (4/3/2012)
Revenant (4/2/2012)
AUI, meaning Administering Under Influence.Isn't that illegal?
I'm sure there's some sort of law against that... Or is the law for it? I can never remember.
I'm pretty...
April 3, 2012 at 9:35 am
Sean Lange (4/3/2012)
capn.hector (4/2/2012)
Koen Verbeeck (4/2/2012)
EL Jerry (4/2/2012)
I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that...
April 3, 2012 at 9:31 am
the only way to resolve the issue is to some how authenticate between domain1 and domain2 whether running a batch file to link the users or linking the domains...
April 3, 2012 at 9:28 am
SQL_Enthusiast-AZ (4/3/2012)
I didn't think it would be so easy. I thought there would be some kind of logic that would much more complicated... Sorry, I...
April 3, 2012 at 9:24 am
anthony.green (4/3/2012)
do a foriegn key to the same table and pass in the right manager employee id for the employee, standard parent child relationship
of course if the employee id changes...
April 3, 2012 at 8:49 am
SQLKnowItAll (4/3/2012)
Anders Pedersen (4/3/2012)
April 3, 2012 at 8:40 am
shoud get you close.
CREATE TRIGGER TriggerName
ON Table.Column
AFTER UPDATE --can also do AFTER INSERT, UPDATE if you want both
AS
INSERT INTO ZZ_CUSTOMER_HOLD_REASON
SELECT CUSTOMER.HOLD_REASON,CUSTOMER.CUSTOMER_ID,
...
April 3, 2012 at 8:21 am
itskanchanhere (4/3/2012)
April 3, 2012 at 8:09 am
itskanchanhere (4/3/2012)
April 3, 2012 at 8:08 am
for your sample data can you post hard coded inserts. we do not have your underlying tables so SELECT * INTO #BLah FROM BlaBla will not work in...
April 3, 2012 at 8:00 am
Koen Verbeeck (4/2/2012)
EL Jerry (4/2/2012)
Sean,I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂
"El" Jerry.
We're...
April 2, 2012 at 6:25 pm
EDIT: Double post. wow i double clicked and it posted twice.
April 2, 2012 at 4:35 pm
SQLRNNR (4/2/2012)
If the backup file is corrupt, you will need to find a backup file that is not corrupt or take a new backup.
corupt backups can not be restored. ...
April 2, 2012 at 4:35 pm
dcsurfer67 (4/2/2012)
I have a backend on SQL 2008 and whne I look at the DB properties, general, the size is 5.25MB and space available is .80MB. What is...
April 2, 2012 at 2:55 pm
Viewing 15 posts - 706 through 720 (of 859 total)