Topics
Started by
Posts
Last post
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
I am using BIDS with SQL 2008. I need to include the Initials of users even if there is a 0 count. …
2 replies
Hi, I have the following sample data: create table #trades (tradeId int NOT NULL, parentTradeId int…
9 replies
I have been given a data dump from a 3rd party system we use that allows employees to report work t…
16 replies
Viewing 15 topics - 9,046 through 9,060 (of 10,647 total)
You must be logged in to create new topics.