Topics
Started by
Posts
Last post
Hello, I am currently trying to find out whether the following example of order by in a view would …
10 replies
Hi, I have 4 tables : Create Table #Request ( [requestid] int , [customername] Varchar(30) , [stat…
2 replies
I want to ignore all records in a table where a field, say Address, contains 2 or more (not necessa…
5 replies
Is there a post or an article someplace that has a newbie guide to scripting ? I currently have sev…
5 replies
i want to insert some data into one table where the data to be inserted is being selected from anot…
7 replies
I want to create a stored procedure or function that would create a temp table from CROSSJOIN or IN…
8 replies
Dear Folks, We are facing a problem when we try to update the data from Remote MDB to SQL server pr…
1 replies
Hi All, select 1 where convert(varchar(10),getdate(),103) <= convert(varchar(10),'01/01/2008',…
9 replies
I have a query that outputs table metadata into a complet html report format. In order for the que…
1 replies
Hi, I have a table which has two columns.The first column's data type is text.I need a query to …
1 replies
I have two sql statements that show: school code school name count of students who have used there …
2 replies
I have a couple of datetime fields that I'd like to turn into smalldatetime fields. The problem? …
9 replies
I have the following data in a Table. I wish to have ouput as such, ID Text 12 ABC-XYZDEF 13 ABC…
8 replies
Hi, I have two tables: Accounts { AccountNumber, ParentAccountNumber } Transactions { AccountNumbe…
3 replies
I'm looking to use a CTE to return the equivalent of the following query. SELECT ID, CustName, (S…
4 replies
Viewing 15 topics - 11,491 through 11,505 (of 12,234 total)
You must be logged in to create new topics.