Programming SQL

Query
Hi Guys Any one please help me below query what is the meaning. IIF(RTL_SML_CONTRACT.TERM_DT=0 Or RTL_SML_CONTRACT.BOOKING_DT=0, 0, CDate(Mid$(RTL_SML_CONTRACT.TERM_DT,5,2) & "/"& Right$(RTL_SML_CONTRACT.TERM_DT,2) & "/" & Left$(RTL_SML_CONTRACT.TERM_DT,4))-CDate(Mid$ (RTL_SML_CONTRACT.BOOKING_DT,5,2) & "/"... 4 Jul 2008 15:08

Listing tables in a database
Hi! I'm using the following procedure to list all tables in a selected database. Select Table_name as "Table name" From Information_schema.Tables Where Table_type = 'BASE TABLE' and Objectproperty (Object_id(Table_name), 'IsMsShipped') = 0 However, it shows me only the tables in dbo schema. How ... 3 Jul 2008 09:25

How to Create a Parameterised GROUP BY Without Using Dynamic-S
What you describe is actually a typical case for using SSAS. On top of that you can also make great use of SSRS as the front end. Why reinvent the wheel? If nothing else, you can at least give SSAS a chance over the weekend. ;) You'll quickly see how much time you've already wasted. ML --- Matija Lah,... 3 Jul 2008 06:21

SELECT * FROM @Table
I know if I want to write a SELECT statement which TABLE could be "variable" I should use "Dynamic Syntax"... but Is there other way to do so? I mean, something in which TABLE in SELECT works like a "@Table" variable. Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 06:21

CREATE TABLE from other (correction)
I am testing the following command : CREATE TABLE NewTable AS (SELECT * FROM Table WHERE 1=2) to create a new table from existing one and no registers, but sends me an error "near AS"... What is wrong? Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 04:18

CREATE TABLE from other
I am testing the following command : CREATE TABLE AS (SELECT * FROM Table WHERE 1=2) to create a new table from existing one and no registers, but sends me an error "near AS"... What is wrong? Beforehand, thank you very much. -- Luis Garcia IT Consultant ... 3 Jul 2008 07:22

job in ausland arbeiten als koch im ausland jobboerse praktikum arbeiten im ausland info Berufsfeuerwehrfrau Berufsfeuerwehrmann ausland jobs de job erzieherin im ausland arbeiten
job in ausland arbeiten als koch im ausland jobboerse praktikum arbeiten im ausland info Berufsfeuerwehrfrau Berufsfeuerwehrmann ausland jobs de job erzieherin im ausland arbeiten + + + ARBEITSANGEBOTE IM AUSLAND http://WWW.STELLENANGEBOT-AUSLAND.DE http://WWW.STELLENANGEBOT-AUSLAND.DE + + + AUSLA... 3 Jul 2008 02:16

Wrapping tables by views
I'm working on a legacy small-enterprise system that has a single database hosted by SQL Server 2005 and a bunch of client applications. The main client (used by all users) is an interactive MS Access 2003 application (ADP), and other clients include various VB/VBA applications like Excel add-ins and command-line u... 3 Jul 2008 04:18

Comparing execution plans - is there any kind of DIFF for this task?
Hi, Let's say I have two SQL queries (SELECT statements) and I need to compare their execution plans. Can anybody recommend any tool or technique that would work better than doing visual comparison in Management Studio? Of course, I am most concerned about cases when the queries are complex enough to produce ... 3 Jul 2008 05:20

Compare Data In Two Tables
I have two tables in two different databases. One has Production data the other has production data + Archive data. to determine which is the archive data so I want to select only the archive data from the database. Both tables have a composite key. How to I select only the archive data and count the number of ... 2 Jul 2008 23:13