Viewing 15 posts - 2,056 through 2,070 (of 2,894 total)
Please follow the link at the bottom of my signature to find how you can get better and faster answers.
But just for this case:
set dateformat dmy
declare @t table (id int,...
March 1, 2012 at 10:40 am
Lowell (3/1/2012)
this strips out every char that is a-z,A-Z and 0-9, leaving, i assume, what would be the word separators, like space, dash,...
March 1, 2012 at 9:10 am
There is no way to automaticaly identify such separtors.
You can find all non-letter characters, but SQL will not know for granted that <BR > is a separator, as B &...
March 1, 2012 at 9:07 am
What would define as "word separator"?
March 1, 2012 at 8:52 am
If you would follow this: http://www.sqlservercentral.com/articles/Best+Practices/61537/
you would already have an answer.
March 1, 2012 at 8:50 am
aurato (3/1/2012)
Great Plains Query:-----------------------------
SELECT * FROM SOP30300
WHERE SOPNUMBE IN
(
SELECT SOPNUMBE FROM #StatusHistory
)
...
Have you ever heard of JOIN's in SQL?
SELECT s.*
FROM SOP30300 s
JOIN #StatusHistory h ON h.SOPNUMBE =...
March 1, 2012 at 6:59 am
We don't know what you're trying, as you did not post your code here.
CAST should work. Check this one:
declare @t table (col1 varchar(5), col2 varchar(5), col3 varchar(5))
insert...
March 1, 2012 at 6:47 am
Check my previous post, please. The slowest part of your trigger is using "NOT IN" (for no reason)!
Can you please advise, what have you actually mesured? The time taken...
March 1, 2012 at 5:42 am
GilaMonster (3/1/2012)
March 1, 2012 at 5:38 am
OK, here is one of possible solutions:
--1. create calendar table.
--you can create permanent calendar table
--with all required attributes if you don't have one already
-- the following will generate...
March 1, 2012 at 5:24 am
Can you try this:
ALTER TRIGGER [dbo].[TRG_Log_TempSales2_Changes]
ON [dbo].[TempSales2]
AFTERINSERT,
UPDATE,
DELETE
AS
SET NOCOUNT ON;
-------------------- Determine mode
IF EXISTS (SELECT 1 FROM INSERTED)
BEGIN
IF EXISTS (SELECT 1 FROM...
March 1, 2012 at 4:38 am
Next time, please post your question as per forum etiquette well described in the link at the bottom of my signature, this will guaranteer faster and better answers.
-- setup your...
March 1, 2012 at 4:31 am
Loundy (3/1/2012)
If i'm not mistaken (someone will correct...
March 1, 2012 at 4:00 am
Triggers do add some overhead into processing and it's not good idea to put a lot of business logic into triggers.
However, there are some cases where triggers are winners and...
March 1, 2012 at 3:54 am
azhar.iqbal499 (2/29/2012)
So What Should be the exact alternative of functions to make query fast. I have very long queries so...
March 1, 2012 at 3:40 am
Viewing 15 posts - 2,056 through 2,070 (of 2,894 total)