Topics
Started by
Posts
Last post
plz..........help any one .....how to import data from excel file to sql server database
3 replies
Hi, Bit of a long shot this one. I have a requirement to replicate some of the Excel Solver functi…
3 replies
Would anyone be able to assist with the following? I'm trying to retrieve the highlighted line... b…
9 replies
Hi All, I have a data something like below... <Fields> <Field Name="String 1" /> &l…
3 replies
Hi, I'm making a procedure which parses Excel worksheet and uses that data to update db. I've run i…
3 replies
Hi, DECLARE @FILE VARCHAR(50) DECALRE @x VARCHAR(8000) SET @FILE='C:\ABC_'+(SELECT CONVERT(VARCHAR(…
2 replies
SELECT BloggerName,Topic,[Year],Total, Rank() OVER (Partition by BloggerName Order by Total DESC) a…
3 replies
Hi, I need ur kind help on the attached xl. Thanks, Rajesh N.
2 replies
Hi, Is it possible to have freetext or contrains find text for a broken partial word e.g. with like…
1 replies
I have a table with Int Column, sample table with data like bellow ItemID, Name, Quantity ---------…
2 replies
Hi, I am trying to get a set of count results from about 80 bit fields in 1 table of about 250k row…
2 replies
Hi I am trying to get the following to work so that it only selects the row with the maximum errid…
5 replies
I am working on an SSIS package that uses sp_MSforeachdb to run sp_helprotect and load it into a ta…
1 replies
I'm using sp_send_dbmail to send the results of a query to my my users. No problems with that, but…
4 replies
My query: select ISNULL(B.UnitsSold,0) as UnitsSold from(SELECT TOP (100) PERCENT UnitsSold, …
6 replies
Viewing 15 topics - 9,031 through 9,045 (of 10,635 total)
You must be logged in to create new topics.