Viewing 15 posts - 1,201 through 1,215 (of 1,415 total)
chris.smith 91049 (1/21/2014)
patrickmcginnis59 10839 (1/21/2014)
I think Steve's final sentence was telling. We need to deliver solutions faster than the business unit can develop their own
I think its awesome how sqlservercentral...
January 21, 2014 at 9:12 am
I think Steve's final sentence was telling. We need to deliver solutions faster than the business unit can develop their own
I think its awesome how sqlservercentral has solved a problem...
January 21, 2014 at 8:44 am
but we can try to make a difference by producing software quicker
lol why didn't I think of that!
January 21, 2014 at 8:14 am
Awesome link here discussing various methods:
http://stackoverflow.com/questions/11310877/calculate-running-total-running-balance
January 21, 2014 at 6:51 am
below86 (1/15/2014)
January 15, 2014 at 12:57 pm
Luis Cazares (1/15/2014)
below86 (1/15/2014)
Steve Jones - SSC Editor (1/15/2014)
below86 (1/15/2014)
January 15, 2014 at 10:27 am
rakesh ghodasara (1/14/2014)
Use row_number function to get the ranks and add the current value to previous value
This would be nice! I would make a small wager that its not possible...
January 15, 2014 at 6:37 am
We do what we need to do at work. We get systems working just enough. We get by.
Everytime we do this, I'm going to hazard a guess that we also...
January 15, 2014 at 6:25 am
In this snippet:
sqlcmd = "Create table #Eft_Transfer( " & vbCrLf _
& " EFT_No varchar(20), null , " & vbCrLf _
& " Effective_Date datetime , " & vbCrLf _
& " Service_Code...
January 14, 2014 at 11:17 am
If we mean actually create select constants from table or query values:
CREATE TABLE #TEST
(
NAME VARCHAR(100),
FIRSTNAME VARCHAR(100),
PHONE VARCHAR(100)
)
INSERT INTO #TEST
SELECT 'Test1-L','Test1-F','Germany'
UNION
SELECT 'Test2-L','Test2-F','Germany'
UNION
SELECT 'Test3-L','Test3-F','Germany'
;
WITH SOURCEQ (ROWNUM, TXTWRK) AS
(SELECT ROW_NUMBER() OVER (ORDER...
January 14, 2014 at 11:01 am
...home_team.name=null...
This always evaluates to false. You can test it for null by using
...home_team.name IS NULL...
Probably a fairly common trap!
Also, you are joining on a column with a potentially null value,...
January 13, 2014 at 11:02 am
Sean Lange (1/10/2014)
hisakimatama (1/10/2014)
Sean Lange (1/10/2014)
hisakimatama (1/10/2014)
January 10, 2014 at 1:28 pm
You can tell by the MiXeD cAsE that these hackers are especially elite! Google 'sql injection' and put a halt to it!
January 10, 2014 at 12:38 pm
Meltdown (1/10/2014)
Is it possible to ban/prohibit all UNION queries at the Server or Database level?
The UNION clause is one of the most common ways that hackers use to append...
January 10, 2014 at 11:48 am
kbhanu15 (1/9/2014)
Hi All,can any one clarify the difference between NOLOCK and WITH(NOLOCK) in sql server 2008 ?
which one is the best practice to use ?
I've been in the situation where...
January 10, 2014 at 10:44 am
Viewing 15 posts - 1,201 through 1,215 (of 1,415 total)