Programming SQL

is there _ANY_ way to show the row that is throwing an error in a query?
I have the query below that is throwing the error 'Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int.': select l.heading_code, ROUND(LMIimp - YPCimp*LMIclicks/cast(YPCclicks as decimal(19,10)),0) as Ideal_Reduction_in_Impressions from #lmiMetric l LEFT OUTER J... 25 Jul 2008 04:17

Can I have TRY...CATCH in a UDF
Can I have TRY...CATCH in a UDF I am getting syntax errors and have no idea what is causing them. Also, it did not like my SET NOCOUNT ON statement SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].GetParentsChildren') AND OBJECTPROPERT... 25 Jul 2008 03:16

Security - Views, functions, or stored procedures?
I'm creating a client/server application and I'm new to SQL server. I'll be using SQL Express 2005. This same application will be used by several different users, and each user should only have access to their own data. Each user will have a user ID and all data will be linked to that user ID (all rows in the tab... 25 Jul 2008 15:34

SQL Developer Edition 2005 intsall question
I know there is technically no such thing as a dumb question but i think i have one, please bear with me here. I know how to install, configure and use SQL server very well first and foremost. However i just bought 2005 developer edition and noticed that there are 8 disks enclosed. How many of these disks do i n... 25 Jul 2008 15:34

SMO: DefaultCollection for a table
Using SMO in SQL Server 2005 and Visual Studio 2005: I would like to get a collection of defaults that are defined for all tables in a database. I see the following data type: Microsoft.SqlServer.Management.Smo.DefaultCollection Is there an easy way to populate this? As a parallel, the TableCollection ... 24 Jul 2008 18:04

INSERT INTO....SELECT.....
When I do an INSERT INTO....(A,B,C)...SELECT is it possible for A to come from a declared variable (same for every row inserted), B to come from the SELECT and C to come from the select but be determined by a CASE statement. Thanks. ... 24 Jul 2008 19:06

Temp table in stored procedure is not getting filled up
Hi I have a view as the following: This view has SalesPerson as a alias name. (PROJ.Last_Name + ' ' + PROJ.First_Name AS SalesPerson) Now I need to test a prototype procedure and then extend the concept to the real one. I am trying to create a temptable that will have the projectno and salesperson informatio... 24 Jul 2008 17:02

Dessous Erotic Lingerie Shop http://dessouserotic.com
http://www.dessouserotic.com/index.php Lingerie, est le terme utilis� pour d�signer l'ensemble des sous-v�tements et des v�tements de nuit . Elle se caract�rise par des tissus fins, lavables, brod�s ou garnis de dentelles. La lingerie d'aujourd'hui se veut fonctionnelle et �l�gante. Douce, soyeuse, l�g�re ou transpare... 24 Jul 2008 16:00

very large Dynamic SQL statement but limited variable size?
I want to dynamically build and execute some DDL statements. For example I want to cycle through all the databases listing in a table where each of these databases have the same schema. Then I want to build a view in one database that is the union of the data from a given table that exists in all the databases.... 24 Jul 2008 17:02

We optimized our reporting and slowed down our data input!
We have a SQL Server 2K5 DB Application (with Merge Replication Involved) and we were having performance issues with Reporting (they took too long to generate). We introduced Maintained Views to reduce our reporting times and discovered that most of our data input functions through our front end GUI have groun... 28 Jul 2008 11:02