Topics
Started by
Posts
Last post
Hi, I have a table (Cleansing.Customers) which contains AccountNum, DM_Source_Id columns (both form…
33 replies
Hi I have done this in sql server 2000 but am not sure how to accomplish this with 2005. I would li…
3 replies
Hi, All hopefully it'll be an easy one for you. Scenario: every time a certain record gets inserte…
2 replies
Hi, I am trying to write this count below to count team reports for a team. I need to restrict the …
2 replies
By way of example: I have a table called Table1. It has one column called Column1 of XML data type…
2 replies
Hi people, unfortunately i've inherited a database where lots of emphasis has been put on the stora…
11 replies
I am new to this. This is my stored procedure in SQL server 2005: ALTER PROCEDURE [dbo].[strpro…
5 replies
How to send a query resultset via email in the message body section not as an attachment? I have a …
6 replies
I have just gotten back from vacation so my brain is not fully back into work mode yet and I came a…
8 replies
Dear all, I want the list of columns of Local Temporary Table (#MyTable) in one of my stored proced…
11 replies
In sql server getDate() & current_timesatmp gives data & time.. But i am not access this …
2 replies
Dear All I have a stored procedure that is outputting a PageID and StatusID. PageIDs can be any in…
3 replies
Dear Friends, I have a table which contains the rights of groups for the file types. Another table …
2 replies
Hi, Can anyone help me to construct a sql query? I have a query that calculates quantity of hours …
5 replies
Hello again, I know there's 2 versions of inner joins: 1: select * from r_user ru inner join r_con…
4 replies
Viewing 15 topics - 9,391 through 9,405 (of 12,230 total)
You must be logged in to create new topics.