Topics
Started by
Posts
Last post
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
Hi I'm trying to import data from dbf files into sql 2005 tables. I'm using the following syntax to…
1 replies
Hi I'm trying to import data from dbf files into sql 2005 tables. I'm using the following syntax to…
1 replies
hi guys, i have a table this way: id keyword 1 banana 2 apple 3 cherry 4 orange 5 orange 6 apple 7 …
2 replies
Hello Peers, I'm having a requirement where in trying to get products ordered by category-wise orde…
5 replies
Is there a way to rollback a tranaction still preserve data logged to tables within it, or a am i b…
2 replies
Hi, How do we transfer the content of a string variable to a file on a SP? I need to do these: 1. C…
11 replies
I have 3 tables Table 1 is for storing cub scout names, IE SFname, Sname, SUniqueID Table 2 is for …
11 replies
Hi Friends, I have small requirement. declare @p_gender varchar(100) declare @sql varchar(200) set…
2 replies
Hi, We have a table that is setup as a Tree, meaning that a row can be the Parent row for other row…
7 replies
I have a SQL 2005 box that I'd like to convert all recovery models to SIMPLE. ALTER DATABASE (?all…
5 replies
I have a simple script that works on a server (ServerA). When I run that same script on another se…
3 replies
I have a list of tables from one database being migrated into another. To validate the data, I'm wr…
1 replies
Viewing 15 topics - 5,686 through 5,700 (of 12,234 total)
You must be logged in to create new topics.