Topics
Started by
Posts
Last post
Good day All, I am experiencing this error when trying to execute xp_sendmail: Server: Msg 50000, L…
1 replies
Dear all I have the following issue: I have a sql 2000 database. What i have to do is update anothe…
10 replies
By: SwePeso
I know that many are very passionate about how they write SQL code and that there are many styles t…
14 replies
By: Sergiy
I have a view that joins 5 tables - Sales and payment have about 1M rows - customer a few hundred t…
24 replies
By: Sergiy
I have a table with an ntext field that I need to pull only the first six lines of data (up until t…
8 replies
By: Sergiy
Good afternoon, I am struggling with what seems like it should be easy to do. I need a query,…
11 replies
Does anyone see a way that I might Improve/Simplify the following query? Declare @JOnum as char(1…
3 replies
Hi, i need help on this. i have a table A in SQL SERVER DATABASE in which i want…
2 replies
Hi, i need help on this. i have a TableA which has the following two column and …
2 replies
Hi all, I want to Get the Varchar Column in the Group by. Example: Employees Table: EmpType E…
1 replies
By: upalsen
The query below works fine, but I want to exclude all the databases that do not have a certain tabl…
4 replies
By: Ghanta
I saw a lot views created by some contractors that it all had CREATE VIEW vw_test AS SELECT TOP 100…
4 replies
Hi all, I have this wierd challenge to accompalish this but somehow not able to figure it out. I ha…
5 replies
i have a table lets say table1(id,name) i need to select distinct id from table1 but the distinct…
11 replies
I have 4 different tables that contain descriptivie information; Orders, Receipts, Adjustments and …
5 replies
Viewing 15 topics - 4,876 through 4,890 (of 17,082 total)
You must be logged in to create new topics.