Viewing 14 posts - 31 through 45 (of 45 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...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
October 9, 2009 at 1:34 am
The third query gives other result than first tree - look at the element names
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
October 9, 2009 at 1:08 am
To easy
No chance to make a mistake, even without morning coffee
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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 =...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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.*,...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
January 31, 2007 at 12:27 pm
Hello
I think filtering will be performed first on each SELECT ... and then result is concatenated
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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
Kindest Regards, Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
January 30, 2007 at 10:56 am
|
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
January 30, 2007 at 10:53 am
No you are wrong
I use such statements and everything work fine
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
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...
Kindest Regards,
Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET
January 29, 2007 at 12:40 am
Viewing 14 posts - 31 through 45 (of 45 total)