Topics
Started by
Posts
Last post
I'm need help with a query. The table has an id, a name, and a type. Sample: ID Name …
2 replies
My sample XML is: Some Value1 Some Value2 some Value3 some Value4 Some Value5 …
7 replies
Hi I run the same query against two DB, one is the publisher and other is the subscriber. The two D…
6 replies
HI, i got one doubt ... SP_SPACEUSED 'table' the above statement can produce some data... how can i…
1 replies
in Which Sensory we use CTE
2 replies
Hi, I found a view using a "bad practices example" query and I can't understand the results it give…
8 replies
Here's the issue/problem: I've got a reference table with a list of software 'products' I've got a …
2 replies
SELECT DISTINCT TOP 40 A.INV_ITEM_ID ,SUM(A.QTY_REQUESTED) AS QTY_REQUESTED ,ISNULL((SELECT SUM(B.Q…
2 replies
The following can be pasted into SSMS so that it is both more readable, and easier get your teeth i…
24 replies
So, I am writing a view and I want it to be an indexed view. The first query I wrote is: SELECT P.…
3 replies
Hi, We are using Soundex function too find near matches. Its works fine for English language as its…
1 replies
How do you check if the value is a whole number? declare @a int, @b-2 int set @a = 7 set @b-2 =…
9 replies
I know I've seen this somewhere before but just can't remember where it is and how to write it, ba…
7 replies
i get values in a coulmn NAME (- column name) as rows i need to get the output in a single line Exa…
1 replies
I have been collecting performance data through Typeperf. I'm trying to create a pivot table for re…
9 replies
Viewing 15 topics - 556 through 570 (of 12,234 total)
You must be logged in to create new topics.