Search results for query: *

After I added aliases to the NoteID, NoteName, usename, and sourcename the query worked fine...Thanks guys

Here is the query that I'm attempting to write: SELECT NoteID, NoteName, SourceID, UseID ( SELECT n.NoteID AS NoteID, n.NoteName AS NoteName, NULL AS SourceID, NULL AS UseID FROM tblNote n INNER JOIN tblProduct p ON n.ProductID_F = p.ProductID...

Thanks RocSky...I'll try that out tonight

I have a adbo 7.0 pdf file that is not allowing me to save changes. Message I get is "You cannot save data typed into this form. Please print your completed form if you would like a copy for your records." Is there any way that I can override this setting and save this pdf file? Thanks.

Just read your post E-Squared. I'm doing the import thru enterprise manager. Is that what you wanted to know? What does text to column do? I did exactly what you recommended till text-to-columns. Will try it again and let you know the results. Thanks.

Thanks for the help, Skip. Can you recommend a book that teaches VBA?

Thanks for the reply, Skip. That worked. How would I be able to add a trailing space programmatically to the Zip column as there are thousands of rows? Thanks.

In an excel sheet, there is a zip code column. The data type of that column in excel is General. The zip code can have letters as it contains international zip codes. After importing the data from excel into a sql server table, the zip codes that don't have any letters have a value of NULL...

How would I shorten this query by using aliases? DELETE tblEventContacts FROM tblEventContacts INNER JOIN @Contact C ON tblEventContacts.ContactID_F = C.ContactID WHERE tblEventContacts.EventID_F = @EventID AND C.Removed = 1 UPDATE...

Thanks Denis. I was able to resolve the issue with your previous reply in the post: thread183-1361784

When I run a query w/ an Order By clause the results are correct. However, when I insert that same exact query in a temp var table and SELECT * FROM temp var table the results are not correctly ordered. The code in its basic form is: INSERT INTO @DealInfo SELECT ... FROM .... WHERE...

whats the shortcut key to have the html code properly formatted in an aspx page? thanks.

If I have these lines of code: tdsReportData.ReadXml(SessionFolder & "ReportData.xml") tdsReportData.WriteXml(SessionFolder & "ReportData.xml") This error comes: Access to the path "C:\LOG_FILES\ReportData.xml" is denied Is that because tdsreportdata (dataset) is still holding...

I had to write a query that would figure out the Amount depending on the order of Position Order and Priority. Logically, I understood what I had to do in order to figure out the Numerator, but it took me some time to write the query. CID NID Order Priority Amount Numerator 101 2001 1 1 1000...

Thanks, Alex and George.

Oops, I asked the wrong comparision..whens the appropriate time to use table vars compared to derived tables or what are the ads/disads of table vars to derived tables? sorry about that.

Whats the difference between using a derived table and a temporary table? temporary table eats memory and slows down performance?

Worked perfectly, George.. Thanks for your help. Using the derived table the performance time of the sproc was 2 seconds.

I see what you mean, George... By using the derived table, I would eliminate having aliases in the case statement of the order by clause. Unfortunately, when I tried using the derived table, there were errors with the aliases in the from and inner join table in the sub query stating that the...

still stumped... Here is the order by query that I'm working with: CASE @Outputformat WHEN 'Test1' THEN LInitials ELSE Orig END, ControlID, LPOrder, Priority, SumAmount desc, NName LInitials and Orig are fields that are aliased in the select clause. The sproc compiles...