Viewing 15 posts - 10,426 through 10,440 (of 15,381 total)
Fantastica (10/10/2012)
http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/%5B/url%5D
Even has an example of how to make sure that any other columns of data...
October 10, 2012 at 7:56 am
Gianluca Sartori (10/9/2012)
Sean Lange (10/9/2012)
Gianluca Sartori (10/9/2012)
Sean Lange (10/9/2012)
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...
October 9, 2012 at 3:25 pm
Gianluca Sartori (10/9/2012)
Sean Lange (10/9/2012)
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...
October 9, 2012 at 3:11 pm
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
Viewing 15 posts - 10,426 through 10,440 (of 15,381 total)