|
|
-
Hardik Doshi Learned 7 Months ago through Just Learned | 1 Point
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporar...
|
-
Hardik Doshi Learned 8 Months ago through Just Learned | 1 Point
I am working a Data Quality Services Demo where i had to figure out how to write a domain rule to validate a email address. for this task, i re-learned how to write a regular expression; here's my basic version: [A-Za-z0-9._-]+@[A-Za-z0-9.-]+.[A-Za-z...
|
-
Hardik Doshi Learned 8 Months ago through Just Learned | 1 Point
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
.userprofile
{
color: #36c;
font-size: 12px;
font-weight: bold;
text-decoration: none;
}
.userprofile A:VISITED
{
color: #039;
font-size: 16px;
font-weight: bold;
text-decoration: none;
}
.userprofile A:HOVER
{
font-size: 16px;
font-weight: bold;
text-decoration: underline;
}
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
in Microsoft word 2010 there is a functionality to directly insert a screen shot of a open application which is not minimized. This can be done from insert->Scrennshot.
There is also a provision to add a screen clipping, if we want only part of sc...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
in Microsoft word 2010 there is a functionality to directly insert a screen shot of a open application which is not minimized. This can be done from insert->Scrennshot.
There is also a provision to add a screen clipping, if we want only part of sc...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for ...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for ...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
Hi,
Just now i Wrote one query to remove special characters from a string..
Hope this is useful.
DECLARE @I VARCHAR(100)
SELECT @I ='abhi *s d ^.l'
WHILE PATINDEX('%[^A-Za-z0-9 ]%' , @I ) <> 0
BEGIN
SELECT @I= STUFF(@I,PA...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
Hi,
Just now i Wrote one query to remove special characters from a string..
Hope this is useful.
DECLARE @I VARCHAR(100)
SELECT @I ='abhi *s d ^.l'
WHILE PATINDEX('%[^A-Za-z0-9 ]%' , @I ) <> 0
BEGIN
SELECT @I= STUFF(@I,PA...
|
-
Hardik Doshi Learned 9 Months ago through Just Learned | 1 Point
Yesterday night, I was reading Inside Microsoft Sql server 2008: Programming - Itzik Ben-Gen. On Cursors section Page number 291, he has tried to explain the scenario for calculating multiplication on row wise manner. He has explained through cursor....
|