Viewing 15 posts - 2,176 through 2,190 (of 3,221 total)
Amongst a list of T_SQL for date manipulation, I am sure you will find one that meets your objective in this blog posting by Lynn Pettis
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
January 22, 2010 at 11:06 am
In additiion to GilaMonster's comments, and the database is configured as decribed.
Do the two tables in question have any indexes? If so statistics will be automatically created for them....
January 21, 2010 at 12:04 pm
MIght I suggest that you examine using the OUTPUT clause, which is much easier to code for multiple rows being insterted/updated/deleted than a trigger.
Use Books On Line it has a...
January 21, 2010 at 9:45 am
Right now with the employment market as it is ..what is most important is EXPERIENCE, EXPERIENCE, EXPERIENCE. Many firms I am aware of, treat MS certification as oh well,...
January 20, 2010 at 3:24 pm
A slight modification of your code from:
DECLARE @P_FECHADIAYER datetime
select dateadd(dd, datediff(dd, 0, Getdate()) - 01, 0)
To:
SET @P_FECHADIAYER = dateadd(dd, datediff(dd, 0, Getdate()) - 01, 0)
--
--following just to display result...
January 19, 2010 at 2:50 pm
Do not know if this will help you, but have you examined CHARINDEX function? For example:
DECLARE @dcv1_FieldValue VARCHAR(10)
DECLARE @N INT
DECLARE @Next INT
SELECT @dcv1_FieldValue = '620..00'
SET @N = CHARINDEX('.',@dcv1_FieldValue,1)
SELECT @N
SET...
January 19, 2010 at 9:39 am
Fields!ABC.Value
How can I set the width of the column dynamically so that the spacing is not fixed and is consistent
Fields!ABC.Value - appears to be ACCESS coding ... you sure...
January 18, 2010 at 7:18 pm
If you can not modify the tables then you might consider creating a parameterized stored procedure , true you would have to pass the values to the procedure, but that...
January 18, 2010 at 7:08 pm
Have not had any problems, such as forum is down ... not in the last 6 months
January 18, 2010 at 6:19 pm
skailey
If those worked for you visit Lynn Pettis blog on SSC and learn a great deal more on some neat datetime handling T-SQL
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
January 18, 2010 at 4:19 pm
Since both are datetime in a equality statement (=) you will want to compare them without considering time ... that is using just the date.
Have you attempted that, and did...
January 18, 2010 at 4:11 pm
If I understand you correctly these 2 fields are both datetime
ON a.COD_DIM_CALENDARIO_FEC_TASACION = b.COD_DIM_CALENDARIO
is that correct?
If so you, are making a comparision up to and including milliseconds ...
have you...
January 18, 2010 at 3:22 pm
Prehaps these will get you started (Copied from blog posting by Lynn Pettis)
select dateadd(qq, datediff(qq, 0, @ThisDate), 0) -- Beginning of this quarter (Calendar)
select dateadd(qq,...
January 18, 2010 at 9:49 am
ChiragNS learnt some thing. but how does it work?
These 2 blog poast might help you to learn how it works on 2005 & 2000
http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx
http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx
January 18, 2010 at 5:38 am
Viewing 15 posts - 2,176 through 2,190 (of 3,221 total)