Topics
Started by
Posts
Last post
Suppose I have one table that contains 10 columns and all can accept null value. Suppose there are …
5 replies
I have a large stored procedure that populates about 6 tables. It creates, populates, and uses many…
7 replies
Hi, I have 2 tables with the very same LONG structure (table_1 and table_2). I was wondering if it …
14 replies
Hello All, I need to create transactions to either add or remove items from a list. The transactio…
7 replies
Hi I am trying to get result as (in actual, lot of columns) ILE.[Item No] Item.[Item Name] ILE.[…
12 replies
I have the following query in a variable, the result of the select is a value and i wannt it to be …
5 replies
I've got some stored procs that aggregate large datasets and return roughly 18-200 rows (an 18 mont…
5 replies
Hi All, I'm having a problem constructing a SQL Server 2008 stored procedure and any help would be …
3 replies
This SQL (or a version of it) used to work for me. To perform MASS delete's, this SQL would increm…
2 replies
USE tempdb /***************************************************************************************…
5 replies
Hi All, I am trying to use this select statement: select * from [MCM_DQ_PASS1B].[dbo].[View_Pass1bA…
10 replies
I have the following sample data and need to know the following. --Data I have to work with -- CREA…
10 replies
We download to a system that supports limited ascii (US) character set. I've added some translation…
3 replies
hi, IN TRY...CATCH processing you can nest or have multiple TRY...CATCH blocks in your code. The …
8 replies
Hi guys n gals, I have a table with Company records and a linking table that defines relationships …
27 replies
Viewing 15 topics - 7,441 through 7,455 (of 10,635 total)
You must be logged in to create new topics.