Topics
Started by
Posts
Last post
I'm working with a development bug database where if someone puts in a bug number, they want to get…
25 replies
Hi , By using below command I am able to get the hashvalue, update ArchiveBBxCcsms set RowChecksu…
4 replies
Hi , Below sp is working fine updating and inserting record properly. But now I want to track the s…
3 replies
Hi All, I think that the below snippet should give a compilation error because I am inserting somet…
3 replies
Can anyone tell me where to look when trying to figure out why the following query is running forev…
16 replies
A web app calls a proc from a sql server which resides on VM box. A proc takes a date range. When I…
29 replies
I have a table of "applicants" with unique applicant id and another table "reviews" with reviews wh…
6 replies
CREATE TABLE TEMPS(MEMBERNBR VARCHAR(11), STARTDATE DATETIME, ENDDATE DATETIME) INSERT INTO TEMPS(M…
2 replies
I am validating an ETL and am experiencing some weird behavior when I compare the numbers in my dat…
3 replies
I have 4 columns, ID, Dept.Number, Address and Grouping ID Dept Address GroupID 165683 32 P O BOX 6…
2 replies
Hi, The following code is pulling back odd date for 'TEST' column - why would that be? Basically I…
8 replies
I have a 94,000 row table that looks like: CREATE TABLE dbo.GrossPay ( [CompanyID] [int] NOT NULL, …
12 replies
Hello, Given the below table, how would you go about finding bars that carry the same brands of sco…
22 replies
This is regarding a SSIS package. After performing a join operation on two tables i get the below r…
2 replies
Hi, Have the following in my SELECT Stataement CASE WHEN com.completion_date IS NOT NULL AND dim.D…
4 replies
Viewing 15 topics - 3,451 through 3,465 (of 4,984 total)
You must be logged in to create new topics.