Viewing 15 posts - 1,906 through 1,920 (of 5,502 total)
Rich Yarger (2/15/2011)
Hey gang - thank you again!Just one last thing...
My DECLARE and SET up at the top of the XML data should be. . .???
... like the example Mister...
February 15, 2011 at 5:11 pm
Craig Farrell (2/15/2011)
I'll admit my XQuery is very weak. One of the things that's always confused me is this part:
FROM
@XML.nodes ('/ROOT/Customer') as cust(cn)
cross apply...
February 15, 2011 at 5:09 pm
MM
using your very fine example I'd suggest using CROSS APPLY instead of "climbing up" the nodes level.
Just compare execution plan and query statistics... (on a larger set of data, of...
February 15, 2011 at 4:26 pm
Craig Farrell (2/15/2011)
LutzM (2/15/2011)
GilaMonster (2/15/2011)
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.
Wouldn't index 1 be used if...
February 15, 2011 at 4:10 pm
GilaMonster (2/15/2011)
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.
Wouldn't index 1 be used if a query would...
February 15, 2011 at 3:43 pm
krushkoder (2/15/2011)
Thanks Lutz!See, I knew it was simple!
Many Thanks!
KK
Please read my reply completely.
The query I posted may perform really bad. Hence my advice to add the computed column.
February 15, 2011 at 3:05 pm
You could use
SELECT *
FROM table_A A
INNER JOIN table_B B
ON B.StkNumber LIKE '%'+A.StkNumber
However, this will cause a table scan since there is no index the query...
February 15, 2011 at 2:45 pm
GSquared (2/15/2011)
February 15, 2011 at 2:25 pm
Bad news first: No, there is no wizard.
Now the good news: please have a look at the CrossTab article referenced in my signature. It'll show you how to do it...
February 15, 2011 at 2:00 pm
did you try a google search?
The keywords "restore from TDE database backup" returned several useful links, including this one.
SSC - your Simple Search Community.
February 15, 2011 at 11:22 am
Dave Ballantyne (2/15/2011)
First big change i need to do today is was told to make the...
February 15, 2011 at 11:08 am
praveensc2003 (2/15/2011)
Hii am not able solve this problem. can any body guide how to solve this. send me sample script.
thanks
It's hard for us to provide you a script that would...
February 15, 2011 at 10:36 am
Something like this?
SELECT
customer.value ('@CustomerID', 'int') AS CustomerID,
customer.value ('@FirstName', 'nvarchar(20)') AS CustomerFirstName,
...
February 15, 2011 at 10:21 am
What do you need that c.u.r.s.o.r. for?
Unless I'm missing something, the following statement should do it:
UPDATE #mytable
set permitnum =
case
when id = 1 then permit1
when id = 2 then permit2
when id...
February 14, 2011 at 5:12 pm
Just remove the "as" between your column names and the data type.
Example:
Instead of
FranchiseGroup as varchar(255),
use
FranchiseGroup varchar(255),
February 14, 2011 at 2:46 pm
Viewing 15 posts - 1,906 through 1,920 (of 5,502 total)