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.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy