Viewing 15 posts - 1,216 through 1,230 (of 2,462 total)
-- Create a table
IF OBJECT_ID('tempdb..#X') IS NOT NULL DROP TABLE #X;
CREATE TABLE #X (x int)
-- start transaction
BEGIN TRANSACTION
INSERT #X SELECT 1
INSERT #X SELECT 2
INSERT...
-- Itzik Ben-Gan 2001
October 15, 2015 at 2:52 pm
timwell (10/15/2015)
Eric M Russell (10/15/2015)
I believe Excel is more often used for professional data analysis than MS Access. What functionality is missing from Excel that she finds in MS Access?
I...
-- Itzik Ben-Gan 2001
October 15, 2015 at 2:43 pm
You can also do this:
SELECT
J.DT_ID
,J.InvNo
,Salesmman = SUBSTRING(J.SalesCode,1,CHARINDEX('!',J.SalesCode)-1)
,Commision = SUBSTRING(J.Amount,1,CHARINDEX('!',J.Amount)-1)
FROM @TEST_DATA J
-- Itzik Ben-Gan 2001
October 15, 2015 at 2:32 pm
Is calculating the median in the SQL Query that feeds the report an option?
-- Itzik Ben-Gan 2001
October 15, 2015 at 11:01 am
So, for the first time in a very long time the betting sites have the Cubs as the favorite to win the World Series. We have to beat the Dodgers...
-- Itzik Ben-Gan 2001
October 15, 2015 at 8:24 am
pilab72 (10/14/2015)
Is there any stairway about analytics functions?
Nope. Except for Part 7[/url] of the Stairway to Advanced T-SQL[/url]
I highly recommend Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
-- Itzik Ben-Gan 2001
October 14, 2015 at 6:50 pm
Go Cubs!
-- Itzik Ben-Gan 2001
October 13, 2015 at 6:19 pm
I try to keep up on salary trends for data jobs (BI/DBA/SQL Dev, etc). Though I have not posted my resume anywhere In a few years I still get plenty...
-- Itzik Ben-Gan 2001
October 9, 2015 at 12:16 pm
mw112009 (10/7/2015)
No needFound answer....
DECLARE @id INT
SET @id = 0
UPDATE accounts2
SET @id = id = @id + 1
GO
This technique is what many people refer to as...
-- Itzik Ben-Gan 2001
October 8, 2015 at 9:14 am
Sideout1972 (1/31/2012)
It ran horribly from the command line as well. After taking steps to eliminate memory issues by putting the code that processes an XML doc into its own...
-- Itzik Ben-Gan 2001
October 7, 2015 at 9:56 pm
Is there any way to reduce this code??
Lose that ORDER BY clause; it seems like it's just for display - let display stuff get handled at the application level.
-- Itzik Ben-Gan 2001
October 1, 2015 at 1:20 pm
Are you absolutely, positively getting duplicate records is you don't include that DISTINCT. I bet that query will run relatively faster without it. If you do need that DISTINCT then...
-- Itzik Ben-Gan 2001
October 1, 2015 at 1:12 pm
Great article. I agree that there's a need to learn Hadoop, NoSQL, etc as that's the trend and where businesses are heading. The well rounded data professional who knows multiple...
-- Itzik Ben-Gan 2001
October 1, 2015 at 9:45 am
The reason it is so serious is because they only keep a couple weeks worth of backups which have never been tested. They are all stored on the same SAN...
-- Itzik Ben-Gan 2001
September 29, 2015 at 8:12 pm
What Drew said.
I would add that, based on what you're showing UNION ALL is probably what you want. If you read Itzik Ben-Gan, he often refers to UNION as...
-- Itzik Ben-Gan 2001
September 29, 2015 at 8:05 pm
Viewing 15 posts - 1,216 through 1,230 (of 2,462 total)