Topics
Started by
Posts
Last post
In t-sql 2208 r2, I have sql that looks like the following: select a.custname, i.item, i.amount,…
4 replies
A report developer came to me with the following method of parsing out a string...the data comes fr…
5 replies
Give this data set; declare @BO table (Col1 varchar(50), Col2 varchar(50)) insert into @BO val…
7 replies
Quick question. Normally an update with a join would be something like: Update table1 SET name = t…
9 replies
Hi I have the following Stored Proc But when i run it using only division I give the the following …
3 replies
we have 2 tables (table a and b) select a.* from table a inner join table b on a.col1<> b.col…
4 replies
Hi, How to merge the data from one database to another if we have identity column on both the datab…
3 replies
Hello Everyone I hope that you all are having a great monday so far. I am working with a large amou…
3 replies
The situation is that we have resources (trucks) that perform shifts. Shifts consists of actions. A…
6 replies
Hi Friends i ve the table like create table expense ( bill_date datetime, travel int, fixed int, fo…
5 replies
Hi All, I'm running the query below in SSMS 2008 R2 and it takes longer than expected and when I i…
3 replies
I have a query that is coming back with all my rows from an "IN" where condition. The problem is t…
3 replies
I am trying to modify a script that to back databsae in t-sql. I put it in a stored procedure with …
1 replies
Hi Friends, i ve the date part like '2014-04-01' when i show output like 'apr-14' how to make th…
4 replies
Hi all, We have a wrapper procedure that i am looking at replacing shortly. Basic Layout is somet…
5 replies
Viewing 15 topics - 2,101 through 2,115 (of 10,647 total)
You must be logged in to create new topics.