Viewing 15 posts - 6,166 through 6,180 (of 8,761 total)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
February 12, 2015 at 11:29 am
Quick thought, consider changing the hashing part of the statement as it will not produce unique hash values for every unique combination of input values.
😎
February 12, 2015 at 1:15 am
It would be very interesting to see the execution plan for this code and whoever wrote this code apparently doesn't like the optimizer
😎
February 11, 2015 at 11:11 pm
You are very welcome.
😎
A word of caution, make certain you understand the shortcomings of this code, mainly it neither handles NULL values nor does it guarantee unique values for...
February 11, 2015 at 10:53 pm
cm62597 (2/11/2015)
I have tried that as well you just get Error converting data type varchar to float.
Quick question, can you post the full query and the DDL for the relevant...
February 11, 2015 at 10:32 pm
Quick thought, it makes no sense to use CHECKSUM inside the HASHBYTES function, change CHECHSUM to CONCAT to avoid collisions, consider this example:
😎
SELECT CONVERT(VARCHAR(34),HashBytes('MD5', CONCAT(Col001,Col002,Col003,Col004,Col005,Col006,Col007,Col008
...
February 11, 2015 at 10:26 pm
bmahony993 (2/10/2015)
Its using Execute As "domain\user" currently, and that user is a sys admin
Is "domain\user" password expired?
😎
February 10, 2015 at 12:01 pm
Quick thought, use EXECUTE AS
😎
February 10, 2015 at 11:51 am
Quick suggestion, check out this one, The Data Warehouse Toolkit
😎
February 10, 2015 at 1:51 am
Quick note, it is better to use the Point method.
😎
UPDATE Z set Coordinates = geography::Point(Latitude,Longitude ,4326)
FROM dbo.ZipCodes Z;
The spatial data types are implemented in SQL Server as CLR, which...
February 9, 2015 at 11:04 pm
In this case you have to use the ALTER statement, here is a quick example
😎
USE tempdb;
GO
SET NOCOUNT ON;
/* Drop the table if it already exists */
IF OBJECT_ID(N'dbo.TBL_CHANGE') IS NOT NULL...
February 8, 2015 at 11:11 am
Quick note, the modify method only applies to the XML data type, to update a value in a table use the UPDATE statement The following example updates the value of...
February 8, 2015 at 10:37 am
Quick solution, should be enough to get you passed this hurdle
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
SNAME VARCHAR(15) NOT NULL
,A1 CHAR(1) ...
February 8, 2015 at 1:22 am
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Tom, must say that I find this comment totally inappropriate
😎
February 7, 2015 at 3:38 pm
Viewing 15 posts - 6,166 through 6,180 (of 8,761 total)