HOW TO PRODUCE LIGHT {Noor(Divine Energy)} IN YOUR HEART. 0 134 (11/15/2009 11:44:07 AM)
The method of producing light.{NOOR} NO MATTER ANY RELIGION - ALLAH(GOD) IS FOR EVERY ONE. In prehistoric times stones would be rubbed together to make fire. Whereas a spark can also be produced by rubb...
fahad

SQL Subquery/Temp Value 6 128 (11/14/2009 4:13:26 PM)
I'm creating a tempval, from this value I use it in the next select query but I receive an error: Conversion failed when converting the varchar value 'Select ColumnID1 from dbo.tbl_main where id = ' to d...
MS

do not display the result of a SELECT 2 401 (11/13/2009 10:39:27 PM)
Hi, For performance issues, we want to do several SELECT statements on tables, in order to load theirs leafs in memory. So everything goes fine, except that the result of the SELECT are in log files, whic...
Stefan

Reference temporary table twice 4 373 (11/13/2009 10:39:17 PM)
I'm trying to temporary table inside a stored procedure, which might be constructed in two entirely different ways, according to the parameters passed to the procedure. Using Northwind, my problem is illus...
richard

generate summary row question 2 113 (11/13/2009 10:17:05 PM)
This is a multi-part message in MIME format. ------=_NextPart_000_0056_01CA6485.1F9AFF40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Having this data set...
Farmer

Need advice on product specs table 2 138 (11/13/2009 1:21:02 AM)
Hi, I'm trying to figure the best way to store product specs data e.g. dimensions, weight, power requirements, etc. Because the database will contain a wide variety of products and in time, there will...
Utf

Select count of columns with data 1 157 (11/13/2009 7:35:06 PM)
I have a table that has 6 columns lets say Column1, Column2, Column3, Column4, Column5, Column6 running on MSSQL 2008. What I need to do is return how many of the coluns in a query contain data. ex: select...
boat73

Three-Tier System Architecture, XML and SQLServer2005/2008 1 300 (11/13/2009 3:36:05 PM)
In the SQLServer 2000 BOL, "Three-Tier System Architecture" section depicts pictorially the role played by the 3 layers. Is there a similar diagram for SQLServer 2008? ...
Utf

Quicked way to create a copy of a table with all default values in 10 114 (11/13/2009 2:49:01 PM)
I know that using something like this is the quickest way to create a table: SELECT * INTO newtablename FROM oldtablename WHERE 1>2 However I need for the new table to have all the default values that have ...
Utf

rolling back / undoing an update task 1 156 (11/12/2009 11:05:24 PM)
I accidentally used this statement when trying to set my 'names' column all to lower case in the away condition: update mytable set names = lower('names') where home = 'away' ...as this changed all the n...
Net