Topics
Started by
Posts
Last post
I am guessing I am forgetting something pretty easy and basic but it's driving me nuts tonight. All…
2 replies
Hi all, I want to perform one time update for giving incremented number to a field. I have a table …
9 replies
select distinct a.RevID into #Rev from vwBud as a inner join dbo.datesJi as b on a.RevID=b.RevID wh…
28 replies
I have a field that is a VARCHAR, though maybe 80% of the fields are INT values. How would I get a…
5 replies
drop table #product;drop table #category; Create table #product (productID int, Categories varchar(…
10 replies
Hi, Help me in below case. I would like to see the folder/file size from sql. is there is any exte…
1 replies
Hi folks, I have a query that works fine as a SQL query but I can't use it in the report builder pr…
4 replies
In my organization, we have several linked servers that we setup to join two different types of dat…
6 replies
Does anyone know if it's faster to do "order by" before creating a clustered index? ex) select COLU…
6 replies
Hi all, I have written a SP that selects records from a table (yup simple stuff). If the select sta…
2 replies
I have inherited a colleague's code & I recognize the test for day one of the month, but can s…
5 replies
Does anyone have a really good proper case function for peoples names? - I took a stab at one a lit…
6 replies
I am trying to select rows from a table using a column that I want to compare to another column but…
2 replies
Hi Guys, Can I have your assistance please. I'm trying to write the query below but I'm having issu…
5 replies
Hi there, In the code below the last SELECT statement gets a list of countries, with concatenated s…
4 replies
Viewing 15 topics - 7,471 through 7,485 (of 12,234 total)
You must be logged in to create new topics.