Topics
Started by
Posts
Last post
how can I optimize this query please: select [Collateral ID], [DataDate], [Cif], [Collater…
4 replies
Hi All, Can i refresh view through linked server? I have full rights to modify the view? Ex…
2 replies
Hi all, i'm beginner with t sql and sql server 2008. i have a problem and i don't know how to solve…
4 replies
i have posted my Table structure below DECLARE @Mtbl AS TABLE (id INT,Rid INT, DATA VARCHAR(10)) D…
4 replies
Hi All, Can we Pass table valued parameters and normal params like integer,varchar etc..to a single…
1 replies
Hi Guys, I need help. Here is my Store Procedure, its a sample store procedure.. ALTER PROC [dbo].…
7 replies
(edit - updated exe plan and added new indices) Hi all, We have a non-performant view, usual story …
22 replies
I keep thinking this can be done in one query:UPDATE H SET Phone1 = NULL FROM Dialer.dbo.Agentless_…
5 replies
For code reuse, I am trying to get a table valued function to return users of a given AD group name…
7 replies
I have two tables. Table 1 has column "job", table 2 has column "job" and column "item". In table…
7 replies
Hi All, I've been experiencing difficulty with pulling records using a where clause date range. I'm…
18 replies
When I execute the below query i'm getting 801075 as result. How can I get 801075.003 as result? DE…
3 replies
Hi, I'm trying to get the difference between the two times in minutes with the seconds rounded up o…
5 replies
SSQL 2008 R2 1. Can someone explain why this is a happening? 2. How do I get past this error? If I …
6 replies
Now i Have not come accross the use of Where 1=1 before, strange it seemed to a colleague of mine. …
7 replies
Viewing 15 topics - 2,086 through 2,100 (of 10,647 total)
You must be logged in to create new topics.