Topics
Started by
Posts
Last post
I need to find PK column datatypes in a database that are GUID's.. Also need to know if PK's are cl…
2 replies
What is the difference between DTS and SSIS 2005? give more differences between them?
1 replies
Hi Friends, Need small requirement CREATE TABLE MST_GENDER (YR INT, GENDER_DESC VARCHAR(100) ) …
3 replies
Hi Friends, I have an issue while calculating the avg on the below result. Pl find the attached INS…
10 replies
i have a stored proc which will be joining tables from a remote server with tables in local server …
2 replies
I don't even know what to search for to find the answer to my question. I have a table that lists i…
25 replies
I need a function that will return a date "date only, Not date time" the date needs to be today() -…
3 replies
Hi, We have a stored procedure that "partially" ran the other day. Here is the top part and a desc…
3 replies
I have an existing sproc that returns 15 fields and I'd like to use this to insert data into a tabl…
1 replies
alter fnEmp (@empid) begin select * from tblemp or select * from tblemp where empid=@empid in the…
4 replies
Hello all, I have a rather difficult problem and I was hoping to get some input from you all. The …
27 replies
Here's an interesting little problem that I'm trying to solve ... Basically, I have a table of regi…
5 replies
SELECT e.* FROM ESTDETL e WHERE e.JOB = '04-3001' AND e.PHASE > 0 AND (e.ITEM NOT IN (SELECT …
3 replies
hi friends in SQL2005 when i order by a select with more than one column it does not work whats wro…
3 replies
Hi, I am trying to make sure that two transactions running the below SP would not pick up the same …
1 replies
Viewing 15 topics - 5,671 through 5,685 (of 12,231 total)
You must be logged in to create new topics.