Topics
Started by
Posts
Last post
I have an application that I want to convert to a Web app. The Web needs a common ID to log in whic…
1 replies
Hi! I've really exausted all the options and i need help to solve this problem. I have a Query buil…
4 replies
Hi, I have to process a huge xml file and I wanted to split the file into multiple xml files. Can s…
2 replies
I have a table that has over 300 million rows. I would like to delete 2010 data. However i don't wa…
6 replies
Hi, I am using SQL 2008 R2 x64. I have a table lets say called "ParentTable" and a "ChildTable" whe…
3 replies
Is there a way to get mulitple counts from the following script: Select Count(FirstCommunityChoice…
3 replies
I have the following Access 2007 Query and I am trying to translate it to TSQL: SELECT tblApplicant…
6 replies
Hi, I found this online: DECLARE @strValues varchar(8000) SELECT @strValues = COALESCE(@strValues+'…
6 replies
The following sql statement gives this error: Msg 102, Level 15, State 1, Line 20 Incorrect syntax …
6 replies
Hi guys. Someone please explain me what this outer apply is doing. I mean outer apply is used to jo…
2 replies
I have a table called membership which contains memberID, effdat, expdat. When a member's membershi…
6 replies
Hi, I have to insert records from my source sql to tmp table. below is my source sql with actuals …
2 replies
Can someone explain how the below result arrives please ? with CTE(x)as ( select x = 1 union all s…
3 replies
Hi, I need help from gurus here on how to transform a table with parent and child column to a horiz…
2 replies
The SELECT query below returns the desired resultset but it has to "look back" at the data to find …
10 replies
Viewing 15 topics - 8,356 through 8,370 (of 10,647 total)
You must be logged in to create new topics.