Topics
Started by
Posts
Last post
Hello, I have the following question: When I execute a SELECT statement, the query shows a number o…
1 replies
Had an interesting problem last week with a .Net Application was showing the result set of a SP in …
1 replies
I have a table with two columns. ITEM QTY B0-001 100 B0-002 50 B0-003 25 B0-001 …
3 replies
Im wondering if there is a better way of copying data than the way Im thinking of doing in this cas…
9 replies
Does anyone have a query that shows how much TLOG space is being used by spid? It looks like all t…
1 replies
is there an updated approach on how to use the COALESCE keyword? Or if there is a NEW keyword that …
7 replies
Hi I have view which gives me below output but i need to replace 0 with last non zero value. At pr…
1 replies
Hi, Need some help with a join. In the code below there are two tables. table tempAccount holds dat…
5 replies
I Select some data with: SELECT * FROM custom.Routing WHERE @var LIKE Number + '%' Field Number con…
7 replies
I have two tables which I want to return the sum on a value. Table 1 wh,item,stock 01,P1,1 02,P1,1 …
7 replies
Hi, I did not get what is wrong with the below piece of code? declare @VERS numeric(2,2) set @VERS …
1 replies
Hello, My task is to show what position someone is in (eg office, job level (ie consultant, manager…
2 replies
I have changed our interactive_timeout and wait_timeout connections from the default value to 30 se…
1 replies
I currently have the task of rewriting some poorly-written sprocs. I've just been to SQL Saturday,…
7 replies
SELECT glbank.check_num , glbank.ref_num , glbank.check_amt , glbank.check_date , glbank.bank_code …
12 replies
Viewing 15 topics - 2,641 through 2,655 (of 12,234 total)
You must be logged in to create new topics.