Viewing 15 posts - 2,146 through 2,160 (of 10,144 total)
ps_vbdev (9/29/2015)
ok try this link to my skydrive.
Local policy prevents me from accessing this at work. I'll try at home.
September 30, 2015 at 1:27 am
ps_vbdev (9/29/2015)
hmmm, Ive removed them and re-added them.
Your website still doesn't trust me 🙁
September 29, 2015 at 9:59 am
ps_vbdev (9/29/2015)
Thanks Chris There is a CreateScript.txt attached to the post, cant you see it?
No. I get a 403 - Forbidden.
September 29, 2015 at 9:26 am
Can you set up some sample data to demonstrate? You will want a temp table for this e.g. #StockTransaction, and only the columns which appear somewhere in the query. I...
September 29, 2015 at 9:13 am
Wayne West (9/29/2015)
ChrisM@Work (9/24/2015)
Why are you using NVARCHAR for an email address?
We now have Unicode URLs, so why not Unicode characters for email addresses. You can Google Unicode Email...
September 29, 2015 at 9:05 am
Don't know tbh - but I've used it a few times with 36.
September 29, 2015 at 7:46 am
SpeedSkaterFan (9/29/2015)
I have a question that maybe is asked before. I have looked for the answer all over the place but I can’t find the exact 1 that solves...
September 29, 2015 at 6:56 am
Does this return the same results as your original query?
DECLARE @StockItemID nVarchar(128)
DECLARE @CreateDate DATETIME
Set @StockItemID='8cbe17da-6079-4170-b27a-41c0d38830f6'
Set @CreateDate = CAST('2015-08-31 13:52:39.890' AS datetime)
--Off those 'OnTranport' items get the next 'Dropped' item of...
September 29, 2015 at 6:33 am
Eirikur Eiriksson (9/28/2015)
rwitt 95744 (9/28/2015)
I'm curious what are the most important/relevant stats, query plan aspects, etc., that you look at, when trying to determine if one T-SQL coding approach...
September 29, 2015 at 1:31 am
raj.prabhu001 (9/28/2015)
Select Col1
...
September 28, 2015 at 7:03 am
Anil Kolla (9/28/2015)
Path:SELECT substring(filename,1,charindex(reverse(substring(reverse(filename),1,charindex('\',reverse(filename)) ) ),filename) )
FileName:
SELECT RIGHT([FileName],CHARINDEX('\',REVERSE([FileName]),-1 )) AS NameOfFile FROM SSIS_LogFileNameRecord
Good effort, though it did take eight years longer than Lowell :hehe:
September 28, 2015 at 4:51 am
mw112009 (9/25/2015)
Reason: EXISTS is just a another subquery that runs for each row that was fetched. Subqueries take time.
The LEFT JOIN will figure out the data set just once...
September 25, 2015 at 9:29 am
Ed Wagner (9/25/2015)
Luis Cazares (9/25/2015)
mw112009 (9/24/2015)
Beleive me, the LEFT OUTER JOIN is faster.I deal with large tables and the "EXITS" make the query run for hours..
Are we supposed to take...
September 25, 2015 at 9:14 am
Barcelona10 (9/24/2015)
I have a table which has cluster index on col1 column. If i insert 10 into my table what would be cluster index key value?Is it going to...
September 25, 2015 at 2:19 am
BWFC (9/25/2015)
September 25, 2015 at 1:43 am
Viewing 15 posts - 2,146 through 2,160 (of 10,144 total)