Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS - ERROR Handling
Hello I have following problem. I create an DTS. In the DTS I defined an OLE-DB -Connection and an SQL-Task. The syntax from the SQL-Task is very simple e.g. 1. update XX set field = '' ..... 2. execute STORED_PROCEDURE 3. update XY set field = '' ..... When I execute the DTS and the... -
Stored Procedure - variable DB-Name!
Hello I have an Stored - Procedure with many Select's. It is possible in an SELECT - statement the DB-Name variable to define? e.g. DELCARE @DB_Name nvarchar (50) SET @DB_Name = 'TEST' if exists (select * from @DB_Name.dbo.table) ..... Thank's- CW1
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Grid / Cache...
Hello! I have an SQL-Table with 115.000 Record's. In my VB-program i will show this Record's in an Grid. I use a ADODC-Controlpanel with an simple SQL-command. When I start the VB-program i must wait a long time. I try this situation to change the Cachesize property. But that have no effect. I...- CW1
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
establish priorities!!
Hello ! I try to add more detail's for my problem. I have a VB-Program which call a "Stored Procedure" on the SQL-Server. The "Stored Procedure" have one Select with many SUM(xxx) and wrote the result into a new SQL-Table. This procedure work's 2 minutes. At this time the... -
establish priorities!!
Hello! When I start a SQL-Statement (SELECT SUM(..) 500.000 Record's ) on a PC and i will work on another workstation (Select ... 5 Record's ) I wait for a long time that i get the result. Is there any possibility that I establish a priority?? Thank's -
CREATE PROCEDURE......
Hi! Who can help me? I have an SQL-Server with a table where contain's many record's. The Record's are prepared so that when I make a select I have a full Stored Procedure.<br>My version to create the Stored Procedur is:<br>I make the select and with the DTS - function I create a TXT File. Then... -
SQL (Rollup and Having)!
Sorry but by description was not so good!<br>I will not sum nulls. I think my problem cannot work with HAVING and ROLLUP because HAVING exclude the Group - Sums.<br>Two example's:<br>1. Select Fb, Sum(Wert) WHERE... Group By Fb with Rollup<br>Result... -
SQL (Rollup and Having)!
Hello!<br>Who can help me?<br>Sorry but my english is not so good. I have a small problem.<br>My Select:<br>"Select Fb, SUM(Wert) as Wert WHERE ... GROUP BY Fb WITH ROLLUP HAVING SUM(Wert) between 100000 and 200000 ORDER BY Fb"<br>Result:<br>001 100012<br>003 199999 ....<br><br>Without...
