Topics
Started by
Posts
Last post
Hello Fellow SQL nerds, I want to be able to open a file in a sql script. First I select data via a…
7 replies
Him Im using the following code to "replace" a value in a textstring that contains XML... It comple…
2 replies
Hey all, Should be a simple one, but it's bugging me I can;t get the correct syntax. Here's an over…
3 replies
Hi All, I have to display NULL in the last row eventhough the query which has ORDER BY clause. Note…
30 replies
I get the following error when trying to update data in a table variable: Server: Msg 137, Level 15…
2 replies
I have a function like this: -- determine if there is already a page with sequence one, i.e. whe…
16 replies
CREATE PROCEDURE proc_lastSale AS set ANSI_NULLS ON set QUOTED_IDENTIFIER ON declare csr_db cursor …
3 replies
Hello all, Long time lurker, first time post. I'm looking for a bit of help with a query the table …
1 replies
Hi, why doesn't this bring back Dec 31? I am building an Amortized Table of Loans, and this particu…
40 replies
Hi All, I have a following statement: ItmRecvdYR2=ISNULL((SELECT SUM(Quantity) FROM dbo.GetAllR…
17 replies
Hi I have a table A ---------------------------------------- Date 1M 2m 3m 4m -…
10 replies
Hi All, I have the below scenario. select convert(varchar(30),convert(decimal(18,4),234543242.76564…
13 replies
We have an application from a external provider and we have getting this error in our company, when…
1 replies
By: Ronald H
Hi All, I need to use sql script. How to get a table fieldname, field type, field size, and maximum…
1 replies
I have a table of events - holidays and vacations, actually. Each event has a date and label. I wan…
3 replies
By: dongadoy
Viewing 15 topics - 2,176 through 2,190 (of 17,082 total)
You must be logged in to create new topics.