Topics
Started by
Posts
Last post
Table Rowointer Notes ------- --------- Row0001 TestNotes1 Row0002 TestNotes2 Row0003 TestN…
4 replies
I want to update the PO table with the BuyerName if there is a Buyer record exist. In below example…
2 replies
Hi, I inherited a few stored procedures that use cursors to build create table statements, reading …
8 replies
Hi , I am confused I had seen a rather long query in SQL profiler its all on one line and I ran it …
5 replies
Is there a way to structure a single query to select all the unique values from field 1 of table A,…
1 replies
SELECT * FROM [dbo].[REPORT_NOTES] AS Rptn results in one record. A column called INV_NUM with a va…
4 replies
I got asked to do this today, with some generic country data. Here's what I did: begin tran declar…
7 replies
DECLARE @mv_mark varchar(500), @ob_mark varchar(500), @tot varchar(500), …
7 replies
I would like to select distinct values from 1 column in my query. If I was selecting just 1 column …
2 replies
I must be having a "senior moment" (no insult intended), because I just can't figure this one out. …
6 replies
Create table TableA ( col1 int indentity(1,1), col2 varchar(10), col3 int ) insert into TableA v…
2 replies
I want to create a stored procedure where the output will to into an Excel spreadsheet that will ha…
3 replies
Hi All, I am trying to format an auto-generated email from SQL into HTML, i've sussed a bit of it …
3 replies
I have a table with schema that looks like this Year, Jan, Feb, Mar, Apr, May,June, July, Aug, etc.…
3 replies
Hi Freinds, Suppose i had started create/alter index process. how can i know remaining time to fini…
2 replies
Viewing 15 topics - 631 through 645 (of 12,234 total)
You must be logged in to create new topics.