When I want to get paticular byte from binary/varbinary variable I use 'substring' function, but how to stuff byte on pointed position? ...more >>

Hi, I need some help quite urgently. I have a job which fires off about 10 DTS packages to run. 2 of these packages are very similar, they basically import and process about 200,000 rows of data. The total time for all jobs to run can be up to 2 hours. My problem is that of the 2 jobs...more >>

Hello, I have the following syntax in my routine where I am trying to select based on criteria to match records and then set the variables to the original amounts - but it appears to be going to the last record and putting that amount in the variable - my question is - am I missing some par...more >>

Can someone help me determine why my subquery below is not totaling. Without having to dig to deeply into the logic and data, I am hoping that seeing the working/non working versions together might reveal something obvious. I have removed the other selected columns from the main query. I ha...more >>

Hope this is not considered spam. I just want to help out friends who are currently seeking jobs. My company is looking for a Web developer. Here is the information: Software/Web Developer Position (Local Candidates only) An investment firm in downtown Los Angeles is looking for a softwa...more >>

Hi, SQL Server does not like my stored procedure below. It complains about the GRANT EXEC line What am I doing wrong? JD ----------------------------------------------------- DECLARE @PROCNAME varchar(50) DECLARE cPROCNAME CURSOR FOR SELECT NAME FROM SYSOBJECTS WHERE XTYPE =...more >>

Hi, Please find the scripts you will need to create the table and sample data on your end at the bottom of this post. The table I'm posting here is used to store activities our employees perform pertaining to our projects i.e. contracts. We've defined activities in our system and each a...more >>

Hi, I want to post a question but I want to also include a script for you guys to create the table on your end as well as some sample data. I used to have a tool that would take the data in a table and generate a bunch of INSERT statements. I can't seem to locate it. Could someone please ...more >>

Hello, This question was also posted in the English Query Language group, but can't find a was to move it here. So sorry for the double. My problem: I have two tables. One is an export from a different database and one is the destination table. The Export table looks something like t...more >>

Hi Community, I think I can store Binary Data in SQL Server but when I try to retrieve it, I always only get one byte. I think I stored my Binary Data in SQL Server in a Colum of Type Image. At least when I execute the following code, I get some significant network traffic. When I check ...more >>

LOAN +---------+---------+-----------+---------------+ | loan_id | cust_id | librarian | checkout_date | +---------+---------+-----------+---------------+ | 1 | 1 | Jim | 7-11-2005 | +---------+---------+-----------+---------------+ | 2 | 2 | Jim | 7-11-...more >>

Hello, Windows forms & database What are the considerations when choosing how to display reference information from the calling form? What is recommended? Table1 is the parent of Table2. Form1 allows data entry into Table1. Form2 allows data entry into Table2. Form1 (the parent) ope...more >>

Hi, I am adding a row to my table with the code below. It seems to be inefficient to me as I have to basically build my command with the string builder. There has to be a better way, no? What I am trying to do is to search my table for the 2 variables ln1 and ln2. If they are not found, the...more >>

Hello, I am building an application for Windows Forms using. I am new to SQL Server 'Views'. Are the following correct understanding of their use? 1.) I believe a view can be referenced in a stored procedure something like this; Select * from View1 Is that true? 2.) I believe I can upda...more >>

Hi I wrote a Delphi program to create a dll.after that, I added an extended procedure to sql server using this dll. unfortunately this extended procedure is too slow ( for excution on a table with 100000 rows, it takes 1 minute to finish the extended procedure) . I recognized that the lack o...more >>

Hi All In my report there is a dynamic matrix. two section inside the data region need to be paint in two different color. i defined an Expression in the background properties. the Expression define two ranges(four cordinates) in order to paint one section and more two ranges for the other ...more >>

I have a field That includes records like this (1)(2)(3)(4)(5) (1)(2)(6) I want to split this values 1 , 2, 3,4,5 like this and i want to find out ubound of these array ? How can i solve it ? ...more >>

I need an Insert trigger to generate new tables when i insert a new record.. new tables will be "MasterSub_[ID]" where ID is the id of new inserted parent record.. I also want a delete triger to remove child table if it has no data in it.. Any help plz?? ...more >>

Hi, i was wondering if someone could help me. When one detaches a database via sp_detach_db, all the transactions in the ldf log file are commited to the mdf file right? After this is done, i delete the old log file and then do a: EXEC sp_attach_db 'pubs', 'd:\Data\pubs.mdf' But how ...more >>