Topics
Started by
Posts
Last post
Here's a weird one. SQL 2k5, SP1. I have a SQL login that will be used to write stored procedures f…
27 replies
I need someone to re-write this code for me for the SQL server 2008. I would greatly appreciate it:…
51 replies
HI I have the following two queries, BUT would like to conbine then into one: SELECT DATENA…
2 replies
delete from FALLOUTSDASHBOARD.dbo.IVAPP_ACCEPTANCE_FLOWTHRU_BY_SVCTYPE_SUMMARYinsert into FALLOUTSD…
6 replies
By: SQLRNNR
When i post a query in SSC, by copying from SSMS ans pasting in new topic window, It is pasting lik…
3 replies
Find all the employees who have joined at last day of month in last 3 years (2007,2008,2009)
5 replies
By: kss113
Hi All, I have a small database that needs upgrading as opposed to making changes to the production…
3 replies
Hi All, I have two tables in SQL Server 1.[Customer] ID Name 1001 James 2.[Payments] ID Am…
1 replies
Hi Guys I have got two table as below Table 1 Tests Patient_id date qw 1 …
2 replies
I have a table of sales leads that is ordered by quality of the leads. I need to add a column that…
17 replies
I have an interesting challenge to create duplicate rows based on a column value in a result set. A…
8 replies
I can do this in a procedure - build a "declare myCursor as cursor for ..." string dynamically, add…
1 replies
Please help me with the following THREE questions: 1) True or False, specifying a join hint will fo…
2 replies
Hi, I have a table in the following structure MgrID EmpID EmployeeName 0 1 …
7 replies
Just wanted to check is there any kind of difference if we apply "where" clause along with Join con…
3 replies
Viewing 15 topics - 4,681 through 4,695 (of 12,234 total)
You must be logged in to create new topics.