Topics
Started by
Posts
Last post
SELECT AgentIP FROM ConfigDB.dbo.NODES RIGHT OUTER JOIN MainDB.dbo.NODES ON AgentIP = IP_ADDRESS M…
7 replies
I have one table where I can do a SELECT count(*) FROM schema.table1 where contact_type_id = 'Email…
33 replies
good morning guys, i have a question here is the structure of the table and sample data USE [Custom…
8 replies
Can anyone tell me how I can drop a table if it exists. this doesn't work........... ALTER PROCEDUR…
8 replies
I'm trying to insert fields from another database into my db, my problem is that the date field has…
12 replies
Hi Please tell me what is wrong with this syntax: Declare @EndPeriod Numeric, @Consolidate Varchar(…
4 replies
I am extracting data for a particular month from Table A; I need to store this information in Table…
5 replies
the sample table looks like 1 malli o2o2020 2 malli 878hjh8 3 reddy ghhg5 4 reddy 56656 5 e…
20 replies
Looking for a little bit of help, Having a little issue with inserting data from one server to anot…
6 replies
All, I have one scenario. create table emp ( eno int, ename varchar(5), isemp bit, iscont bit, isa…
9 replies
Hi, I am used to working with TSQL code developed for SQL Server 2000 even though where I work we h…
2 replies
In my database, I have 2 tables, Orders and OrderDetails. This may be obvious, but Orders holds in…
1 replies
:-D:-D Hello all! Here's the statement that I'd like to optimize and make more efficient. UPDATE B…
5 replies
I have a table in SQL with dates (Every date within the year) and whether the day is a working day …
2 replies
I am basically new to sql server 2005 and I have a query question to ask. I want to create a fin…
1 replies
Viewing 15 topics - 4,381 through 4,395 (of 12,230 total)
You must be logged in to create new topics.