Viewing 15 posts - 2,131 through 2,145 (of 6,401 total)
patilpallavi16 (10/1/2015)
I am still a student and learning. Can you tell me the answer plz.
A number of answers have already been given above.
If these don't suit you needs please post...
October 1, 2015 at 6:17 am
You may want to look at the following then
http://www.keepitsimpleandfast.com/2011/09/localization-of-your-ssrs-reports.html
This is how I do it in one report
October 1, 2015 at 5:35 am
How are you rendering in different languages? Multiple copies of the report for different languages?
October 1, 2015 at 4:44 am
You cant do 0000-00-00 in any date field, if thats what you need I suggest CHAR(10)
If you need it in a DATE datatype column the lowest value you can do...
October 1, 2015 at 4:21 am
Not an Oracle guy myself, but I am guessing its something to do with "true" needing to be 'Y' or 'N', guessing Oracle isn't converting true to Y as its...
October 1, 2015 at 3:35 am
itumelengd (10/1/2015)
Try the code below, always try to keep your code simple:WHERE YEAR(roofyearbuilt) - 1991 > 17
As per a different post, putting functions around columns in a where clause makes...
October 1, 2015 at 3:12 am
itumelengd (10/1/2015)
SET @bestdatum = '2015-09-21 15:49:28'
SELECT YEAR(@bestdatum) Year
,MONTH(@bestdatum) Month
,DAY(@bestdatum) Day
...
October 1, 2015 at 2:35 am
crookj (9/30/2015)
Ed Wagner (9/30/2015)
DonlSimpson (9/30/2015)
Ed Wagner (9/30/2015)
anthony.green (9/30/2015)
Ed Wagner (9/30/2015)
anthony.green (9/30/2015)
whereisSQL?(9/30/2015)
PourPitcher
Beer
Brew
Pub
Bar
Prohibit
Disallow
Explicit
October 1, 2015 at 2:16 am
What do you mean by change the database?
Is this going to go into a stored proc?
Is this a one off ad-hoc query?
October 1, 2015 at 1:50 am
A backup is not an mdf its a bak.
If you need the mdf, restore the database and detach it from the server and point to the restored mdf file.
Out of...
October 1, 2015 at 1:47 am
Sounds like a kerberos issues.
Are all the servers in question running their services via AD service accounts? If so have they all been trusted for delegation?
October 1, 2015 at 1:43 am
You have not qualified your string on the @firstname as nvarchar when passing it to the stored proc
EXEC@return_value = [dbo].[SelectPerson ]
@First = N'??',
@Last = NULL,
@Address= NULL
Also take a look at...
October 1, 2015 at 1:40 am
I was also looking at https://msdn.microsoft.com/en-GB/library/gg492084.aspx which disproves the answer.
October 1, 2015 at 1:34 am
Ed Wagner (9/30/2015)
anthony.green (9/30/2015)
whereisSQL?(9/30/2015)
PourPitcher
Beer
Brew
September 30, 2015 at 8:25 am
Viewing 15 posts - 2,131 through 2,145 (of 6,401 total)