Viewing 14 posts - 31 through 44 (of 44 total)
Last TechEd Europe (Barcelona, November 2008) I was talking with Kim Tripp - and she is a guru in indexing, and she told about B-trees as BALANCED TREES.
Also Kalen...
October 9, 2009 at 1:34 am
The third query gives other result than first tree - look at the element names
October 9, 2009 at 1:08 am
To easy
No chance to make a mistake, even without morning coffee
October 9, 2009 at 12:49 am
Hello
If it were xml statementstored in yuor table this would be quite easy as MS SQL 2005 has XQuery language:
Suppose the '<html><a><b>ABCD</b></a></html>' is stored in the Col1 in the table...
February 8, 2007 at 3:11 am
Hello
The following example writes the contents of the @var variable to a file named var_out.txt in the current server directory:
DECLARE @cmd sysname, @var sysname
SET @var = 'Hello world'
SET @cmd =...
February 2, 2007 at 3:12 am
Hello
1) SELECT * FROM Table1 WHERE WDSBAR='xyz'
2) CREATE TABLE Table2 (
WDBCI <your type>
, WDDGL <your type>
, WDPRSQ <your type>
, WDSBSQ <your type>
, WDCCOD <your type>
, WDSLNK <your type>
)
3) SELECT T1.*,...
January 31, 2007 at 1:58 pm
Hello
I would try to change the constraint. The Customization table looks like a nromal linked table (3 rd Normal Form?) . WHy would you like to concatenate strings and separate...
January 31, 2007 at 12:27 pm
Hello
I think filtering will be performed first on each SELECT ... and then result is concatenated
January 31, 2007 at 3:18 am
hello
You would have to define more precise how the views could look like.
Let's assume:
CREATE VIEW V1
AS
BEGIN
SELECT Col1, Col2, Col3 FROM Table A
ORDER BY {...}
UNION ALL
SELECT Col4, Col5, Col6 FROM Table B
WHERE...
January 31, 2007 at 2:52 am
Hello Journeyman
Look, what construction I use and it works:
1) create a temporary table
CREATE TABLE #tmp (
[_TransactionID] uniqueidentifier
January 31, 2007 at 1:42 am
You can also use the master..sysobjects table. Your table should be there also - as name, id etc. But in fact the way given by Mr.Farley is easier
January 30, 2007 at 10:56 am
|
January 30, 2007 at 10:53 am
No you are wrong
I use such statements and everything work fine
January 30, 2007 at 10:49 am
Hello
Of course you can.
I have defined a dynamic query in the @SQLStringAll variable.Then I have run this query and populate temporary table as shown below:
INSERT...
January 29, 2007 at 12:40 am
Viewing 14 posts - 31 through 44 (of 44 total)