Search results for query: *

I have a field with the first names I want to strip off all but the first letter (First initial) and then combine it with the last name for a username. How do I strip off the dta I do not want?

Its a test server so it does not get patched much since it gets rebuilt regularly

Version is Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: ) Here is the view REATE VIEW dbo.wpindex_detail_LU AS SELECT dbo.wpindex.*, dbo.Controls.ControlName ...

Hi, I am using sql server 2003 and have come up on something I have not seen. I have views and if I add a field (to a table in the view) the view starts returning the wrong fields. ANy idias?

Thanks a lot, I got it working. You are the best

I have tried that here is my query Insert Into dbo.wpindex.sysctrlid, dbo.wpindex.site_id, dbo.wpindex.sys_id Select dbo.404_wp_cre.sysctrl_id, dbo.404_wp_cre.site_id, dbo.404_wp_cre.SysID From dbo.404_wp_cre I get a 170 error. Thanks

Yes, I have data in several tables that I need to put into a summary table regularly(quarterly)

Hello, I need to create an append query from a view into a table. I read I should do this as a stored procedure, but get errors parsing the code. Can anyone help me out?