Viewing 15 posts - 10,426 through 10,440 (of 15,374 total)
Krasavita (10/9/2012)
int
Reason #91029037403884 you should ALWAYS use the proper datatypes. Datetime should ALWAYS be stored in a datetime column. Otherwise you end up pulling out your hair over something as...
October 9, 2012 at 1:39 pm
Krasavita (10/9/2012)
If I run WHERE (field1 > DATEADD(d, - 7, GETDATE()))get error:arithmetic overflow
What datatype is field1?
October 9, 2012 at 1:33 pm
Krasavita (10/9/2012)
No,but I needthis where field1 > DATEADD(d, -7, 'getdate()') and field1 <= 'getdate()
So you are all set then?
October 9, 2012 at 1:21 pm
maryjane9110024 (10/9/2012)
October 9, 2012 at 12:59 pm
raghavender.2369 (10/9/2012)
how to get the previous year value to do the calculation.
=FormatPercent((Fields!2002.Value) / (Fields!2001.Value), 2)
We don't know what the names of your columns are in your query and we can't...
October 9, 2012 at 12:55 pm
raghavender.2369 (10/9/2012)
yes.... by using expression we can do that... but i dont have idea to write expression to get that result... plz help me
You posted the formula and the example...
October 9, 2012 at 12:42 pm
Krasavita (10/9/2012)
I have a format for field1 example:20110228, I need to get all data from field1 that are within range 7 days from getdate and can't figour out how to...
October 9, 2012 at 12:29 pm
raghavender.2369 (10/9/2012)
Country 2001 2002 2003
ABC ...
October 9, 2012 at 12:15 pm
sqlSer12 (10/9/2012)
Thanks, I am going through your link.But we can pass the parameter for the function.
I put together an example of this using the quirky update method. Since you...
October 9, 2012 at 12:10 pm
Tripz (10/9/2012)
That is out of my scope, I just need to give the information what they were looking for.I think they were doing some network analysis..
For network analysis the number...
October 9, 2012 at 11:46 am
Tripz (10/9/2012)
My boss asked me to give the list of top 5 most queried database in our db server(Ms Sql Server 2005).
How can I achieve this? Any ideas, suggestions...
October 9, 2012 at 10:24 am
waqqas.zia (10/9/2012)
Unfortunately due to data protection issues im unable to post any of my data or even samples of...
i have however found a work around,
Thanks...
October 9, 2012 at 10:15 am
No it doesn't depend. It may appear to be ordered correctly right now but there is no guarantee it will always be in the correct order. If you want ordered...
October 9, 2012 at 9:54 am
Can you post ddl (create table scritps), sample data (insert statements) and desired output based on your sample data? I think once we can see the problem and have something...
October 9, 2012 at 9:46 am
jocast (10/9/2012)
In a query is it the sameselect * from customers (nolock)
and
select * from customers with(nolock)
is the word "width" necessary?
Better yet, remove it entirely. It is not a magic...
October 9, 2012 at 9:01 am
Viewing 15 posts - 10,426 through 10,440 (of 15,374 total)