Programming SQL

Stored proc permissions
SQL2000 standard SP4. I've given a user exec permission on a stored procedure that I've created but she gets an error when running it. The output through QA when I run the stored proc with exec is: (8062 row(s) affected) (8732 row(s) affected) (1 row(s) affected) Server: Msg 208, Level 16, State 1, Procedure ... 1 Jul 2008 11:18

query perfomance issue with Select statment in the Select list
Hi all, Using SQL 2000 sp4 This query works, put takes about 11 to 20 seconds. Just trying to be more effient with it and maybe write it better. I hope I explain this correctly so you guys can understnd. --Orders table has 869,000 rows --Table Schema: (I have left out columns not being used in this query... 1 Jul 2008 17:29

Dynamic SQL , Discussion about Erland’s Article
Hello, http://www.sommarskog.se/dynamic_sql.html I've read Erland's new article about Dynamic SQL , The Curse and Blessings of Dynamic SQL , I have to say , I disagree ! The solution he offers thru sp_executesql is very complicated in many situations , like , if we have 10 parameter options for the user to ... 1 Jul 2008 22:36

Drop all table and repopulate
I want to drop all the tables and in a database and repopulate with the tables exist in the other server. What is the best method that i can do? While i am trying to drop the object i am getting error if it has dependencies how and i drop all the tables including all the dependicies. ... 2 Jul 2008 13:58

query help
Hello Use SQL Server 2000 Given a table which holds string data ( could be characters as well) If user provide with value let me say '88' I return the data where this value is occured (col= 4,5,7 for example in my case) However if user does not provide a value I need to return all data where occured 23 and ... 1 Jul 2008 19:33

Q: Linked Server and Stored Procedure
Hi! I have created a Linked Server and a stored procedure. In the stored procedure i create a temporary table i fill the temporary table with data from the linked server. use the temp table to issue a couple of things if i execute this sproc directly on the server it works just fine. But if i open SQL Man... 1 Jul 2008 07:12

i just want table order to create tables
i just want table order to create using sys.foreign_keys , because i have every table as separate object with help of this query i took those not having relationship , so these table can be created first SELECT * FROM INFORMATION_SCHEMA.TABLES a WHERE TABLE_TYPE = 'BASE TABLE' AND a.TABLE_NAME NOT IN... 1 Jul 2008 02:05

how to strip specific email address from nvarchar field with multiple addresses
Hi! I have the following ddl in sql server 2005 id int sentto nvarchar(1000) sentto can be like this: Doe, John [john.doe(a)google.com]; Dom, Jane [jane.dom(a)yahoo.com]; Ross, Julia [julia.ross(a)google.com] or it can be only one email address. I need to only keep all those records that do not have @... 1 Jul 2008 10:16

T-Sql question
I have a query that produces a list of companies and their effective controls status for the given year: select companyname, iseffective, year from internalcontrols where year > 2004 This produces a list similar to this: ABC Corp. yes 2005 ABC Corp. yes 2006 ABC Corp. yes 2007 ABC... 1 Jul 2008 01:04

Inner Dynamic SQL Single Quotes Issue
Trying to get single quotes are + lvc_Column + in inner Dynamic SQL Loop below. If I add '' to either side, when I execute, I get Wednesday_02 = case when right(' + @lvc_Column + ', 2) = c.Today then c.Course and it should be Wednesday_02 = case when right('Wednesday_02', 2) = c.Today then c.Course ... 2 Jul 2008 19:07