Sweet! Thanks! I just wonder how long this new guy will last since the last was fantastic.

Please tell which banks these were for so I can bank elsewhere! :cool:

Didn't they give you the secret decoder ring? :omg:

He should have tried it downhill instead of uphill first to get a hang of it ;)

The politicians wouldn't want them to itemize their deductions and keep a log of who they were used for. It might get interesting.

you forgot the redundant else :)

It is pretty funny how they are after MS for hidding information or private API's, but when Apple does it, they seen nothing or hear nothing. "Kroes also warned that she was still looking at complaints from software rivals that the company wasn't sharing key information that help others make products compatible with Microsoft software." "Private API calls are a definite no-no according to the iPhone Developer Agreement" http://arstechnica.com/apple/news/2009/11/respected-developers-fleeing-from-app-store-platform.ars[^]

OMG!!

You didn't pay them enough! :cool:

Chalk it up to another reason why to never use Visual SourceShredder. :laugh:

My favorite...

if(5 == 5)
do something...
else
do the same thing...

I hav projekt due 4 my companie HCL Tek. Pleaz send me codez. :laugh:

First Imaginary Form :laugh:

My guess is someone elses DLL was disassembled.

Unfortunately, it is a permanent import repository.

Some DB geniuses created this and more.

CREATE TABLE [dbo].[ImportDownload_85_Work](
[ImportFileID] [int] NOT NULL,
[RowID] [int] NOT NULL,
[Data001] [varchar](800) NULL,
[Data002] [varchar](800) NULL,
[Data003] [varchar](800) NULL,
[Data004] [varchar](800) NULL,
[Data005] [varchar](800) NULL,
[Data006] [varchar](800) NULL,
[Data007] [varchar](8000) NULL,
[Data008] [varchar](8000) NULL,
[Data009] [varchar](8000) NULL,
[Data010] [varchar](8000) NULL,
[Data011] [varchar](8000) NULL,
...
[Data195] [varchar](8000) NULL,
[Data196] [varchar](8000) NULL,
[Data197] [varchar](8000) NULL,
[Data198] [varchar](8000) NULL,
[Data199] [varchar](8000) NULL
) ON [PRIMARY]

There are over 100 tables like this on one filegroup and one file! X| Oh yea, the identical copies for each suffixed _Last instead of _Work :confused:

I bet Steve Jobs was the mastermind behind that one! ;)

The key is with unicode data. From LIKE..."When you use Unicode data (nchar or nvarchar data types) with LIKE, trailing blanks are significant; however, for non-Unicode data, trailing blanks are not significant. ..." This was interesting since I haven't done much with Unicode, but in my quest I can't figure out one result. In the following, I turned off ansi padding and inserted into a char and a varchar data with trailing spaces. The space taken for each column is the same since it was truncated on insert. Why does comparing the char (col1) LIKE N'% King' return 0 rows, but comparing the varchar (col1) LIKE N'% King' return 2 rows???

create table #resultsRec ( padding bit, col varchar(20), opr varchar(5), prm varchar(20), rec int)
create table #resultsSz ( padding bit, col varchar(20), sz int, dsz int)

set ansi_padding off
create table #t (id int identity(1,1), col1 char(30), col2 varchar(30));

insert #t (col1, col2) values ('Robert King', 'Robert King');
insert #t (col1, col2) values ('Robert King ', 'Robert King ');

insert #resultsSz select 1, 'char', len(col1), datalength(col1) from #t
insert #resultsSz select 1, 'varchar', len(col2), datalength(col2) from #t

insert #resultsRec select 0, 'char', '=', '''Robert King''', count(*) FROM #t WHERE col1 = 'Robert King' -- returns 2 rows (?) must be trimmed
insert #resultsRec select 0, 'char', '=', '''Robert King ''', count(*) FROM #t WHERE col1 = 'Robert King ' -- returns 2 rows (?) must be trimmed
insert #resultsRec select 0, 'char', '=', 'N''Robert King''', count(*) FROM #t WHERE col1 = N'Robert King' -- returns 2 rows (?) must be trimmed
insert #resultsRec select 0, 'char', '=', 'N''Robert King ''', count(*) FROM #t WHERE col1 = N'Robert King ' -- returns 2 rows (?) must be trimmed
insert #resultsRec select 0, 'char', 'LIKE', '''% King''', count(*) FROM #t WHERE col1 LIKE '% King' -- returns 2 rows, trailing spaces not signficant with ASCII LIKE
insert #resultsRec select 0, 'char', 'LIKE', '''% King ''', count(*) FROM #t WHERE col1 LIKE '% King ' -- returns 2 rows, trailing spaces not signficant with ASCII LIKE
insert #resultsRec select 0, 'char', 'LIKE', 'N''% King''', count(*) FROM #t WHERE col1 LIKE N'% King' -- returns 0 rows (?), trailing spaces signficant with UNICODE LIKE
insert #resultsRec select 0, 'char', 'LIKE', 'N''% King ''', count(*) FROM #t WHERE col1 LIKE N'% King ' -- returns 0 rows, trailing spaces signficant with UNICODE LIKE

insert #resultsRec select 0,

Why don't you explain why? If you change from NVARCHAR to VARCHAR, each recordset is 2. :zzz:

This may be a code signature