Viewing 15 posts - 976 through 990 (of 2,452 total)
Wayne West (1/4/2016)
DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';
SELECT 'MD2' AS HashType, hashbytes('MD2',@HashThis) AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 4, 2016 at 12:30 pm
robert-819720 (1/1/2016)
I do believe that there is one significant caveat with the Quirky Update (just love the name it...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 4, 2016 at 7:29 am
Hi
Thanks for scripts.
Please see code below, where I have added an IDENTITY column to each table to help determine which rows are which.
I think I need some more explanation on...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 1, 2016 at 8:35 am
seems very similar request to one posted earlier today
http://www.sqlservercentral.com/Forums/Topic1748862-3077-1.aspx
??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 31, 2015 at 1:06 pm
please read the following document and then post back with DDL/sample data and expected results.
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum
if you provide the setups, then you are far more likely to get a tried and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 31, 2015 at 6:22 am
tibco29 (12/31/2015)
Please find attached document,will let to know about Input and output as well
please read the following document and then post back with DDL/sample data and expected results.
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 31, 2015 at 5:27 am
just to be clear...what records do you want returned....you have not provided any sample data so...here is a quick mock up
CREATE TABLE NurserySchool(
ID ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 29, 2015 at 1:05 pm
Jeff Moden (12/23/2015)
I don't know what goes on behind the scenes but I do know that, whatever they did, it makes for relatively slow running totals. :crazy:
Jeff...if I recall someone...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 23, 2015 at 8:41 am
Hi...think some scripts / sample data and expected results will help please.
see here for good practice
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 22, 2015 at 12:38 pm
[ @recipients = ] 'recipients'
Is a semicolon-delimited list of e-mail addresses to send the message to
can you tell us a little more about what you are trying to do
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 21, 2015 at 10:19 am
dastagiri16 (12/19/2015)
If I have two columns..I m not able to get the desired result in rollup
suggest you provide some sample data and expected results
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
seems you asked a very similar question...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 19, 2015 at 5:50 am
this article may help you
http://www.databasejournal.com/features/mssql/using-the-rollup-cube-and-grouping-sets-operators.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 19, 2015 at 2:10 am
some sample data will help please
please see this post
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
can you explain a little more as to why you allow multiple race choice....??
EDIT...seems that Luis has very kindly done the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2015 at 9:07 am
mm7861 (11/18/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2015 at 6:50 am
mm7861 (11/17/2015)
At the moment we are using data from 1st September 2015, and have about 180,000 rows that are made up of 10,000 unique assets.
ok....so will each unique asset have...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 17, 2015 at 6:56 am
Viewing 15 posts - 976 through 990 (of 2,452 total)