Viewing 15 posts - 1,561 through 1,575 (of 2,894 total)
Do you like puzzles?
declare @in varchar(50)
declare @out varchar(50)
set @in = '[p]a]a]s]s][p'
select @in as [IN],
(
select r+''
from
(
...
May 15, 2012 at 10:09 am
...
Don't need the DECODE function, it was confusing to me, found use CASE WHEN more readable if verbose. Packages, just reminds me of ADA and after working with SQL...
May 15, 2012 at 9:47 am
Lynn Pettis (5/15/2012)
Eugene Elutin (5/15/2012)
Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources....
May 15, 2012 at 9:11 am
Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources. Because table variables have...
May 15, 2012 at 9:01 am
Lynn Pettis (5/15/2012)
May 15, 2012 at 8:43 am
Lynn Pettis (5/15/2012)
Eugene Elutin (5/15/2012)
...
Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.
The clustered index should be on a...
May 15, 2012 at 8:27 am
kwe477 (5/15/2012)
...
Dynamic queries:
are nothing more than ad-hoc queries built using a dynamic string. Dynamic queries are considered ad-hoc queries by the optimizer because they are not...
May 15, 2012 at 8:04 am
...
Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.
The clustered index should be on a better choice, and should...
May 15, 2012 at 7:55 am
jonas.kasper (5/15/2012)
I am creating a job that will send emails every morning showing different data that has occured during the last day. Some of the data that is...
May 15, 2012 at 4:05 am
Phil Parkin (5/15/2012)
Eugene Elutin (5/15/2012)
ISNULL(tb_2.column_2, 'Undefined')You didn't mention the 'c' word...
Or, yeah!:cool:
To OP:
Are you sure you need a cursor for what you're doing?
May 15, 2012 at 3:51 am
ISNULL(tb_2.column_2, 'Undefined')
May 15, 2012 at 3:28 am
reidres (5/15/2012)
While the output of your proc is correct, I am literally interested in either a process that matches my topic title or a definitive...
May 15, 2012 at 3:15 am
...
Only while you're looking. There is no guarantee of order in a SELECT unless you have an ORDER BY.
...
It's not applicable for dense_rank, where order is enforced. After second...
May 15, 2012 at 3:06 am
If nothing has changed, it would continue to work.
So, something has changed! (It doesn't work now - it's a change!)
Is this only bit doesn't work? Any other parts of code...
May 14, 2012 at 10:06 am
I would think that ADO has a problem with oppening the connection to SQL server as per your "Friday's" environment.
DNS changed?
May 14, 2012 at 9:25 am
Viewing 15 posts - 1,561 through 1,575 (of 2,894 total)