Topics
Started by
Posts
Last post
Hello – I currently have an SSIS package running and the first part of it deletes all data in (Tabl…
3 replies
I have the following sql: SELECT Id, Name, CASE ( (SELECT SUM(Revenue) FROM myTable WHERE…
8 replies
I've just started to use CTE's to concatenate individual row values into 1 field and I'm liking the…
26 replies
I am using sql server 2005 The filed r_resume_text data type is text When i run the Below query i …
2 replies
Hi, I have a project I'm working on that has two SQL tables. I need to create a query that joins th…
5 replies
i need to insert records from table1 to table 2 out of 15 columns from table1 i need to insert 6 …
3 replies
i have table with horizontal records , which i need to insert in another table as vertical records …
7 replies
select isnull(id,0)+1 as ID from TABLE1 i have the id field blank with defualt value as 0 but when …
6 replies
Hi All, I'm a real newbie in SQL. My job demands me to learn it which I found out to really attract…
13 replies
I want to read through an xml document with a loop. I've removed the extraneous code. I get this …
6 replies
I'm just not sure how to do it. When I run: select @liststr = coalesce(@liststr+',' ,'') + quotena…
7 replies
Can someone show me how to select all patients that hasve seen more than one provider over the past…
12 replies
I need to output a result set into a text file.. not just in the form of data.. i need the rows and…
13 replies
Hi, I have some challenging requirement of getting rows to columns (i.e 20130701, 20130801, 2013090…
6 replies
Implement a function with below logic in an efficient way ...Pass @var1 and return @var2 ...How can…
4 replies
Viewing 15 topics - 601 through 615 (of 12,234 total)
You must be logged in to create new topics.