|
|
-
Bert incorrect 6 Months ago through Just Learned
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
<pre style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(http...
|
-
Bert Liked 8 Months ago through Just Learned
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
Initially thought it's like a cheat code. But its about mastering the basics. In ...
|
-
Bert Learned 8 Months ago through Just Learned
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
Initially thought it's like a cheat code. But its about mastering the basics. In ...
|
-
Bert Commented 9 Months ago through Just Learned
You can also write an aggregate function with .Net ......
|
-
Bert Commented 9 Months ago through Just Learned
You can also write an aggregate function with .Net ......
|
-
Bert knew 9 Months ago through Just Learned
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....
|
-
Bert knew 9 Months ago through Just Learned
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....
|
-
Bert Commented 9 Months ago through Just Learned
with ids as
(
select groupid,ROW_NUMBER() over (partition by groupid order by memberid) as id,cast(val as bigint) as val
from dbo.Groups
)
,maxid as
(
select groupid,MAX(id) as id
...
|
-
Bert Commented 9 Months ago through Just Learned
<pre><code>
with ids as
(
select groupid,ROW_NUMBER() over (partition by groupid order by memberid) as id,cast(val as bigint) as val
from dbo.Groups
)
,maxid as
(
select groupid,MAX(id) ...
|
-
Bert Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|