Forum Replies Created
Viewing 15 posts - 1,036 through 1,050 (of 8,416 total)
-
RE: aggregation, group by clause, need help tweakng query
Don't just add DISTINCT to remove the duplicates. There is a crucial difference between grouped aggregates (SUM...GROUP BY) and windowed aggregates (SUM OVER(PARTITION BY...)):
DECLARE @test-2 TABLE
(
...
-
RE: Table Partitioning Issue
Hi Bhuvnesh,
This script demonstrates how to do what you are looking to do here:
USE tempdb
GO
-- Create partitioning function
CREATE PARTITION FUNCTION PF_Product(varchar(10))
AS RANGE LEFT
FOR VALUES ('BigScreen', 'Computer', 'PoolTable');
GO
-- Create...
-
RE: Time to be split in time slots...
SQLRNNR (1/20/2012)
Duplicate postPlease post answers here
http://www.sqlservercentral.com/Forums/Topic1239489-392-1.aspx
Confusingly, the linked thread refers to itself as a duplicate. I think we should answer here :unsure:
-
RE: billy-yons and billy-yons of rows
Hugo Kornelis (1/20/2012)
(Though I don't understand why MS would choose to use a signed integer to store page numbers; it's not as if there will ever be negative page numbers!)They...
-
RE: Question about GETDATE()
Raymond van Laake (1/20/2012)
Currently I have this:SET @fetchTimestamp = GETDATE()
DECLARE @strTimestamp CHAR(23) = RTRIM(CONVERT(CHAR,@fetchTimestamp,105))+ ' '+RTRIM(CONVERT(CHAR,@fetchTimestamp,114))
SET @sql = N' SET DATEFORMAT dmy UPDATE '+@myTable+' SET myTimeStamp='''+@strTimestamp+'''
EXEC sp_executesql @sql
Why are you...
-
RE: Question about GETDATE()
GilaMonster (1/20/2012)
Yes, they will. GetDate, like Rand, gets one value for a statement (if called once)Not necessarily true for RAND, if it is seeded with a non-deterministic function like NEWID:
SELECT
...
-
RE: SSIS OLEDB Destination Options
Good question, Craig, and not even remotely evil 🙂
-
RE: billy-yons and billy-yons of rows
I like these sorts of questions, nice one Steve.
-
RE: Performance Issue In DB
GilaMonster (1/18/2012)
Not baloney. I've crashed a production server by starting profiler (with a very limited trace set). I'm far from the only one.I have done this :blush:
-
RE: Are the posted questions getting worse?
Brandie Tarvin (1/19/2012)
Is that a chicken hawk?It's the result of a Google Images search for 'flying chicken'. Beyond that, no clue 🙂
-
RE: Performance Issue In DB
Grant Fritchey (1/18/2012)
I wouldn't even say I was an expert at execution plans. Paul can run rings around me without breaking a sweat. That's what an expert looks like.Your cheque...
-
RE: Are the posted questions getting worse?
GSquared (1/19/2012)
"fowl swoop" -
RE: help to write a query to retrieve all attributes for a
aitchkcandoo (1/18/2012)
I tried but got error 'CONCAT' is not a recognized built-in function name.CONCAT is only available in SQL Server 2012, as I said.
-
RE: help to write a query to retrieve all attributes for a
aitchkcandoo (1/18/2012)
That is really great to read relevant documentation. Integer has precendence over varchar. But, I had tried to convert the comma to an int using the CAST...
Viewing 15 posts - 1,036 through 1,050 (of 8,416 total)