Search results for query: *

It's been a while since I posted or helped out some folks here, but I am back with a question. I have a website I am working on that has to display a currency value as stored in the database as a text string. It has to optionally display cents if available, and deal with values into the 100s of...

Okay, our data model has changed slightly and we are introducing a new table, NEW_TABLE, with PK/Identity column. This table will be associated with an existing table, LEGACY_TABLE, via a FK which is nullable (nullable so that we can time the rollout of app changes with in a lax fashion). As...

SQLAgent stores job history execution in seperate run_date and run_time integer columns, in the format: run_date = YYYYMMDD run_time = HHMMSS And, since these are integers and seperate columns they are a pain to force into a SQL DATETIME, but HERE is one way: SELECT RUN_DATE_TIME = convert(...

We are generating data mining lookup table that has (redacted) the following integer columns: COL_A COL_B ----- ------ 100 5 100 6 200 10 200 11 The above data shows the "dupes", in that we really want COL_A values to appear only once (unique) and we would like the MAX associated...

First, let me state that for our data mart we are NOT using any type of an ETL product or toolkit and are instead using custom stored procedures. The decision to go this route was one of cost and expediency, but may be "rethunk" in the future. My question is, how fast is fast when it comes...

That's the question...please be nice in your answers. A little background might be helpful. I find that everyone around me and most on this forum use the (LEFT) JOIN syntax for constructing queries with joins. I, on the other hand, like to place all the tables in the FROM clause, connect them...

Useful user-defined functions for massaging a date/time into TwelveAM and Midnight (actually 3ms before midnight): Comments? -- ** Midnight ** if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Midnight]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[Midnight]...

Okay, we have the need to model a "source" fact table that has discrete facts about people viewing online movies, on demand. This fact table will have one record, per view, including start date/time and viewing duration. The time dimension is broken into a 15 minute grain (96 records...

Only users that are members of the Administrators group can log on to my website. I have changed NTFS perms, etc until blue in the face. My website has basic authentication. The web server is on the domain server. It's a W2K box. When browsing to the site I get the grey logon panel, and...