Topics
Started by
Posts
Last post
I have a Stored Procedure and the boss is going thru making SELECT STATEMENTS Dynamic now... So I s…
6 replies
Hello All, Do you find anything wrong with this statement?: (CASE WHEN t.ItmRecvdYR1 > t.Itm…
12 replies
Hello, I'm new to the forum and need some help. I want to compress (collapse) number rows, see the …
17 replies
Everyone, we have an important legacy lob attribute that stores well formed and also malformed xml…
1 replies
Hi, I would like to understand how the Alias works when you are using an Update Statement with the …
2 replies
Hi All, Is there any script (or any other way apart from manual) which can tell me whether a databa…
9 replies
When I was trying what kind of construction TSQL in SQL 2008 would allowed I came at this stupid co…
1 replies
hi friends whats wrong with this : CREATE PROCEDURE [dbo].[LoadGalery] (@rowNumber INT) AS BEGIN …
8 replies
hi why this raise error ? SELECT * FROM ( SELECT *,ROW_NUMBER() OVER(ORDER BY Name DESC)AS 'RowNum…
3 replies
I'm a T-SQL basic for about 1 year. now i am solving for crosstab report, so i try to use cursor wi…
9 replies
In my table, I have count rows within a segmentID who have a formula, that formula will create the …
4 replies
I'm using SQL Server 2000... ok, so my outer query creates the [next pay date] using the tally tabl…
16 replies
Your thoughts regarding this script, its performance and also feel free to optimize/comment... Than…
5 replies
Good day, I am relatively new to triggers. I thought I new what I was doing (first mistake) until a…
6 replies
I have the following table: CREATE TABLE [tblPnParamValues1] ( [ValueID] [int] IDENTITY (1, 1) NO…
6 replies
Viewing 15 topics - 2,266 through 2,280 (of 17,082 total)
You must be logged in to create new topics.