Programming SQL

I am trying to match a negative number to its exact opposite posit
You can also take the column and multiply by *-1 and it will reverse the sign. If you always need positive numbers though, then use the ABS() function. "Sh0t2bts" wrote: Hi All, I am trying to match a negative number to its exact opposite positive number, in my table ill use -1520.90 (Variable A) to ... 23 Jun 2010 11:45

I am trying to match a negative number to its exact opposite positive number
Hi All, I am trying to match a negative number to its exact opposite positive number, in my table ill use -1520.90 (Variable A) to match 1520.90 (Variable B) as the match I want. First off I did a little maths and subtracted Variable A from its self twice A-A-A = 1520.90 (Variable B) In my Where cause wrote w... 28 Jun 2010 06:16

Compare Data
Hello Everyone, I have the following problem. I have two different database on the same server, each one with a dif name of course, except they have the exact same tables and basically the same data. In some tables there are a few rows of data that are different from each other. For example, in the clients tab... 23 Jun 2010 06:15

sql result different to excel result
Hi, Just wondering why I am having such problems rounding figures, when I round the same figure on an Excel Sheet, I end up with a different end result to what appears in sql. The Excel Looks Like This. Net Vat Total Allocated Result (=(NET+VAT)/Allocated*Total) 900.00 157.50 ... 24 Jun 2010 05:18

Tracking of changes
Hi, is it possible to see in sql2008 enterprise edition, when some object(stored procedure, function,...) was changed? Any idea, how to watch tracking of changes on objectts? Thank you, Simon ... 28 Jun 2010 18:24

convert to stored proc
Hello. I have been given a conversion assignment to convert Access db (frontend) with sql server 2005 backend to be included in a new webapp that is being constructed. Unfortunately, my stored proc creating is a bit weak and I'm not afraid to admit it. With that said, I came across an Access query that is puzz... 23 Jun 2010 10:38

Retrieve unique values based on multiple columns
I have following table from which I need to retrieve the unique value. computername username machine_id stime name1 T0000 1 2010-05-20 name2 T0000 1 2010-05-21 name2 T0000 2 2010-05-22 I would like to retrieve as unique r... 23 Jun 2010 03:00

How to check record exists before INSERT multiple records
Hi Im a SQL Server newbie and am a bit confused by the number of different methods I have seen posted on the web about approaching this problem. I am using SQL Server 2005 and I have about 500 records defined in simple terms for brevity: ID | EMAIL | NAME | etc I have generated INSERT statements ... 30 Jun 2010 02:11

Insert Data Generate Date into an SSRS Report Header
I generate SSIS package multiple table data loads, and write a record to a data generation table. I wish to insert the last data generation date from a SQL Server into the header (or footer) of an SSRS report. Does anyone have thoughts on best practice for this ? Thank you, ... 23 Jun 2010 17:19

Multiple SCOPE_IDENTITY
I have a stored procedure that does 3 INSERTs and I want to use the new identity value in each one to pass to the next INSERT. Can I use SCOPE_IDENTITY() on each one without a problem? For example: INSERT INTO .... SET @newIdent = SCOPE_IDENTITY() INSERT INTO ..... SET @newIdent2 = SCOPE_IDENTITY --... 21 Jun 2010 15:49