Search results for query: *

I am trying to set up a publication with a report that contains sub reports. I set the delivery rules to "Only Send when Report Contains Data". I managed to figure out that the rule works when I remove the sub reports but does not work when I include the sub reports. I need the sub reports and...

SQLsister I agree but I dont have access to the source file.......someone just wanted a quick query......might be a one time affair

I am creating a query and want to bring back 2 fields to have 5 places. field 1 123 I need to to be 00123 same with field 2

Beautiful Dennis.....Stored procedure created and job created to run every month. Thanks for the help guys. People will think I am actually smart today!

I want to run a a query at any time and only inserts/appends data to the table if the record does not exist. No duplicate rows. How can write this?

While I have your attention....This is going to be a stored procedure that I need to be executed once a month. What could do I need to insert so I dont insert duplicate values based on the period field??

GREAT....scale fixed it. Deleted all, reinserted and the correct values are now being displayed. Why cant they call scale (decimal places) Thank yOU!

Table Script if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fte]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[fte] GO CREATE TABLE [dbo].[fte] ( [tkinit] [varchar] (8) COLLATE Latin1_General_CI_AS NOT NULL , [name] [varchar] (40) COLLATE...

Yes they both have a value of 18

Have a query that when I run, the last 2 fields return results from a calulation( 1.00, .80, .20 or nulls). When I create a table the last 2 fields are decimal fields allowing nulls. When I insert the data into the table the last 2 fields only show values (1, 0, or null) Any ideas??

how can I do this using crystal forumlas?