Topics
Started by
Posts
Last post
I've a table with results from a run contest. Let's say tblResults with the following fields: Parti…
9 replies
How do you create unique identifier such as U82300001 ,U82300002 and U82300003 etc to autogenerate …
9 replies
Hi all, I am lost to do this: @id = 'select disctint id from idtable' @sp1 = 'select sp1 from table…
2 replies
Hi, I have a one major table in my database. And number of process using this table. How do i knwo …
1 replies
Hi, I have a column (Named Description), in which some description e.g Automobiles is stored. User …
15 replies
All, I want to add code at the end of duplicate names. create table emp ( ecode char(5), ename varc…
2 replies
Ok, i come to think im not an idiot, but maybe i am whats wrong with this query. I just want to i…
2 replies
hi I have a result set from a qry like below ORDER_NO | ORDER_TITLE | ORDER_DETAIL | ORDER_DETAIL_…
4 replies
I'm hoping Jeff Modem can help me on this one 🙂 What I've got is a table that tells me when a clock…
16 replies
Hi, I have a situation where I have bunch of 7-digit Encoded text in database like 0304182, now her…
3 replies
I have Select that I concatenate the customer name. SELECT LastName + ', ' + FirstName+ ', ' + Midd…
5 replies
Hi , Can anyone help to write a dynamic function that executes Sub Store procedure. here is the Sc…
32 replies
SELECT 'Hello World!' Hey guys, I hope this isn't a stupid question. I feel like sometimes I do ask…
12 replies
Hi all i have data in date column like jul 5 2009 12:00 AM but i need to have result like 07/05/200…
22 replies
-- In this example I added ANSI_PADDING on and off just to make sure that this is not ANSI_PADDED …
6 replies
Viewing 15 topics - 5,791 through 5,805 (of 12,231 total)
You must be logged in to create new topics.