Topics
Started by
Posts
Last post
Hello, I have a table with one column, which contains distinct data. Some of the data is missing. N…
4 replies
Hi. I have developed quite a few reports but have not yet mastered allowing a user to SELECT 1 or m…
1 replies
i have a tables like : this table have the columns: ----------------------------------- prioriy tab…
4 replies
I need to build a query that gets manger info for an employee, sounds simple, but now it gets inter…
4 replies
Hi there! I was hoping someone could please help me with my syntax. I'm trying to put a nested whe…
13 replies
I'm new to using the tally table, and I'm sitting here dumbfounded trying to come up with a way (us…
12 replies
I need to pull just one area code/phone # for each customer. The challenge I'm facing is that some …
3 replies
Insert trigger Table A Col A ColB A 12 B 12 C 13 D 15 t…
1 replies
Hello together, i want to create a table where the source code of all my objects will be stored his…
13 replies
Hi All, How do I create a trigger based on time. For example, I have a date/time column in my t…
6 replies
I am trying to write to a temp table, which will then be BCP'd to a flat file, I have a potential o…
1 replies
USE TEMPDB GO CREATE TABLE T1 ( id int not null, val char(1), STAT tinyint ) GO CREATE TABLE T2 ( i…
2 replies
SELECT SCD.SALESREP_NAME AccountOwner, CA.ACCOUNT_NUMBER AccountID, CA.CUSTOMER_ACCOUNT_NAME Accoun…
14 replies
I'm using a Group By statement to count items, such as the statement below. It works, the only prob…
8 replies
We have an application that allows a user to manage events. Each event has an associated region or…
4 replies
Viewing 15 topics - 5,371 through 5,385 (of 12,234 total)
You must be logged in to create new topics.