Topics
Started by
Posts
Last post
SELECT p.rate, p.map, st.case, TOP T.Pay ?????????? FROM payroll p inner join students st on st.pay…
5 replies
I know this has been beaten before and I do know how to import simple text files however does anyon…
1 replies
I was asked to write a SP for a developer with the following logic So here is the table layo…
4 replies
I am working on a dataware house problem. a excel ark each time required will be dumped into datawa…
1 replies
Hi , I have a table with two columns CompanyID,Earnings. Table :: &nb…
1 replies
I have a currently functioning script that updates records based on media they belong to, however s…
4 replies
sp_executesql can only process 4000 characters, but my query exceeds more than 4000 characters. I d…
5 replies
I had seen the: CREATE TABLE #tmp (...) INSERT #tmp (...) EXEC @err = some_sp @par1, @par2 ... appr…
2 replies
Hi, I'm just trying to get my head around the use of case statements in SQL and wondered if someone…
12 replies
I have two tables Table A aid aname acomments TableB bid aid acomments TABLE A aid aname …
7 replies
Hi all, I just want to get the identity column of a table to a variable... I know i can do it …
4 replies
Ok I've done this before but I must have forgotten the correct syntax so I created an example scrip…
3 replies
Hello All I have the following TSQL Begin Tran T1; Begin Tran T2; ALTER TABLE [MyTable] Add&nb…
5 replies
Is there a function to return the first nonempty value from a list of values ? Here is an example …
2 replies
Good morning, To check that a record exists in a table using a stored procedure, I have always done…
8 replies
Viewing 15 topics - 6,166 through 6,180 (of 17,082 total)
You must be logged in to create new topics.