Thanks

I'll go ahead and serch the whole C:\Program Files..... for the DateTime, but I do not have a "C:\Program Files\Microsoft SQL Server Books Online" dir. Got VS6, VS.NET, VS.NET 2003.......

Lars, try the various methods. depending on your data, the REPLACE() may run 5-10 time slower than the REPLICATE() or RIGHT(). Also consider if -1 = '-00001' or '0000-1' for...

When unable to type, left banner is just the Blue bordered box

When I am able to type, the Litespeed ad fills the box almost instantly.

The footer banner (Compare... 100 times....)...

And... What happens if you put that particular server in another EM Server Group (not the "SQL Server Group"), and leave it's tree collapsed?

Heck , I've got servers that don't even exist anymore. Hope it not slowing me down trying to get to these guys... I guess EM tries to keep the "green...

Ok, installed on WinXP PC fine, my "old" PC (don't ask - pre anything you probably have) gives me "... You must install a Windows service pack that contains a...

One other thing, sometimes when perfoming a query in Q/A to the AS400, a "Client Access provided Login" dialog box may appear under certain configurations. If this is the case,...

Here is what I say:

"The Client Access ODBC driver has many configuration options that affect the way the Windows PC and AS400 interact. These options are not staightforward, and the...

The "not getting all the rows" thing...

also ODBC config settings.

Sorry no details, shoot I don't even have an AS400 here /

NP, just post any results of what you do if you see any significant performance gains / losses depending on what all you're seting up or testing.

Thanks

I do not know if "SHEAU"."AA_CHEQUE" is identicle to "SHEAU.AA_CHEQUE" ????

Seems I came across "not getting all the rows" thing... Will look into...

On the INSERT side, try enumerating the individual column...

Thanks Lars

Yes, can be simplified... just remember to deal with negative values if appropriate.

Yes, same min/max, as far as I can remember.... (been a while, and getting older )

In a prior post I once wrote:

@ http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=19016#bm90510

I was wanting to do the same thing some time ago... I realized that Table Function parameters can NOT be values...

I use a little udf like