Topics
Started by
Posts
Last post
Hello Everyone, I need some help in creating a SQL query to identify ONLY the first absence of the …
2 replies
Hi, I have to create a UDF for validating phone numbers from a staging table to another table with …
3 replies
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
Viewing 15 topics - 2,926 through 2,940 (of 12,234 total)
You must be logged in to create new topics.