Viewing 15 posts - 2,296 through 2,310 (of 2,452 total)
apologies for the <bump>....any ideas any one?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2010 at 10:59 am
think we need bit more of your original data
does this help?
USE [TEMPDB]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2010 at 4:48 am
Jeff Moden (8/5/2010)
Considering all that, you want to write Part Two and I'll play tech reviewer and editor for you? 😉
Jeff....I have found that I prefer to read articles from...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2010 at 1:54 am
Bhuvnesh (8/5/2010)
Jeff Moden (8/5/2010)
use the quiirky update in this manner....Any article link ??
http://www.sqlservercentral.com/articles/T-SQL/68467/
have also corrected link in my original post.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2010 at 11:48 pm
TheSQLGuru (8/3/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2010 at 2:35 pm
MEH 725 (7/28/2010)
I'm looking into dateadd for the year and month.
select
dateadd(dd,14,dateadd(mm, datediff(mm, 0, GetDate()) - 1, 0)),
dateadd(dd,13,dateadd(mm, datediff(mm, 0, GetDate()), 0))
got me thinking about some of my own reports....this is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 1:36 pm
some useful ideas here to get you started
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 12:26 pm
Mike4King (7/28/2010)
I'll jump that hurdle when it comes. The data that I'm looking at and the situation I need this for shouldn't be a problem.
fair enough ....possibly the following article...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 10:29 am
Just a thought...but what happens when
COMPANYNAME, NUM_USERS
company A, 300
company B, 2500
COMPANYNAME, NUM_USERS, USERS
company A, 3, [442, 443, 446................................................................]
company B, 2, [532, 456.....................
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 10:05 am
will "modulo" help ? (see BOL)
select 10.25 % 1
select 10.00 % 1
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 5:37 am
bteraberry (7/27/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 28, 2010 at 3:28 am
ssis learner__ (7/27/2010)
Thanks a lot for your reply ...
I tried just now for about 4 million and it worked fine...
I will be trying on more...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2010 at 3:01 pm
bteraberry (7/27/2010)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2010 at 2:44 pm
out of interest...what excactly did the update statement update?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2010 at 8:55 am
Hi
hopefully this along the lines of what you want to do.....
I strongly recommend you read the following article by Jeff Moden on this "quirky update".....and to follow all the rules...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2010 at 7:51 am
Viewing 15 posts - 2,296 through 2,310 (of 2,452 total)