Topics
Started by
Posts
Last post
Can anyone see what I am missing? CREATE PROCEDURE sp_AdminListApplicants @LocationID int, @Folder…
11 replies
/* we have customer complaints as below. Any staging tables can be created. Task is how a model upg…
26 replies
I have a dates table in a datawarehouse that has Date, Day, Month, Year, Quarter but missing Weeks …
5 replies
Im trying to find ssn's that do not have a complete number, i.e. 213 instead of 213-12-3456 ect. al…
17 replies
Dear All, I have a two table Users && Roles Roles contains following columns Roleid, Rolename,…
4 replies
I have found several examples of changing code that used the *= to LEFT OUTER JOIN, but none with m…
4 replies
I have a dates table in a datawarehouse that has Date, Day, Month, Year, Quarter but missing Weeks …
2 replies
Here's the problem: I have medical claim data. Each record tells me the patient's medical number (…
2 replies
Hi. I have a stored procedure like this CREATE PROCEDURE Test @Param1 AS INT = NULL, @Para…
10 replies
I am writing a query to pull gpa data for our students. We use a transcript sequence of 001 for mos…
3 replies
Hi! Probably a really simple answer to this one, but I can't seem to figure it out... If I for exam…
2 replies
I have a csv file which contains a pc name and two dates (purchase date and warranty date) I need …
2 replies
I have a view (View1) which brings together several tables to get all the data I require. The data …
2 replies
which is better Prepared statements or stored procedures? when do we use pepared statements and whe…
2 replies
I've posted a couple of times recently and have received great answers. Thanks to all. I'm going …
2 replies
Viewing 15 topics - 3,361 through 3,375 (of 17,082 total)
You must be logged in to create new topics.