Topics
Started by
Posts
Last post
Hi All, The following query select Category, count(*) as TotalNumber from (select Case ITPolicyNam…
2 replies
Hi I want to find the Earliest date and RID from the table.I am joining three tables here....But i …
3 replies
select * from DBO.TRACEY_HOLD_POOL_BASE_ACCT A INNER JOIN DBO.EXCEL_POOL_BASE_ACCT B ON A.FY_CD = B…
2 replies
SQL newbie using MS SQL 2005. Have customer order table with customer order numbers that are prefix…
1 replies
I have a query I am attempting to work through. There is a hierarchy of IDs in my table (ADM, RAD,…
2 replies
Hi, I would like to retrieve the value of a column in a specific column depending of the value of …
11 replies
I need one row per cust_id with the max Effdt. the Query: SELECT CUST_ID,EFFDT,SHIP_TYPE_ID FR…
3 replies
Hello ALL, The codes that I wrote and it did not display the output as I wish it to be. But it's st…
1 replies
Hi all, I have multiple record for one particular code in a table. I just want to convert one c…
10 replies
Hi All, I have table with columns TypeId(int) & Description(ntext datatype). The Description c…
2 replies
Hi I have XML and XSD file. how can i import data into sql Server.When i Use SSIS.Xml FIle and XSD…
6 replies
Hi, I have 2 tables User UserId UserName LoginName ============================ 1Vijay Teache…
1 replies
How can i create a SP for a non sysadmin which will allow the user to create a database and his log…
30 replies
I got this simple TSQL line to create a trigger. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO …
6 replies
Hello all, First off - full disclosure here - I am an application developer, not a DBA. Although I …
11 replies
Viewing 15 topics - 6,856 through 6,870 (of 12,230 total)
You must be logged in to create new topics.