Topics
Started by
Posts
Last post
Hi , I am trying to pull out records for sql agent job for detail of its last run, successfull/fail…
3 replies
Hi members, I am trying to add a second condition in my case stmt that compares value in PC_PHYSICI…
4 replies
Search from a column where values contains once space and after then any character other than space…
1 replies
set nocount on DECLARE @AlterAuthorizationStatement nvarchar(MAX) , @Statement nvarchar(MAX) , @S…
13 replies
I have have a parameter in a stored procedure which I wish to use in the WHERE clause of a SEL…
6 replies
I need to copy a lot of data to a lot of tables so I decided to generate the queries and pass them …
3 replies
Hello everyone. I have a table that tracks meter information and I need to divide the field by 2.1 …
5 replies
Hi, I ran into an UPDATE statement in code that I never saw before, and strangly it works! first, l…
5 replies
Hi All, I need to convert the below Excel formula into sql format. {=(PRODUCT(1+$G4:G$6/100)^(12/CO…
26 replies
Dear Forum, I hope someone knows the trick. In a rather complicated computation, I use a table-valu…
29 replies
I have a result returned from a query that is the result of a join. I need to make the results rows…
46 replies
Unmask the data in XML Suppose there is a word 'Brilliant' in XML, look for 'Brilliant' in lookup t…
4 replies
DECLARE @p1 INT DECLARE @p2 INT SET @p1 = CAST((SELECT (col1 + col2) FROM #STOCK WHERE DAYSTOEXPIRY…
8 replies
I've tried a few variations of this, but the error is when I start my from statement: i.e. this is …
4 replies
Rather than posting all of my failed queries, I'll just show what I'm trying to do. auctions fields…
2 replies
Viewing 15 topics - 121 through 135 (of 17,077 total)
You must be logged in to create new topics.