Topics
Started by
Posts
Last post
I'm tasked with importing a file into a server on a daily basis. Currently they are using OpenRowSe…
3 replies
Hi, I need advice on to upgrade one of the small system from 2000 to 2008. Should I go ahead with…
3 replies
I have a query which returns duplicate date in 1 column as such (c1 = Column 1; c2 = Column 2) TABL…
5 replies
I have a text file with no column headers in a network location. filename is clients.txt. it has 3 …
8 replies
select gender,amt,age,[address],class , Case when gender= '' then 'gender,'when gender is null then…
2 replies
I've been trying to use the PIVOT function but cannot come up with the right syntax. Given the foll…
4 replies
I have a table diagramed as follows: UserName ColumnA ColumnB Date/Time Tom …
4 replies
I need to count the number of rows from a few joined tables. A normal SELECT COUNT(*) doesn't work…
4 replies
Hi, I need to have summary by coulmns and by rows for pivot table. Is it possible? And how ? Thanks
3 replies
I have a table with some transaction counts. I want to get a list of the most recent transaction co…
7 replies
Please help me to create XML as below format using for XML Path. <Root> <R Id="10000004…
2 replies
Hello, I have created a SQl function that pulls up the concatenated text from the select query. The…
9 replies
Hello there, I want to call a SSIS package which is stored in file system (\\srtb03.dr.infosir.com\…
2 replies
I've got a table that is populated from the OUTPUT from an update statement: declare @Update TABLE …
50 replies
Hello I have two queries whose results are inter connected. The result for Query 1 is input to the…
18 replies
Viewing 15 topics - 2,926 through 2,940 (of 12,230 total)
You must be logged in to create new topics.